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(8068846,8068847,8068848,8068849,8068850,8068851,8068852,8068853,8569880,8569881,7074061,7074062,4968320,7074107,7074108,7074109,7074110,7074111,7074112,7074113,7074114,7074115,7074116,7074117,7074118,7074119,7074120,7074121,7074122,7074123,7074124,7074125,4968341,7074126,7074127,7074128,7074129,7074133,7074134,7074135,7074136,7074142,7074143,7074144,7074145,7074146,7074147,7074148,7074149,7074150,7074151,7074152,7074153,7074154,7074155,7074156,7074157,7074158,7074159,7074160,7074161,7074162,7074163,7074164,7074165,7074166,7074167,7074168,7074169,7074170,7074171,7074172,7074173,7074174,7074175,7074176,7074177,7074178,7074179,7074180,7074181,7074182,7074183,7074184,7074185,7074186,7074187,7074188,7074189,7074190,8067343,10437280,10437281,10437282,10437283,10437284,10437285,10437288,10437298,10437299,10437300,10437301,10437302,10437303,10437304,10437538,10437557,7074705,7074706,10961881,10961882,10961883,10961897,10961898,10962185,8068484,8068485,8068486,8068487,8068488,8068489,8068490,8068491,8068492,11001368,11001369,8068812,8068813,7071987,7072225,10999152,10999154,10931853,10931935,10931936,10931943,10931955,10931956,10960449,10999493,10999494,10999500,10932163,10999501,8065989,10999764,10932607,10932614,10932618,10932657,10932679,10932688,8066489,8066490,8066491,8066492,7073647,10997628,11010666,11048985,11048987,11010906,11010907,7071400,7071404,7071405,11049350,11011352,8064693,3655561,7069011,10944639,10944640,10944641,10944642,10944643,10995920,10995921,10995922,10995923,10995924,10995925,10995926,10995927,10995928,10995930,10995935,10995946,10995947,10995948,11008955,11008956,11008957,11008958,11008959,11008960,10995960,10995961,10995962,10995963,10995964,10995969,10995970,10995971,10995972,10995973,8072313,11009371,3656311,3656312,3656313,3656314,8072768,8072769,8072770,8072771,8072772,8073049,10942113,10942119,11010220,11010221,11010254,11010260,11010264,11010282,10942272,7070690,10958381,10958382,10958383,11007085,11007098,11007099,11007100,11007101,11007557,11007558,11007559,11007560,11007561,11007562,11007563,11007564,11007565,11007566,11007567,11007568,11007569,11007570,11007571,11007572,11007573,11007574,10619113,8070923,8070924,8070927,8070928,8070931,8070951,8070958,8071159,8071319,8071320,8071332,8071339,8071348,8071360,10967036,10967037,10967038,10967039,10967040,10928176,11006432,11006433,11006434,11006435,10993447,10617958,10615141,10990991,10990992,10990993,10990994,8570303,8570304,8570305,8570307,8570308,8570309,10991033,10991034,10991035,10991036,10991037,10615843,10615844,10615845,10615846,10615847,10615848,10615849,10615850,10615851,10615852,10615853,10615854,10615855,10615856,10615857,10615858,10930897,10930945,10921719,10921720,10921721,10921722,10921723,10921724,10921725,10921726,10921727,10921728,10921729,10921730,10921731,10921732,10921733,10921734,10921735,10921736,10921737,10921738,10921739,10921740,10921741,10921742,10921743,10921744,10921745,10921746,10921747,10921748,10921749,10921750,10921751,10921752,10921753,10921754,10921755,10921756,10921757,10921758,10921759,10921760,10921761,10921762,10921763,10921764,10921765,10921766,10921767,10921768,10921769,10921770,10921771,10921772,10921773,10921774,10921775,10921776,10921777,10921778,10921779,10921780,10921781,10921782,10921783,10921784,10921785,10921786,10921787,10921788,10921789,10921790,10921791,10921792,10921793,10921794,10921795,10921796,10921797,10921798,10921799,10921800,10921801,10921802,10921803,10921804,10921805,10921806,10921807,10921808,10921809,10921810,10921811,10921812,10921813,10921814,10921815,10921816,10921817,10921818,10921819,10921820,10921821,10921822,10921823,10921824,10921825,10921826,10921827,10921828,10921829,10921830,10921831,10921832,10921833,10921834,10921835,10921836,10921837,10921838,10921839,10921840,10921841,10921842,10921843,10921844,10921845,10921846,10921847,10921848,10921849,10921850,10921851,10921852,10921853,10921854,10921855,10921856,10921857,10921858,10921859,10921860,10921861,10921862,10921863,10921864,10921865,10921866,10921867,10921868,10921869,10921870,10921871,10921872,10921873,10921874,10921875,10921876,10921877,10921878,10921879,10921880,10921881,10921882,10921883,10921884,10921885,10921886,10921887,10921888,10921889,10921890,10921891,10921892,10921893,10921894,10921895,10921896,10921897,10921898,10921899,10921900,10921901,10921902,10921903,10921904,10921905,10921906,10921907,10921908,10921909,10921910,10921911,10921912,10921913,10979062,10921914,10979063,10921915,10979064,10921916,10979065,10921917,10921918,10921919,10921920,10921921,10921922,10921923,10921924,10921925,10921926,10921927,10921928,10921929,10921930,10921931,10921932,10921933,10921934,10921935,10921936,10621426,10921937,10921938,10921939,10921940,10921941,10921942,10921943,10921944,10921945,10921946,10921947,10921948,10921949,10921950,10921951,10921952,10921953,10921954,10921955,10616790,10611013,10611014,10559195,7059634,9165536,10611318,10611319,10562534,10562542,10562550,6665740,8864272,8864275,10562567,10562568,8864279,10562577,10562578,6665765,10562582,10562583,6665789,9173967,9173968,6666026,6666027,6666057,6666058,6666060,6666061,6666062,6666063,6666066,6666067,6666068,6666102,6666153,10614849,9171301,7057686,7057687,9171609,10560508,10560509,10560510,10560511,10560512,10560513,10560514,10560515,10560516,10560517,10560518,10560519,10560520,10560521,10560522,9171734,9180104,9180105,9180106,9180107,9180108,9180109,9180110,9180111,8862714,7058763,7058764,7058765,7058766,10564653,10564654,10564671,9172860,10564713,10564714,10564766,10564767,10564768,10564769,8863510,8863511,8863512,8863513,10564805,8863514,8863515,10564825,10610679,10558852,10558853,10558854,10558855,10558856,10558857,10558858,10558859,10558860,10558861,10558862,9165251,9165253,10515259,10515260,10515261,10515262,10515263,10513403,9169643,9169645,7055892,7055893,4974602,4974603,4974604,4974605,4974606,4974607,4974608,9161788,9162162,4975088,9162290,7056501,7056502,7056503,7056504,7056505,4975231,4975232,7056922,10512806,10512807,9179101,9179102,9179103,9179104,9179105,9179106,9179107,9179108,9179109,10518979,9171222,9168386,9176388,4973352,4973355,4973366,4973373,4973374,4973375,4973376,4973377,4973378,10416738,10416741,7055107,7055124,10417044,10417049,6666662,6666726,6666728,9166803,9174819,9166826,9166827,9166828,9166829,6667146,6667147,4972123,6667411,6667414,6667415,6667566,6667567,6667568,6667569,6667570,6667571,6667572,6667573,6667574,8917323,8917324,8917333,8917334,6667698,6667699,6667700,10466298,10466299,10466300,10466301,10466302,8917414,8917415,8917416,8917417,6667920,6667980,6668088,6668089,6668210,6668211,6668252,9176259,10170303,10170359,10629587,10629871,10629872,10629873,10629874,10629875,10629876,10629877,10629878,10629879,10629880,10629881,10629882,10629883,10629891,10629892,10629893,10629894,10629895,10629896,10629897,10629898,10629899,10629900,10629901,10629902,10629903,10629904,10629905,10629906,10629907,10629908,10629909,10629910,10629911,10629912,10629913,10629914,10629915,10629916,10629917,10629918,10629919,10629920,10629921,10629922,10629923,10629924,10629925,10629926,10629927,10629928,10629929,10629930,10629931,10629932,10629933,10629934,10629935,10629936,10629937,10629938,10629939,10629940,10629941,10629942,10629943,10629944,10629945,10629946,10629947,10629948,10629949,10629950,10629951,10629952,10629953,10629954,10629955,10629956,10629957,10629958,10629959,10629960,10629961,10164008,10627538,10627539,10627547,10627954,10627955,10627956,10629962,10629963,10629964,10629965,10629966,10629967,10629968,10629969,10629970,10629971,10629972,10629973,10629974,10629975,10629976,10629977,10629978,10629979,10629980,10629981,10629982,10629983,10629984,10629985,10629986,10629987,10629988,10629989,10629990,10629991,10629992,10629993,10629994,10629995,10629996,10629997,10626572,10626573,10626574,10626575,10626576,10626577,10626578,10631670,10626756,10626768,10626769,10626778,10626779,10626780,10626781,10626782,10626783,10580488,10578517,10578518,10578519,10578520,10578521,10578522,10578523,10578524,10578525,10578526,10578527,10578528,10578529,10578530,10578531,10578532,10578533,10578534,10578535,10578536,10578537,10578686,10578687,10578688,10578689,10578690,10578691,10578692,10578693,10576589,10576590,10523876,10520140,10520141,10520142,10520143,10522449,10423227,10422303,10422304,10423382,10423388,10421510,10421511,10422754,10422755,10422088,10423128,10472892,10473281,10473292,10473293,10473294,10473296,10473328,10473329,10473349,10473359,10473360,10473366,10473367,10473368,10473403,10473442,10473462,10473463,10473469,10473470,10473491,10473492,10473512,10473513,10473514,10473515,10473825,10473828,10473954,10473955,10473956,10473957,10474073,10474118,10472821,10472840) 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'