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(8620790,8838464,8838465,9214733,8621121,8621122,8621175,8839008,8569698,8569713,8569714,8569715,8569716,7065952,7074055,10976974,10976975,10976976,10976977,10976978,10976979,8575544,10951065,10951085,10951158,8067723,8067724,8067725,7074860,7074902,11039792,11039793,11039794,11039795,11039796,11039797,11039798,11039799,11039800,11039801,11039802,11039803,11039804,11039805,11039806,11039807,11039808,11039809,11039810,11039811,11039812,11039813,11039814,11039815,11039816,11039817,11039818,11039819,11039820,11039821,11039822,11039823,11039824,11039825,11039826,11039827,11039828,11039829,11039830,11040000,11040001,11040002,11040003,11040004,11040007,11040008,11040009,11040012,11040013,11040014,11040015,11040016,11040017,11040018,11040019,11040020,11040021,11040022,11040023,11040024,11040025,11040026,11040027,11040028,11040029,11040030,11040031,11040032,11040033,11040034,11040083,11040084,11040085,11040086,11040087,11040088,11040089,11040090,11040091,11040092,11040093,11040094,11040095,11040096,11040097,11001198,11001202,11001203,11001204,11001205,11040219,11040221,11040222,11040223,11040224,10873063,10873064,8620710,11037639,11037640,11037641,11037642,11037643,11037644,11037645,11037646,11037647,11037648,11037649,11037650,11037651,11037652,11037653,11037654,11037655,11037656,11037657,11037658,11037659,11037660,11037661,11037662,11037663,11037664,11037665,11037666,11037667,11037668,11037669,11037670,11037671,11037672,7201399,7201401,7201402,7201403,10866478,7201452,10842994,11038169,7064492,11038193,11038194,11038218,11038219,11038274,10960305,11038343,11038344,11038345,11038346,11038347,11038375,11038439,11038440,11038441,11038453,11038454,8618626,11038477,8618628,11038478,8618629,11038479,8618630,8618631,11038480,11038481,8618632,11038482,8618633,8618634,8618635,8618636,10843580,10103958,10999681,3899518,10104182,8560023,8560024,8560025,8560026,8560027,8560028,8560029,8560030,8560031,8560032,8560033,8560034,8560035,8560036,8560037,8560038,8560039,10843898,10843906,10843907,10843909,10867919,10859997,8560676,10100016,10100027,3927417,3927618,10102550,10998451,11037546,11037547,11037548,11037549,11037550,11037551,11037552,11037553,11037554,11037555,11037556,11037557,11037558,11037559,11037560,11037561,11037562,11037563,11037564,11037565,11037566,11037567,11037578,11037579,11037580,11037581,11037582,11037583,11037584,11037585,11037586,11037587,11037588,4430529,3925441,11009407,11009408,11009409,11009410,3926387,3926388,11035913,11035914,7199624,7199642,11036137,10102026,11045620,10928574,8613406,3923972,8906888,11046642,10838820,10838821,10838822,10838823,10838824,8614249,10995162,10925123,10925124,10925376,10925377,10925378,10925379,10925380,10925381,10925382,10925383,10925384,10925385,10925386,10925387,10925388,10925389,10925390,10925391,10925392,10925393,10925394,10925395,10925396,10925397,10925398,10925399,10925400,10925401,10925402,10925403,10925404,10925405,10925406,10925407,10925408,10925409,10925410,10925411,10925412,10925413,10925414,10925415,10925416,10925417,10925418,10925419,10925420,10925421,10925422,10925423,10925424,10925425,10925426,10925427,10925428,10925429,10925430,10925431,10925432,10925433,10925434,10925435,10925436,10925437,10925438,10925439,10925440,10925441,10925442,10925443,10925444,10925445,10925456,10925457,10925458,10925459,10925460,10925461,10925462,10925463,10925464,10925465,10925466,10925467,10925468,10925469,10925470,10925471,10966734,10966735,11044892,11044893,11044894,11044895,11044896,11044897,11044898,11044899,11044900,10617243,11044901,11044902,11044903,11044904,11044905,11044906,11044907,11044908,11044909,11044910,11044911,10617573,10923113,10923114,10923115,10923116,10923117,10923118,10923119,10923120,10923121,10923122,10923123,10923124,10923125,10923126,10923127,10923128,10923129,10923130,10923131,10923132,10923133,10923134,10923135,10923136,10923137,10923138,10923139,10923140,10923141,10923142,10923143,10923174,10923175,10923176,10923177,10923178,10923179,10923180,10923181,10923182,10923183,10923184,10923185,10923186,10923187,8542164,10923188,10923189,10923191,10923192,10923193,10923194,10923195,10923205,8542254,10925472,10925473,10925474,10925475,10925477,10925478,10925479,10925480,10925481,11042672,3230452,10850780,10615545,10848398,10991394,10991395,10991396,10965430,10965516,10615930,10991699,10991700,8540633,10991864,10991866,10991875,10991876,10991877,10991891,10991892,10991909,10991910,10991911,10991912,10991913,10991920,10991921,10991922,10991931,10991932,10991936,10991937,10991939,10991941,10991942,10991943,10991944,10991945,8577664,8541012,8904951,9205827,9205828,8853835,8853836,8853837,10611823,9206195,9174199,9174200,9206236,9206287,9913536,9913537,9913538,7017319,7017320,7017321,7017322,7017323,7017324,7017325,7017326,7017327,7017328,7017329,7017330,7017331,7017332,7017333,7017334,7017335,7017336,7017337,7017338,10612347,7017339,7017340,7017341,7017342,7017343,7017344,7017345,7017346,7017347,7017348,7017349,7017350,7017351,7017352,7017353,7017354,7017355,7017356,7017357,7017358,7017359,7017360,7017361,7017362,7017363,7017364,10612884,10558441,7058842,8852540,9204927,6677248,6677250,6677253,6677254,6677256,6677258,6677261,6677263,6677265,6677266,6677267,6677269,6677277,10613744,8567740,9169456,9169457,9169458,9169459,9185731,10512149,10514615,10514625,9168512,9910883,9168768,9168769,9168770,9168771,9168772,6679016,9917097,9917163,8550207,8550208,8855247,8550642,10470115,9191657,9191762,976636,10903603,10903640,10903641,10903642,10628722,10885153,10885154,10892517,10908120,10888290,10186799,10186800,10186801,10186802,10186803,10187080,10187081,10172086,10630860,10896381,10187473,10631538,10631539,10631540,10188064,10887160,10887161,10887162,10580672,10580673,10580674,10580675,10580676,10580677,10580678,10580679,10590471,10590472,10590473,10590474,10590475,10590476,10590477,10590478,10653660,10653685,10653686,10653687,10653688,10653689,10653690,10653691,10653692,10653693,10653694,10653695,10653696,10653698,10653699,10653703,10653704,10581693,10581694,10581695,10581696,10581697,10581698,10581699,10581700,10581701,10581702,10581703,10581704,10581705,10581706,10581707,10581708,10581709,10581710,10581711,10581712,10581713,10581714,10581715,10581716,10581717,10581718,10581719,10581720,10581721,10581722,10581723,10581724,10581725,10581726,10581727,10581728,10581729,10581730,10581731,10581732,10581733,10581734,10581735,10581736,10581737,10581738,10581739,10581740,10581741,10581742,10581743,10581744,10581745,10581746,10581747,10581748,10581749,10581750,10581751,10581752,10581753,10581754,10581755,10581756,10581757,10581758,10581759,10581760,10581761,10654022,10654023,10654024,10651848,10651849,10651850,10651851,10651852,10651853,10651854,10651855,10525323,10521457,10529862,10529863,10528564,10528565,10528566,10534583,10534584,10534585,10534586,10534587,10534588,10534589,10534590,10534591,10534592,10534593,10534599,10544689,10544690,10544692,10544693,10544694,10520927,10508256,10498413,10498468,10498469,10498470,10498471,10498472,10498473,10498474,10498475,10508029,10477303,10494925,10494926,10494927,10494928,10493015,10493016,10493017,10493018,10493019,10414395) 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'