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(8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,8630658,8630661,8630663,8630664,8630670,8630671,8630672,8630673,8630674,8630675,8630676,8630677,8630678,8630679,8630680,8630682,8630683,8630684,8630690,8630691,8630698,8630699,8630700,8630701,8630702,8630703,8630704,8630715,8630716,8630717,8630718,8630719,8630720,8630721,8630722,8630723,8630724,8630725,8630726,8630727,8630728,8630734,8630735,8630736,8630737,8630738,8630740,8630747,8630748,8630751,8630755,8630765,8630786,8630794,8630795,8630796,8630797,8630799,8630800,8630801,8630802,8630803,8630805,8630806,8630811,8630854,8630866,8630897,8630906,8630907,8630908,8630958,8630959,8630963,8630965,8630967,8630970,8630972,8630973,8630974,8630976,8630977,8630987,8630991,8630993,8630994,8630995,8630996,8630997,8630998,8630999,8631001,8631002,8631003,8631004,8631005,8631007,8631009,8631010,8631011,8631013,8631071,8631075,8631097,8631107,8631108,8631109,8631110,8631111,8631112,8631113,8631114,8631115,8631116,8631129,8631130,8631131,8631132,8631144,8631145,4970738,8631185,8631186,8631187,8631189,8631232,8631233,8631234,8631235,8631236,8631237,3229106,3229107,3229108,3229109,3229110,3229130,3229131,8631382,8631383,3229171,8631480,8631481,8631482,8631483,8631484,8631485,8631486,8631487,8631488,8631489,8631490,8631491,8631492,8631493,8631494,8631495,8631497,8631498,8631499,8631500,8631501,8631502,8631503,8631504,8631505,8631507,8631508,8631509,3229285,8631518,8631519,8631526,8631527,8631528,8631529,8631530,8631531,8631532,8631533,8631534,8631535,8631536,8631537,8631590,8631598,8631612,8631613,8631630,8583479,8583480,8583481,8583482,8583483,8631662,8583488,8631673,8631674,8631677,8631678,8631716,8631719,8631721,8631725,8631728,8631743,8631749,8631750,8631752,8631753,8631755,8631756,8631757,8631758,8631763,8631764,8631765,8631821,8631847,8631853,8631868,8631870,8631872,8631890,8632196,8632197,8632198,8632199,8575733,8575734,8575735,8632383,8632384,8632385,8632386,8632387,8632390,8632395,8632396,8632397,8632398,8632399,8632428,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,8632457,8632458,8632459,8632460,8632493,8632510,8632512,8632515,8632516,8632517,8632518,8632519,8632520,8632522,8632523,8632526,8632527,8632528,8632530,8632537,8632538,8632545,8632546,8632547,8632559,8632560,8632572,8632573,8632574,8629589,8629596,8629612,8629640,8629673,8629718,8629731,8629732,8629733,8629734,8629735,8629736,8629741,8629742,8629749,8629765,8629838,8629845,8629846,8629890,8629958,8629968,8629970,8629971,8629975,8629976,8629978,8629980,8629998,8630000,8630003,8630005,8630007,8630008,8630010,8630014,8630015,8630018,8630020,8630023,8630025,8630028,8630134,8630135,8630138,8630143,8630144,8630148,8630149,8630151,8630152,8630153,8630159,8630165,8630167,8630168,8630171,8630172,8630173,8630187,8630234,8630235,8630236,8630238,8630245,8630246,8630287,8630294,8630306,8630308,8630310,8630312,8630395,8630396,8630398,8630442,8630447,8630448,8630449,8630450,8630451,8630452,10930095,8630483,8630487,8630488,8630496,8627581,8627582,8627583,8627625,8627626,8627627,8627628,8627630,8627631,8627632,8627633,8627707,8627708,8627709,7201309,8627710,8627711,8627712,8627713,7201366,7201367,8627793,8627795,8627796,8627797,8627798,8627799,8627800,8627801,8627802,8627806,8627821,8627870,8627871,8627876,7201478,7201479,8627907,8627909,8627910,8627913,8627914,8627915,8627918,8627920,8627921,8627931,8627932,8627985,8627992,8627994,8627996,8627998,8628000,8628004,8628006,8628118,8628119,8628122,7201727,7201728,7201729,8628154,8628157,8628158,8628164,8628165,8628185,8628186,8628189,8628190,8628205,8628206,8628207,8628210,8628229,8628230,8628241,8628242,8628243,8628244,8628245,8628257,8628258,8628259,8628260,8628261,7201861,8628263,8628264,8628275,8628278,8628281,8628284,8628351,8628352,7201959,7201974,10960474,8628571,8628575,7202211,7202212,7202213,7202214,8628627,8628630,8628631,8628632,8628634,8628641,8628642,8628643,8628644,8628645,8628647,8628648,8628652,8628653,8628654,8628655,8628656,8628657,8628658,8628659,8628660,8628662,8628663,8628664,8628665,8628666,8628667,8628668,8628669,8628670,8628671,8628673,8628676,8628678,8628679,8628680,8628686,8628688,8628689,8628691,8628692,8628693,8628694,8628695,8628696,8628697,8628698,8628699,8628700,8628701,8628702,8628703,8628705,8628706,8628707,8628708,8628709,8628710,8628711,8628712,8628713,8628714,8628715,8628716,8628717,8628718,8628719,8628720,8628721,8628722,8628723,8628729,8628730,8628731,8628732,8628736,8628737,8628738,8628739,8628740,8628741,8628742,8628743,8628744,8628745,8628746,8628747,8628748,8628749,8628750,8628793,8628794,8628795,8628796,8628814,8628819,8628821,8628823,8628824,8628825,8628826,8628828,8628830,8628832,8628833,8628834,8628835,8628836,8628837,8628838,8628839,8628840,8628841,8628842,8628843,8628844,8628846,8628848,8628849,8628850,8628852,8628854,8628855,8628856,8628858,8628860,8628862,8628864,8628865,8628866,8628868,8628870,8628871,8628872,8628889,8628890,8628891,8628892,8628893,8628894,8628896,8628897,8628898,8628899,8628900,8628901,8628905,8628906,8628907,8628908,7202585,7202684,7065457,9794578,9794579,9794580,9794588,9794592,9794594,7198678,7198679,7198680,7198681,7198683,7198685,7198687,7198688,7198690,7198694,7198695,7198696,7198697,7198698,7198699,7198701,7198702,7198703,7198704,7198709,7198710,7198711,7198712,7198713,7198714,7198715,7198716,7198717,7198718,7198719,7198720,7198721,7198722,7198723,7198724,7198726,7198728,7198729,7198730,7198731,7198733,7198736,7198737,7198738,7198739,7198740,7198742,7198743,7198746,7198747,7198750,7198751,7198752,7198753,7198754,7198755,7198756,7198757,7198759,7198762,7198763,7198764,7198765,7198766,7198767,7198768,7198769,7198770,7198772,7198785,10838801,10838803,10838999,3235067,7197896,3232382,8541549,10617138,3232910,3232913,3232914,3232915,8542165,8542254,10951828,10615598,10425937,10426197,8540418,8540631,8540633,10616228,10616229,10616243,10616267,10616268,10616298,10616311,10616323,10616324,10616333,10616348,10616387,10616393,10616394,10616395,10616397,10616440,10616441,10616644,10565319,10614220,10611375,10614376,10611377,10611378,10611390,10611391,10611393,10611394,10611398,10611400,10611406,10611407,10611408,10611411,10611412,10611413,10611426,10611428,10611431,10611432,10611435,10611436,10611437,10611443,10611444,10611445,10611450,10611451,10611452,10611463,10611464,10611469,10611480,10611482,10611491,10611492,10611493,10611498,10611507,10611509,10611526,10611527,10611536,10611537,10611538,10611539,10611542,10611543,10611550,10611551,10611552,10611555,10611567,10611568,10611569,10611581,10611585,10611586,10611590,10611594,10611597,10611598,10611600,10611604,10611612,10611613,10611618,10611619,10611621,10611623,10611635,10611636,10611637,10611638,10611640,10611641,10611643,10611649,10611655,10611660,10611676,10611856,6666259,10612194,10612201,10612916,10613133,10613235,10613334,10613342,10613513,10613514,10610901,9169318,6673538,6673541,6673542,6673543,6673544,6673549,9169428,10117664,9169638,6674248,6674280,6674285,9178490,9178492,10512852,9168307,6672592,9168453,6672802,9168804,6673067,10418806,10418807,10418808,10418809,10418810,10418811,10418812,10418813,10418814,10418815,10418816,10418817,10418818,10418819,10418820,6673105,10418821,10418822,10418823,10418824,10418825,10418826,10418827,10418828,10418829,10418830,10418831,10418832,10418833,10418834,10418835,10418836,10418837,6673122,10418838,10418839,6673124,10418840,6673125,10418841,10418842,10418843,10418844,10418845,10418846,10418847,10418848,10418849,10418850,10418851,10418852,10418853,10418854,10418855,10418856,10418857,10418858,10418859,10418860,10418861,10418862,10418863,9168281,9168290,10893986,10893987,10893988,10889019,10889020,10889021,10884652,10884653,10889997,10880305,10885465,10885468,10885469,10632107,7000826,10627319,10883421,10886057,10886058,10886059,10886060,10626299,10626300,10626301,10886878,10886910,10167992,10887052,10887096,10882359,10598867,10582561,10543041,10498367,10498499) 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'