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(4970724,4970757,4970760,4970773,8067905,8067921,8067922,8067923,8067927,8067932,8067938,8067939,8067940,8067942,8067943,10939390,10939419,10939425,8065799,8065841,8065842,10623491,10623492,10623505,10623508,10623736,10622363,10622419,10620750,10620791,10613967,10613981,10613982,10613983,10610984,10610985,10613987,10613999,10614022,10614023,10614024,10614027,10614028,10614029,10614034,10614044,10611048,10614048,10614050,10611053,10611054,10614054,10611055,10614055,10614056,10614057,10614064,10611126,10614210,10614259,10614274,10614282,10611293,10611313,10614314,10614316,10614327,10614328,10614329,10611334,10611352,10611367,10611368,10611369,10611370,10614372,10614373,10614376,10614452,10614456,10614475,10614476,10614486,10614499,10614501,10614502,10614516,10614518,10614530,10614533,10614569,10614588,10614592,10614626,10614627,10614632,10614656,10614658,10614669,10611708,10611710,10611711,10614726,10614727,10614730,10614731,10611744,10611751,10611752,10611753,10611764,10611788,10611789,10611801,10611816,10611818,10614819,10614820,10614821,10611823,10611830,10611858,10611859,10611860,10611861,10611862,10614864,10611895,10614948,10611989,10612051,10612053,10612069,10612082,10612083,10609151,10609152,10609158,10609165,10612168,10612169,10609169,10609170,10609171,10612179,10612193,10609194,10609195,10609237,10609239,10609243,10609250,10609261,10609262,10612263,10612273,10609285,10612313,10612328,10612344,10609347,10609348,10609350,10609351,10609352,10609354,10612354,10609355,10609357,10609358,10609359,10609360,10609362,10609363,10609364,10609366,10609367,10609368,10609369,10609376,10609377,10609378,10609385,10609386,10609397,10609398,10609402,10609407,10612410,10612413,10609425,10612428,10609438,10609443,10609444,10609470,10609471,10609505,10612506,10609524,10612529,10612555,10609556,10612556,10612557,10609558,10612558,10612559,10612563,10609565,10612594,10612595,10609614,10612620,10609621,10609622,10612623,10609661,10609662,10612670,10609676,10609677,10609685,10609694,10609695,10609697,10609704,10609705,10609713,10609719,10609723,10612724,10612725,10612731,10612732,10612734,10612736,10612737,10609739,10609742,10612746,10609750,10609751,10609752,10612755,10612757,10612763,10609764,10612765,10609765,10612766,10612767,10609770,10612771,10609772,10612772,10612773,10612774,10612775,10612776,10612777,10612778,10612779,10612780,10612782,10612800,10612803,10612809,10612811,10609811,10612812,10612813,10612815,10609815,10612816,10609817,10612817,10609818,10609819,10609824,10609826,10609827,10609828,10609829,10609830,10609838,10609843,10609844,10609846,10609847,10609848,10609849,10609850,10609851,10609852,10609853,10609854,10609855,10609856,10609857,10609858,10609859,10609860,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10609870,10609871,10609872,10609873,10609874,10609875,10609876,10609877,10609878,10609879,10609880,10609881,10609882,10612883,10609883,10612884,10609884,10609885,10609886,10609887,10609888,10609889,10609890,10609891,10609892,10609893,10609894,10609895,10609896,10612897,10609897,10612898,10609898,10609899,10609900,10609901,10609902,10609903,10609904,10612904,10609905,10612905,10609906,10609907,10612907,10609908,10609909,10612910,10609910,10609911,10612911,10612912,10609912,10609913,10612913,10612914,10609914,10609915,10609916,10609917,10609918,10609919,10609920,10609921,10609922,10609923,10609924,10609925,10609926,10609927,10609928,10609929,10609930,10609931,10609932,10609933,10609934,10609935,10609936,10609937,10609938,10609939,10609940,10609941,10612941,10609942,10609943,10609944,10612945,10609945,10609946,10609947,10609948,10609949,10609950,10609951,10609952,10609953,10609954,10609955,10609956,10609957,10609958,10612958,10609959,10609960,10609961,10609962,10609963,10609964,10609965,10609966,10609967,10609968,10609969,10609970,10609971,10612973,10609975,10609976,10609978,10609979,10612979,10612980,10609980,10609981,10609983,10612984,10609988,10609995,10609996,10609997,10610006,10613019,10610025,10610030,10613036,10610046,10610054,10613079,10613080,10610098,10610108,10610127,10610128,10610129,10610130,10610131,10610132,10610133,10610152,10613193,10610214,10610233,10610237,10613242,10613243,10610259,10613265,10613266,10610268,10610271,10610274,10613286,10610289,10610298,10610318,10610319,10613322,10613349,10613350,10613356,10613357,10610359,10613359,10613362,10613363,10613369,10613381,10613387,10610403,10610404,10610405,10610406,10610407,10610408,10610409,10610410,10610411,10610412,10610414,10613420,10613440,10613441,10613442,10613453,10613464,10610466,10610492,10610493,10613508,10613509,10613547,10613562,10610568,10613637,10613639,10613640,10613641,10613646,10610668,10613682,10613683,10610691,10610692,10613693,10610693,10610694,10610698,10613757,10610794,10613797,10613801,10613802,10613808,10613809,10613829,10613830,10613831,10610836,10613837,10613840,10613844,10613853,10610854,10613858,10613859,10613860,10613874,10613904,10613908,10613909,10613912,10610915,10610916,10613928,10613929,10610933,10610939,10613942,10610942,10613943,10610958,10512852,10419253,10419255,10416256,10419258,10416259,10419262,10419285,10419288,10419292,10419295,10419296,10415313,10415314,10415323,10415342,10415343,10415344,10415355,10415356,10415357,10415358,10415359,10415360,10415361,10416362,10416363,10419371,10419372,10416383,10416385,10419388,10419389,10419390,10416398,10419407,10419408,10415416,10415417,10415418,10415419,10415424,10415425,10415426,10415427,10415430,10415431,10415432,10415433,10415434,10415435,10415438,10415439,10415440,10415441,10415442,10415443,10416444,10415444,10416445,10415445,10415446,10416446,10416447,10416448,10416449,10416450,10416451,10416452,10416453,10419470,10415481,10415487,10419493,10415495,10415507,10415537,10415538,10415616,10415641,10415642,10419653,10419654,10419655,10419659,10419661,10419662,10419663,10419664,10419665,10415666,10415668,10415671,10415672,10415673,10415675,10415676,10415677,10415678,10415680,10419759,10419760,10419761,10419768,10419769,10419770,10419771,10419772,10419773,10419774,10419775,10419776,10419777,10419778,10419779,10419780,10419781,10415782,10415783,10415784,10415785,10415786,10415787,10415788,10415941,10416076,10416113,10416114,10416117,10416118,10416182,10416183,10416185,10416186,10416187,10416189,10416190,10416191,10416192,10416193,10470876,10470877,10470878,10470879,10470880,10470881,10470882,10470883,10470884,10470885,10470886,10470887,10470888,10470889,10470890,10470891,10470892,10470893,10470894,10470895,10470896,10470897,10470898,10470899,10470900,10470901,10470902,10470903,10470904,10470905,10470906,10470907,10470908,10470909,10470910,10470911,10470912,10470913,10470914,10470915,10470916,10470917,10470918,10470919,10470920,10470921,10470922,10470923,10470924,10470925,10470926,10470927,10470928,10470929,10470930,10470931,10470932,10470933,10470934,10470935,10470936,10470937,10470938,10470939,10470940,10470941,10470942,10470943,10470944,10470945,10470946,10470947,10470948,10470949,10470950,10470951,10470952,10470953,10470954,10470955,10470956,10470957,10470958,10470959,10470960,10470961,10470962,10470963,10470964,10470965,10470966,10470967,10470968,10470969,10470970,10470971,10470972,10470973,10470974,10470975,10470976,10470977,10470978,10470979,10470980,10470981,10470982,10470983,10470984,10470985,10470986,10470987,10470988,10470989,10470990,10470991,10470992,10470993,10470994,10470995,10470996,10470997,10470998,10470999,10471000,10471001,10471002,10471003,10471004,10471005,10471006,10471007,10471008,10471009,10471010,10471011,10471012,10471013,10471029,10471078,10471124,10471125,10471246,10469900,10469966,10470147,10470148,10470155,10470664,10470665,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470695,10470706,10470735,10470736,10470737,10470738,10470739,10470740,10470741,10470742,10470743,10470744,10470745,10470746,10470747,10470748,10470749,10470750,10470751,10470752,10470753,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470762,10470763,10470764,10470765,10470766,10470767,10470768,10470769,10470770,10470771,10470772,10470773,10470774,10470775,10470776,10470777,10470778,10470779,10470780,10470781,10470782,10470783,10470784,10470785,10470786,10470787,10470788,10470789,10470790,10470791,10470792,10470793,10470794,10470795,10470796,10470797,10470798,10470799,10470800,10470801,10470806,10470807,10470811,10470812,10470814,10470815,10470816,10470817,10470818,10470819,10470820,10470821,10470822,10470823,10470824,10470825,10470826,10470827,10470828,10470829,10470830,10470831,10470832,10470833,10470834,10470835,10470836,10470837,10470838,10470839,10470840,10470841,10470842,10470843,10470844,10470845,10470846,10470847,10470848,10470849,10470850,10470851,10470852,10470853,10470854,10470855,10470856,10470857,10470858,10470859,10470860,10470861,10470862,10470863,10470864,10470865,10470866,10470867,10470868,10470869,10470870,10470871,10470872,10470873,10470874,10470875) 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'