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(10861363,8630810,8630811,8630852,8630854,8630855,8630862,8630886,8630893,8630899,8630900,8630902,8630905,8630958,8630973,8630993,8631003,4970683,8631129,8631133,4970724,3229177,3229178,3229179,3229180,3229181,3229182,3229183,3229184,3229185,3229304,8631585,8631586,8631587,8631593,8631594,8631598,8631599,10849389,10862664,10862880,10862885,10862888,10862897,10862900,10862901,10862914,8632357,8632358,8632359,8632360,10863023,8632395,8632396,8632397,8632398,8632399,8632410,3230230,8632499,8632514,8632516,8632517,8632518,8632519,8632545,8632547,8632573,8632574,8629765,10860548,8630172,8630173,8630245,8630294,8630433,10939419,7201197,3238534,8627795,8627796,8627797,8628101,7201727,7201728,7201729,8595180,10858850,10858851,8628212,8628229,8628230,3899093,8628257,8628259,8628261,8628263,8628264,8628265,10858942,8628343,7201959,7201965,7201975,8065838,8065839,8065840,8628626,8628627,8628634,8628641,10859286,10859288,8628654,8628662,8628665,8628666,8628667,8628668,8628669,8628678,8628680,8628699,8628713,8628718,8628719,10859474,7202613,7202663,7202664,7202685,7202686,7202692,7202696,7202751,9794575,9794576,7202769,8629401,8629403,10860130,10860131,10860132,10860133,3237370,3237371,8626827,8626828,8626829,10102355,10102358,8626937,10959088,8627051,8627053,8627059,8627060,8627061,8627085,7200714,7200766,7200767,7200768,7200769,7200770,7200771,7200772,7200773,8627228,8627233,8627236,8627246,8627257,8627273,8627282,8627286,10866037,10866045,10866089,8627468,8627469,8627471,8627472,8627473,8627474,8627475,8627476,8627478,8627479,8627487,8627489,8627492,8627494,8627496,8627497,8627498,8627499,8627502,8627510,8627515,8627516,8627517,8627526,10100083,8624786,8624787,8624788,8624789,8624790,8624791,8624836,8624837,8624838,8624839,8624840,8624841,8624842,8624843,8624844,8624845,8624846,8624847,8624848,8624849,8624850,8624851,8624852,8624853,8624854,8624855,8624856,8624857,8624858,8624859,8624860,8624861,8624862,8624863,8624864,8624865,8624866,8624867,8624868,8624869,8624870,8624871,8624872,8624873,8624874,8624875,8624876,8624877,8624878,8624879,8624898,8624899,8624900,8624901,8624902,8624903,8624904,8624905,8624906,8624907,8624908,8624909,8624910,8624911,8624912,8624913,8624914,8624915,8624916,8624917,8624918,8624919,8624920,8624921,8624922,7198683,7198718,7198724,7198725,7198726,7198727,7198728,7198729,8625157,8625158,8625240,8625251,8625256,8625265,8625281,8625282,8625283,8625284,8625373,8625449,8625450,8625451,8625452,8625453,8625454,10856097,8625455,7199182,7199183,10101321,10856552,10101487,10101491,10864679,8626139,8626140,8626141,8626142,8626143,8626144,8626239,8626241,8626243,8626244,10958382,7200104,7200137,3237341,3923463,3923505,3923509,3233596,3923626,10853819,10853825,10853835,10853845,10853869,10853913,10853918,10853920,10853921,10853955,10853984,10854067,10854168,10854169,7197231,7197232,10854321,10854322,10838792,10854328,10854329,10854330,10854331,10854332,10854333,10854334,10854362,10838884,8624401,8624551,8624553,8624554,8634590,8634591,8634592,8634593,8634594,8634595,8634596,8634597,8634602,8634603,8634604,8634605,3232382,10617047,8634886,8634887,8634888,8634889,3232801,3232802,3232911,3232912,3232913,3232914,3232915,8632626,8632627,8632628,8632629,8632630,8632631,10425350,10425358,8632684,8632685,8632686,8632687,8632688,8632689,8632690,8632691,10425484,10425571,10425574,3581886,10425936,10425944,8633265,8633276,8633277,8633282,10426010,8633292,10426017,3582244,8633543,10616044,10616045,8540631,8540671,8540716,8540717,8611287,8611288,8611329,10616644,10616888,10616932,10611053,10611054,10611064,10611126,10614274,10614282,10614518,10614588,10611856,10608977,10612069,10612263,10612344,8851698,8851820,10609664,8851886,8851887,8851888,8851889,8851890,8851891,8851892,10609772,10612916,8852396,10610268,10610298,8852723,10613804,10610836,10610942,9911721,6673744,6673745,6673746,6673747,6673748,9169586,9169708,6674147,6674163,6674299,8850076,8850084,8850085,8850086,8850087,8850088,8850094,8850100,9912500,9912944,8850577,6672565,6672566,6672567,6672568,6672569,6672570,6672571,6672572,6672573,6672574,6672575,6672578,6672579,6672580,6672581,6672582,6672583,6672584,6672585,6672586,6672587,6672588,6672589,6672600,10415323,9168462,9168518,10416446,10416453,10416455,10416466,10416469,10416470,9168563,10416487,9168571,9168573,9168576,9168578,9168579,9168580,9168582,9168584,9168585,9168587,9168589,9168591,9168595,9168596,9168598,9168609,9168617,9168629,9168631,9168632,9168637,9168643,9168653,9168817,6673093,6673094,6673095,6673096,6673097,6673098,6673101,6673102,6673117,6673118,6673119,6673120,6673121,6673122,6673124,6673125,6673128,6673129,6673131,6673133,6673134,6673135,6673136,6673137,6673138,6673140,6673141,6670729,9167381,9167810,9167811,9168195,9168219,9168221,9168222,9168223,9168224,9168225,9168226,9168227,9168228,9168293,10889129,10884336,10899570,10884822,10884920,10884921,10875018,10875019,10875020,10875021,10875026,10875028,10880341,10887658,10882786,10882787,10882788,10882789,10882790,10882791,10882792,10882793,10882796,10882797,10882798,10882799,10882802,10882803,10882806,10882807,10882808,10882809,10882810,10882811,10882812,10882813,10882814,10882815,10882816,10882817,10882818,10882819,10882820,10882822,10882824,10882825,10882826,10882827,10882828,10882829,10882830,10882831,10882834,10882835,10882836,10882837,10882838,10882839,10882840,10882841,10882842,10882843,10882844,10882845,10882846,10882847,10882848,10882849,10882850,10882851,10882852,10882853,10882854,10882855,10882856,10882857,10882858,10882859,10882860,10882861,10882862,10882863,10882864,10882865,10882866,10882867,10882868,10882870,10882871,10882874,10882875,10882876,10882877,10882878,10887922,10885698,10885699,10161931,10876828,10167914,10167936,10167937,10167943,10167954,10167957,10167968,10167969,10167971,10167978,10167983,10167987,10167992,10168007,10168012,10168015,10168025,10168027,10168028,10168046,10168047,10897042,10168056,10168067,10897058,10897059,10168072,10897116,10887242,10608607,10608837,10608847,10608863,10608870,10608886,10608902,10608909,10608914,10608915,10608927,10608928,10604028,10604692,10508350,10508451,10508527,10507675,10507676,10507718,10507719,10507720,10507986,10413383,10413384,10413457,10409781,10410065,10410066,10410067,10410068,10410069,10410070,10410071,10414514,10414515,10414516,10414517,10414518,10414519,8562188) 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'