QUERY: SELECT
p.products_id,
p.products_model,
p.label_ids,
p.main_category,
p.products_ean,
p.products_fsk18,
p.products_quantity,
p.products_quantity_min,
p.products_quantity_step,
p.products_price,
p.products_price_small_opt,
p.products_price_opt,
p.products_purchase_price,
p.small_opt_purchase_price,
p.count_small_opt_purchase_price,
p.count_opt_purchase_price,
p.opt_purchase_price,
p.postavshik,
p.suplier_catalog_id,
p.postavshik_comment,
p.name_catalog_id,
p.products_tax_class_id,
p.products_image,
p.products_vpe,
p.products_vpe_status,
p.products_vpe_value,
p.products_currency,
p.products_page_url,
p.video,
p.show_video,
pd.products_short_description,
p.rev_total,
p.rev_rating,
pd.products_name,
p.products_ordered,
pd.products_short_description,
s.status,
IF(s.status, s.specials_new_products_price, 0) as specials_new_products_price,
m.manufacturers_name,
m.manufacturers_id FROM products AS p
LEFT JOIN products_description AS pd ON (p.products_id = pd.products_id)
LEFT JOIN manufacturers AS m ON (p.manufacturers_id = m.manufacturers_id)
LEFT JOIN specials AS s on p.products_id = s.products_id
LEFT JOIN products_to_categories as p2c2 ON (p2c2.products_id=p.products_id)
LEFT JOIN categories as c ON (c.categories_id=p2c2.categories_id) WHERE p.products_status = 1 AND c.categories_status = 1 AND pd.language_id = '1' AND p.products_id IN(10843140,7075905,7201747,8559530,10843451,10843452,7076182,7068278,10103997,10103998,10103999,10104000,10104001,8618710,7068458,7068459,7068460,7068462,8836497,7068590,10843912,10843913,8560162,8836782,10844184,10872765,10872766,10872767,7073962,7073980,4968437,8560681,7074224,7074246,3227340,7066475,3227469,10199773,7066571,10844871,7074591,7074600,8561100,8561178,8573418,8561212,10929586,10929587,10929588,10929589,10929590,10929591,10929592,10929593,10929594,10929595,10929596,10929597,10929598,10929599,10842115,10842116,10102541,10102542,3927847,10842337,7067080,7075082,7067104,8835167,7067297,7075327,7067335,10236575,7067398,7075451,8835466,7075584,7075607,7075628,10842912,8559108,8559109,8627887,8627888,8618098,10221061,10221062,10221063,10221064,10221065,10221066,10221067,10221068,10221069,10221070,10221071,10221072,10221073,10221074,10221075,10221076,10221077,10221078,10221079,10221080,10221081,3235791,10221082,10221083,10221084,10221085,10221086,10221087,10221088,10221089,10221090,10221091,10221092,10221093,10221094,10221095,10221096,10221097,10221098,10221099,10221100,10221101,10221102,10221103,10221104,10221105,10221106,10221107,10221108,10221109,10221110,10221111,10221112,10221113,10221114,10221115,10221116,10221117,10221118,10221119,10221120,10221121,10221122,10221123,10221124,10221125,10221126,10840169,10221127,10221128,10221129,10221130,10221131,10221132,10221133,10221134,10221135,10221136,10221137,10221138,10221139,10221140,10221141,10221142,10221143,10221144,10221145,10221146,10221147,10221148,10221149,10221150,10221151,10221152,10221153,10221154,10221155,10221156,10221157,10221158,10221159,10221160,10221161,10221162,10221163,10221164,10221165,10221166,10221167,10221168,10221169,10221170,10221171,10221172,10221173,10221174,10221175,10221176,10221177,10221178,10221179,10221180,10221181,10840292,7064018,7072019,10840356,3926134,3926136,10840527,7072276,3236268,10273610,10273611,10273612,10273613,10273614,10273615,10273616,10273617,10273618,10273619,10273620,10273621,10273622,10273623,10273624,10273625,10273626,10273627,10273628,10273629,10273630,10273631,10273632,10273633,10273634,10273635,10273636,10273637,10273638,10273639,10273640,10273641,10273642,10273643,10273644,10273645,10273646,10273647,10273648,10273649,10273650,10273651,10273652,10273653,10273654,10273655,10273656,10273657,10273658,10273659,10273660,7064423,10273661,10273662,10273663,3926346,10273664,10273665,10273666,10273667,10273668,10273669,10273670,10273671,10273672,10273673,10273674,10273675,8615885,10234829,10234830,8557090,7199523,7064783,7064793,3926725,3926917,7072998,8616429,10101726,7065138,8557671,10857270,3927387,7073512,7065577,7065673,4968024,7065731,7065814,8558288,8558289,7070849,7070880,7070948,7070957,8907583,8907584,3234984,8555519,3924979,10839384,7071249,7071325,3235289,7071357,8555961,7071528,10839899,10221033,10221034,10221035,10221036,10221037,10221038,10221039,10221040,10221041,10221042,10221043,10221044,10221045,10221046,10221047,10221048,10221049,10221050,10221051,10221052,10221053,10221054,10221055,10221056,10221057,10221058,10221059,10221060,7068906,10837227,10257189,10257190,10257191,8612400,8542146,8542152,3233268,7069381,10837707,8579143,7069448,8554099,8554116,8554267,10838134,3923792,10838285,7070013,10838356,3924354,3234557,7070721,7070722,10839043,8860683,10848127,10848131,10848175,10433075,10850822,10848349,10848373,10425995,10433224,10848439,10848467,10623383,8540425,8610902,10426448,10426449,10426450,10426451,10426452,8552544,8552892,8552897,8541783,8541792,10852601,10865624,10847144,10847255,10622125,10622126,10432091,8622474,10863011,10863012,10863013,10863014,10863015,10863016,10847547,8622679,8622787,10847724,10847776,10928299,10432759,8561406,8620371,8620557,8620558,8620559,8620560,8620561,8620562,8838249,8838250,8838251,8561877,10861285,10861286,8570492,9214703,10845823,10448170,10448216,10448254,10240104,10240105,10240106,10240107,10240108,10846206,10930919,9215282,10846397,10846398,10846399,10846400,10846401,10846402,10240384,9215408,9215409,10188540,10922130,10922131,10922132,8621855,10279826,10431840,10847063,9189321,9189333,3654977,9916015,10614466,10614467,10614468,9181903,9181904,9181905,9181906,9181907,9181908,9181909,9181910,9181911,9181912,9181913,9181914,9181915,9181916,9181917,9181918,9181919,9181920,9181921,9181922,9181923,9181924,9181925,9181926,9181927,9181928,9181929,9181930,9181931,9181932,9181933,9181934,9181935,9181936,9181937,9181938,9181939,9181940,9181941,9181942,9181943,9181944,9181945,9181946,9181947,9181948,9181949,9181950,9181951,9181952,9181953,9181954,9181955,9211381,9187389,9187415,8565933,9219705,10612426,10612427,9211797,9211798,9211799,10612806,9212293,7058529,10120588,10558293,10613236,10613237,10613238,10613239,3653985,6677237,9189104,9189128,9189198,9193363,9209501,7056343,3285992,10512151,10512152,10512153,10512154,4975234,4975235,6674591,9178844,9178845,9178846,9178847,9178848,9178849,9178850,9178851,7057089,7057090,7057091,7057092,7057093,7057094,7057095,7057096,3652212,10416581,10416582,10416583,10416584,10416585,10416586,10428203,10428204,10418853,10418854,9209143,10467107,6678901,10471462,10471463,10471464,10471465,10471466,10471467,10471468,10471469,10471470,3656297,9191092,10465758,10465769,6679500,8855125,8855126,8855127,8855128,3656511,8855129,8855130,8855131,3656514,10465909,3656774,6667668,10466330,10466331,9207786,9176233,10898732,10898733,10889071,8594175,8594176,8594177,10175437,10170677,10170678,10170679,10899858,10899859,10899860,10899861,10899862,10899863,10899864,10899865,10899866,10899867,10899868,10899869,10899870,10899871,10899872,10899873,10899874,10910015,10917889,10917890,10917891,10917892,10183955,10183956,10183957,10183958,10164048,10179191,10179192,10885595,10885596,10172258,10916803,10916804,10916805,10916806,10916807,10916808,10916809,10916810,10916811,10916812,10172878,10187898,10631448,10631449,10168205,10882237,10163360,10917364,10917365,10917366,10580112,10580113,10580114,10611659,10603649,10603650,10603651,10603652,10570218,10588268,10588269,10588270,10588271,10588272,10588273,10588274,10588275,10588276,10588277,10588278,10588279,10588280,10588281,10588282,10588283,10588284,10588285,10588286,10588287,10654472,10580064,10580065,10580066,10580067,10580068,10580069,10580070,10580071,10580072,10580073,10580074,10580075,10580076,10580077,10580078,10580079,10580080,10580081,10580082,10580083,10580084,10580085,10580086,10580087,10580088,10580089,10580090,10580091,10580092,10580093,10580094,10580095,10580096,10580097,10580098,10580099,10580100,10580101,10580102,10580103,10580104,10580105,10580106,10580107,10580108,10580109,10580110,10580111,10545880,10545881,10550503,10524779,10415253,10415254,10508271,10508272,10508338,10423699,10423700,10423701,10463007,10463008,10496336,10479587,10481852,10481853,10481854,10481855,10481856,10481857,10481858,10481859,10481860,10481861,10481862,10481863,10481864,10481865,10481866,10481867,10481868,10481869,10481870,10481871,10481872,10481873,10481874,10481875,10481876,10481877,10481878,10481879,10481880,10481881,10481882,10481883,10481884,10714807,8563512,10714968,10462404,10462405,8562093) GROUP BY p.products_id ORDER BY CASE WHEN products_price = 0 THEN 99999999 WHEN products_price > 0 THEN products_price END asc ,p.products_specials desc
ERROR: Unknown column 'p.products_specials' in 'order clause'