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(10975623,8068868,10930276,10975743,10975744,10975745,10975746,10975750,8620918,10975786,10975789,8620943,8620954,10975810,10988822,10931032,10931042,10975849,10975871,10975938,10962941,10975955,10975972,10975973,10976008,7068333,8621174,10976027,10976028,10976029,10943817,10943849,10976135,10976164,10976205,10976231,9215260,10846501,8583263,8583264,8583265,8583266,8067235,8067236,8067238,8067239,9216032,9216080,7074459,7074474,7074497,7074506,7074536,10437497,10437498,10437583,7066748,10850054,7067033,10497923,10497958,10497988,11039954,11039956,11039977,11039978,10929588,10929593,10845293,8591816,8591839,8591857,8591858,3228112,3228139,10930007,8561778,3228254,8620686,10975599,11037626,11037627,10103076,10998685,10931388,10931403,10972805,10972819,10972820,10972821,10972822,10972823,10972827,10972837,10972844,10972849,10972867,10972897,10972902,10972904,8618071,10972921,10972925,10972930,10931685,10931912,10931927,11038285,11038286,8595283,10843482,8618700,8618701,8618702,8618703,8618708,7064908,7064936,8559895,7064976,8572165,7065007,7065008,10843781,10104159,7065049,7065066,10932444,10843879,10843884,10999835,10999848,11038902,7073233,11038950,11038963,11038965,10104411,8572468,11038979,10932650,10932654,8066369,8572631,8572666,7073508,7073581,10099833,10933040,10929032,10099924,10997651,10984750,10984752,8616917,8616937,8558223,8558270,11037200,10998214,11037226,11037227,10857946,4430358,4430359,10102971,11037530,10100117,10956696,3235828,3235835,10996112,10996158,10996159,10944918,3236084,11009419,11009625,8615776,8072696,11009719,11047954,8072799,8072815,8072831,8072851,8072871,8072889,8072907,8072923,8072941,10957904,8072956,8072972,11035923,11035924,8616147,3926732,3926740,3926741,3926754,11010177,11010180,11010181,11010182,11010183,11010184,11010189,11010192,11010193,11010198,11010199,11010200,11010203,8565229,11010208,11010209,11010210,11010211,11010215,11010216,11010227,11010230,11010240,11010241,11010242,11010246,11010247,11010248,11010249,8557523,8557524,8557525,8557527,7156869,11007083,11007084,10994262,3234001,10994272,10924319,3234209,8613771,10968635,10968636,10955680,10955752,10955771,10955856,10955858,10955900,10955905,10955906,10924782,10924789,10924809,10924813,10924815,10924831,10955990,10924848,10956027,10956071,11008269,11008270,11008271,11008272,3235009,10956330,4938400,10956400,10956401,10855062,4938501,4938513,10956476,4938525,4938537,10956502,4938549,4938561,4938573,10619882,4938585,4938597,4938609,4938621,3232585,7155815,10617327,7155920,8553333,8553334,8553347,8553353,8553369,8553372,8553373,8553396,8553400,8553401,8553402,8553404,8553408,8553412,8905534,8553425,8553427,8553429,8553430,8553437,8542006,8542007,8553441,8553467,3923069,8542196,3923088,3923128,8905873,7156463,7156464,7156465,10967612,7156469,7156474,8576337,9216858,10951865,9217028,10952029,10952114,10952122,8610370,8610385,8610424,8610440,8610490,8610530,10952369,3582143,8610611,3582183,8540471,10952860,10621356,8904688,8904691,7155371,7155394,7155396,9221272,10613964,9221274,9221276,9221279,9221280,9221281,9221282,9221284,9221287,9221289,9221292,9221325,9221329,9221330,9221335,9221337,9915634,9221401,9221403,9221407,9221409,9221410,9221413,9205622,9205701,3655044,9197876,9197877,9197887,9181933,9181934,9181935,9181936,9181937,9181941,8568479,8568480,8568490,8568504,8568525,10559875,3655370,9174272,3652531,10563195,10563196,10563197,10563198,10563199,3652604,9163427,7057685,8566021,9163520,8542707,8566040,9163544,9163548,10563370,9163560,10563378,9163573,9163587,9163668,9163688,7057856,8851524,9163825,9163873,9163878,9219875,9163906,6676141,6676146,6676162,9163968,9163997,3653252,9164052,9164072,9164175,9164185,10609889,9164287,10561135,10561136,9172343,9164359,9196397,9196398,10558323,9164517,9164538,9164539,9172582,10561424,10561425,10561426,9196657,10564471,10564472,10564473,10564482,10564483,10564610,10564611,10564612,10564613,10564624,10564625,10564640,10564641,10564642,10564643,10564663,10564681,9915092,10564725,9915232,6677353,8852976,8852977,9197153,9221141,9221145,9221146,9221147,9221148,9221149,9221150,9221151,9221153,9221154,9221158,9221159,9221164,9221169,9221171,9221172,9221173,9221175,9221176,9221178,9221180,9221184,9221186,9221187,9221188,9221190,9221192,9221194,9221196,9221197,9221198,9221202,9221203,9221204,9221206,9221208,9221211,9221212,9221215,9221216,9221218,9221219,9221221,9221222,9221223,9221228,9221229,9221231,9221233,9221239,9221240,9221243,9221248,9205277,9205278,9221251,9205279,9205280,9221254,9221257,9221259,9221261,9221264,9221265,9221266,9221268,9221271,9209562,9209563,9209564,4974731,8849755,8849756,9170022,9170023,10518077,10518112,10518113,10518114,10518119,10518120,10518121,10518122,10518123,10518124,10518125,2809272,8850817,9211007,10516919,10516920,8552432,10514958,10514959,8850990,7055000,7055035,7055072,7055093,7055094,10125129,7055103,7055104,7055106,7055108,7055109,7055112,7055116,7055118,7055120,10125152,7055122,7055125,6681174,7055135,10125172,7055142,7055143,7055145,7055147,7055149,7055150,7055152,7055170,7055183,9185066,10428497,9206343,9190345,9190346,9206357,9206362,9190364,9190405,10462996,9198430,9198431,9198460,9198468,3962789,9206473,9198473,9198483,9198484,10122825,9190905,9190965,6671339,6671348,6671364,9207288,9191361,9183442,8551152,10427528,9200239,9200240,10878553,10878601,10878623,10946456,10946457,10184774,10908820,10159912,10185003,10185095,10185102,10175225,10175251,10175299,10185378,10879505,10185542,10175642,10175663,10175664,10175665,10175666,10175667,10175668,10175669,10175670,10175671,10175672,10175673,10175674,10175675,10175676,10175677,10175678,10175679,10175680,10175707,10175708,10175709,10175710,10175725,10160726,10175728,10175729,10175730,10175731,10175732,10175733,10175734,10175743,10175746,10175747,10175748,10175749,10175750,10175751,10175752,10175753,10175754,10175755,10175756,10175757,10175772,10175774,10175775,10175776,10160931,10170946,10185950,10170989,10186013,10186078,10186099,10161145,10186411,10882548,10168586,10168587,10168588,10907586,10627092,10627096,7001090,10907916,7001105,10627424,7001167,10183998,10183999,10184000,10184034,7001228,7001229,10627566,10174291,10184307,8593307,10174336,10174344,10184355,10174361,10184367,10878383,10627958,10186504,10905578,10905589,10905590,10905591,10905624,10630256,10630265,10630266,10156797,10630277,10630278,10156867,10156878,10156895,10156913,10156924,10875963,10156977,10896015,10157065,10886085,10881130,10157147,10157189,10157195,10157242,10167272,10891310,10891311,10911319,10911320,10911341,10911342,10630894,10911406,10911407,10911408,10911409,10911410,10911411,10911412,10911413,10911414,10911415,10911416,10157466,10630977,10167499,10167500,10167501,10167502,10630981,10167503,10911492,10167504,10167505,10167506,10167507,10167515,10167516,10167517,10167518,10167519,10167520,10167524,10157643,10157734,10157778,10911835,10157987,10173034,10173174,10158233,10907241,10877250,10907255,10580183,10652315,10608198,10580477,10580478,10652563,10580520,10580521,10580532,10580535,10580536,10649651,10605562,10605563,10605565,10650386,10647483,10606334,10603495,10645079,10645113,10645147,10645156,10607471,10645731,10649074,10537858,10539887,10539888,10539891,10539892,10539893,10539894,10539905,10539906,10539942,10539943,10539944,10539945,10539946,10539947,10539948,10539949,10539950,10539951,10539952,10539953,10539954,10539955,10539956,10539982,10539983,10539984,10539985,10539986,10539987,10539988,10539989,10540002,10540018,10540019,10540020,10540021,10540046,10540055,10540063,10540064,10540065,10538065,10540066,10504568,10504569,10504570,10504571,10504572,10492113,10475168,10488329,10473372,10475507,8562931,8563051,8563052,10490748,10410275,10471933,10486944,10714654,10714664,10714690,10472174,10412531,10715092,10715247,10485635) 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'