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(10930264,10861551,8574471,8574477,8574482,8574483,8574485,8574486,8574488,8574494,8574497,8574499,8574500,8574505,8574507,8574512,8574515,8574525,8574526,8574527,8574528,8574531,8574532,8574533,8574534,10848667,10848668,10848669,10848670,10848671,10848672,10848673,10848674,10848675,4970746,3229204,3229205,8631606,8631607,8631608,8631701,8631702,8631703,7066179,10850020,8632499,8594791,8594792,10866550,10866551,10866552,10866553,10866554,10866555,10866556,10866557,10866558,10866559,7201651,8595231,8595232,8595233,3899092,8595289,7202129,7202130,7202137,7202139,7202140,7202162,7202200,7202208,7202234,7202286,5654544,10859601,7202652,7202653,7202743,7202745,7202760,7202761,8629472,10857417,10857418,10857419,10857420,10857421,10857422,10857423,10857424,10857425,10857426,8834750,8627068,7200774,7200775,7200776,10857844,10857845,10865986,8627500,8627501,8627502,8627503,8627504,8627505,8627506,8627507,8627508,8627509,8627510,8627511,8627512,8627513,8627514,8627515,8627516,8627517,8627518,7198734,7198735,7198736,7198737,7198738,7198739,7198740,7198741,7198742,7198743,7198744,7198745,7198746,7198747,7198748,7198749,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,10863827,10863828,10863829,10863830,10863831,10863832,10863833,10863834,10863835,10863836,10863837,10863838,10863839,10863840,10863841,10863842,10863843,10863844,10863845,10863846,10863847,10863848,10863849,10863850,10863851,10863852,10863853,10863854,10863855,10863856,10863857,10863858,10863859,10863860,10863861,10863862,10863863,7199456,7199457,7199458,7199459,7199460,7199461,7199462,7199463,7199464,7199465,7199466,7199467,10101496,11048307,11048308,11048365,8626261,7199896,10857132,7200093,7200130,7200143,7200146,3923393,7196252,3923612,3923615,3923616,3923617,7196576,7196577,7196578,7196579,7196580,7196581,7196582,7196583,7196584,7196585,7196586,7196587,7196588,7196589,7196590,7196591,7196592,7196593,7196594,7196595,7196596,7196597,7196598,7196599,7196600,7196601,7196602,7196603,7196604,7196605,7196606,7196607,7196608,7196609,7196610,7196611,7196612,7196613,7196614,7196615,7196616,7196617,7196618,7196619,7196620,7196621,7196622,7196623,7196624,8906804,7197045,8070780,8070781,8070782,8624357,8624358,7198018,8624418,7198019,7198020,7198021,10852282,10852283,10852284,10852285,10852286,10852287,10852288,10852289,10852290,10852291,10852292,10852293,10852294,10852295,10852296,10852297,10852298,10852299,10852300,10852301,10852302,10852303,10852304,10852305,10852306,10852307,10852308,8905725,10954399,10954400,8905973,8905974,8905975,8905976,8905977,8905978,8905979,8905980,10615405,10615406,10615407,10615408,10615409,10615410,10615411,10615412,10615413,10615414,10615415,10615416,10615417,10615418,10615419,10615420,10615421,10615422,10615423,10615424,10615425,10615426,10615427,10615428,10615429,10615430,10615431,10615432,10615433,10615434,3581887,3581888,10851049,10851050,10851051,10851052,10851053,10851054,10851055,10851056,10851057,10851058,10851059,10851060,10851061,10851062,8904489,8904490,8904491,8904492,8904493,8904494,8904495,8904496,8904497,8904498,8904499,8904500,8904501,8904502,8904503,8611401,8611402,8611449,8904791,8904792,8904793,8904794,8904795,8904796,8904797,10616855,10616879,10616880,10616881,8853380,10611337,10611338,10611339,10714178,10614424,10611830,10611831,10611832,10611833,10611834,10611835,6666257,6666258,10611954,10612334,8862559,8566584,8566585,10609838,10613083,8852341,8852342,10610694,9169300,9169491,9169492,9169493,9169494,9169495,9169496,9169497,9169498,9169499,6673730,6673804,9169833,9912143,6674148,10118231,10118383,10118458,8850104,9178397,10118594,9178398,10118595,9912948,9912993,9912994,9912995,9912996,9912997,9912998,9912999,9913000,9913001,9913002,10417282,10417283,10417284,9168363,10417285,10417286,10417287,10417288,10417289,10417290,10417291,10417292,10417293,10417294,10417295,10415448,9910901,10419159,9169252,10117470,10117471,10468891,10471124,10471125,8550166,8550167,8550168,8550169,8550170,8550171,8550172,8550173,8550174,8550175,8550176,8550177,8550178,8550207,10469957,10469958,10469959,10469960,10469961,10469962,10469963,10469964,10469965,10469966,10469967,10469968,10469969,10469970,10469971,10469972,10469973,10469974,10469975,10469976,10469977,10469978,10469979,10469980,10469981,10469982,10469983,10469984,10469985,10469986,10469987,10469988,10469989,10469990,10469991,10469992,10469993,10469994,10469995,10469996,10469997,10469998,10469999,10470000,10470001,10470002,10470003,10470004,10470005,10470006,10470007,10470008,10470009,10470010,10470011,10470012,10470013,10470014,10470015,10470016,10470017,10470018,10470019,10470020,10470021,10470022,10470023,10470024,10470025,10470026,10470027,10470028,10470029,10470030,10470031,10470032,10470033,10470034,10470035,10470036,10470037,10470038,10470039,10470040,10470041,10470042,10470043,10470044,10470045,10470046,10470047,10470048,10470049,10470050,10470051,10470052,10470053,10470054,10470055,10470056,10470057,10464205,10464206,10464207,10464208,10464209,10464210,10464211,976548,10116249,10628321,10889589,10889742,10885021,10885022,10885023,10877528,10877529,10877530,10877531,10877532,10877533,10887945,10888021,10888418,10888419,10888420,10888421,10888422,10888423,10888424,10888425,10888426,10888427,10888428,10888429,10888430,10888431,10888432,10888433,10888434,10888435,10888436,10888437,10888438,10888439,10888440,10888441,10888442,10888443,10888444,10888445,10888446,10888447,10888448,10162167,10162168,10167961,10167979,10167986,10897002,10897015,10168029,10168057,10897078,10897083,10887093,10897124,10887186,10887187,10887189,10897199,10887380,10887381,10887382,10887383,10887384,10887385,10887386,10887387,10647639,10603656,10604414,10604415,10604416,10604417,10604418,10604419,10604420,10604421,10604422,10604423,10604424,10604425,10604426,10604427,10604428,10604429,10604430,10604431,10604432,10604433,10604434,10604435,10604436,10604437,10604438,10604439,10604440,10604441,10604442,10604443,10604444,10604445,10604446,10604447,10604448,10604449,10604450,10604451,10604452,10604453,10604454,10604455,10604529,10546473,10546636,10527015,10508393,10508394,10508395,10508537,10508538,10508539,10508540,10508541,10508542,10507731,10407462,10477682,10477683,10477684,10414037,10408165,10408166,10408167,10408168,10408169,10412433,10408825,10408826,10408827,10408828,10408829,10408830,10408831,10408832,10408833,10408834,10408835,10408836,10408837,10408838,10408839,10408840,10408841,10408842,10408843,10408844,10408845,10408846,10408847,10408848,10408849,10408850,10408851,10408852,10408853,10408854,10408855,10406930,10406931,10406932,10406933,10406934,10406935,10406936,10406937,10406938,10406939,10406940) 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'