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(3228916,3228917,3228968,3228971,3228972,3228976,3228991,3229018,3229021,3229039,3229041,10989323,10989324,10989325,10989326,10989327,10861938,3229077,3229081,3229082,3229115,3229124,10861998,3229130,3229132,3229133,3229134,3229189,10950703,7066213,8631875,7066248,7066249,10862593,3229977,3229978,10862876,10849967,10850036,3230231,8573340,10939174,10939403,7201319,3238519,7201368,3238542,3238543,8594944,3238791,3238792,8595105,8595197,7201868,7202100,7202101,7202102,7202103,10867283,10867284,10867285,10867286,7202323,7202324,7202325,7202326,7202327,7202328,7202329,7202337,7202338,7202339,7202340,7202384,7202390,7202391,10859534,10859535,10859554,10859567,7202674,10987345,3227092,3227187,3227189,3227196,10860118,10860119,10860120,10860121,10860122,10865395,10865398,10865408,10857456,7200532,7200539,10958984,10958985,10958986,7200555,10959004,10959005,8626990,8626991,8626992,7200680,7200681,7200682,7200683,7200684,7200685,7200686,7200687,7200688,7200689,7200690,7200691,7200692,7200693,7200694,7200695,7200696,7200697,7200698,7200699,7200700,7200701,7200702,7200703,7200704,7200705,7200706,7200727,7200728,7200729,7200730,8558558,7200917,7200920,7200921,7200922,7200923,7200925,7200926,7200927,7200928,7200929,7200930,7200931,7200932,7200933,7200934,7200935,7200936,7200937,8910764,8910765,8558678,8558692,8910815,8910816,8558774,10100083,10863295,10863297,10863298,10863306,10863308,10863311,10863312,10863318,10863321,10863326,10863333,10863335,10863339,10863340,10863342,10863347,10863350,10863355,10863356,10863358,10863363,7198411,7198413,7198416,7198418,3235777,3235778,3235780,10855738,8625281,10856119,10864120,8625507,8625509,8625510,8625511,8625514,8625515,8625516,8625517,8625518,10864423,7199391,7199393,7199394,7199395,7199396,7199397,7199400,7199401,7199405,7199406,7199407,7199408,7199409,7199410,7199411,7199412,7199413,7199414,7199415,7199416,7199417,7199543,7199544,7199546,7199547,7199548,7199549,7199551,11048397,11048435,3923494,10853452,10618269,10618283,10618285,7196505,10618286,7196506,7196507,7196508,7196509,7196510,7196511,7196512,10618293,7196513,7196514,7196515,7196516,10618297,7196517,7196518,7196519,7196520,7196521,7196522,7196523,7196524,7196525,7196526,7196527,7196528,7196529,7196530,7196531,7196532,7196533,7196534,7196535,10618316,7196536,10618317,10618318,7196537,7196538,10618319,7196539,7196540,7196541,7196542,7196543,7196544,7196545,7196546,10853759,10853763,10853764,8906799,8906800,8906801,8554715,8554723,8554724,8554732,8554735,8554736,8554741,10854266,3234575,10838928,3234856,3234862,3234864,7197846,3235058,3235068,3235069,3235070,3235104,3235105,8624369,8624378,10617081,10617089,10617090,10617091,10852520,10852531,8612079,8612080,10852533,8612081,10852534,8612082,10852537,10852539,10852558,10852561,8541826,10954226,10954227,7196152,10615062,10615163,3230571,10615231,10615267,10615346,10850682,10850684,10615496,10850822,10850823,3231047,10615678,3231146,8633965,8633966,10616477,10616547,8611389,8611466,8611467,10616739,8611549,8611550,10616791,10616849,10616852,10852113,8611688,8611689,8541387,8541388,10616955,10610998,10611179,10614634,10614636,8853815,10611694,9166040,10612028,10612042,10612044,10612209,10612213,10609340,10609341,10609342,10609343,10609400,10612487,8851778,10609825,8852331,10613298,10610354,10610357,8852546,9172926,10117872,10117903,10117937,10117971,10118083,10118084,10118195,10118196,10118231,10118242,10118311,10118328,10118353,10118364,10118366,10118368,10118372,10118419,10118516,10118525,10118610,10118650,10118652,10118653,9913278,9913279,8552471,10416237,10416402,10116694,6672714,10416442,10116719,10417465,10116800,10116801,10116803,10116804,10116806,10116813,10116814,10116891,10116892,9168720,10418695,10418698,10418706,10417734,10415740,10117033,10117035,10416823,10416825,10416826,10416834,10416836,10416839,10416840,10416846,10416850,10416856,10416860,10416865,10416867,10416870,10416872,10416874,10416876,10416882,10416885,10416890,10416891,10416894,10416898,9911272,10420110,10420111,10420112,10117421,10117441,10471104,10471113,10471115,10469639,8550242,8550247,10465757,10123832,10123836,10466244,10466250,10468353,10468498,10468509,9167962,10470631,10470728,10470731,10470734,9168283,10628314,10628944,10889700,10889710,10884717,10884985,10890047,10875213,10887487,10887795,10632302,10630287,10162221,10162222,10162223,10626123,10626125,10912040,10607542,10508280,10508334,10507629,10507630,10507631,10507632,10507810,10507905,10411233,10407440,10407471,10413529,10409599,10407943,10407945,10413993,10414005,10412178,10414507,10414508,10408762,10408983,10408995,10408997,10408998,10409001,10409015,10409017) 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'