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(8630716,8630717,8574481,8574487,8574492,8574493,8574504,8574506,8574508,8574509,8574518,8574529,4970700,4970713,4970762,4970763,3228991,3228993,3229009,3229010,3229011,3229012,3229013,3229014,3229015,3229016,3229017,3229018,3229019,3229020,3229021,3229022,3229023,3229024,7066019,8583513,10950685,10950726,10950732,7066164,10990368,3230231,8573318,8573319,7201197,8627635,8627636,8627637,8627638,8627639,8627640,8627641,8627642,8627643,8627644,8627645,8627646,8627647,8627648,8627649,8627650,7201259,7201295,3238537,7201417,8595084,8595085,10999131,8595172,8595196,3899100,8595277,8595278,7201961,7201962,8628602,8628874,8628875,8628876,8628877,8628878,8628879,8628880,8628881,8628882,8628883,8628884,8628885,8628886,8628887,8628888,5654645,5654664,7202608,7202736,7202737,7202754,7202763,7202768,7202769,8629433,8629434,8629435,8629436,8629437,7200182,3237402,8910076,10102382,10959087,10959092,10931197,7198396,7198397,7198398,7198399,7198400,7198401,7198402,7198403,7198404,7198405,7198406,7198407,7198408,7198409,7198410,7198411,7198412,7198413,7198414,7198415,7198416,7198417,7198418,7198419,7198420,7198421,7198422,7198423,7198461,7069280,7069281,7198677,7198678,7198684,7198685,7198689,7198732,7198733,7198752,7198766,7199073,7199074,7199075,7199076,7199077,7199078,7199079,7199080,7199081,7199082,7199083,7199084,7199085,7199086,7199087,7199088,7199089,7199090,7199091,7199092,7199093,7199094,7199095,7199096,7199097,7199098,7199224,7199225,7199226,7199227,7199228,7199229,7199230,3926544,3926545,7199418,7199419,7199420,7199421,7199422,7199423,7199424,7199425,7199426,7199427,7199428,7199429,7199430,7199431,7199432,7199433,7199434,7199435,7199436,10101321,7199437,10101468,10101504,10101515,7199647,10101544,10101555,11048409,11048410,11048427,11048428,11048429,11048430,11048453,8565290,11048486,7199981,7200149,3923468,3923524,10618327,3923704,3923705,8613620,8613643,3924390,8907063,8907064,10838812,10838833,7197459,8907493,10839213,7197781,8624340,8624341,8624342,8624343,8624344,8624454,8624455,8624456,8624457,10427347,10427352,10622040,10617058,10617059,10617060,10617099,10617224,10617225,10617226,8612185,8905424,8905425,3232796,10622406,3922813,3232860,3232878,8905535,3232911,3232913,8905730,10954391,8905829,8905830,8905831,8905832,8905833,8905834,8905835,8905836,8905870,8905871,10620117,10620118,3230579,10615271,10925842,3581886,10615676,8611353,8611354,8611355,8611356,8611357,10616572,10616573,10616574,10616575,7155283,7155284,7155285,10611193,10611194,10611195,10614220,10614315,10614316,10614317,10614318,10614319,10614320,10614321,10614322,10614323,10614324,10614325,10614326,10614327,10714142,10614328,10714143,10614329,10614330,10614331,10614332,10614333,10614334,10614335,10614336,10614337,10614338,10614425,10614559,10614560,10614561,10611704,10611705,10611706,10611707,10611768,10611825,10612225,10612226,10612227,7058172,7058174,10609714,8566634,8566635,8566636,8566637,8566638,8566639,8566640,8566641,8566642,8566643,8566644,8566645,8566646,8566647,10120371,10612944,10612945,10612946,10612947,10612948,10612949,10612950,10612951,10612952,10612953,10612954,10612955,10612956,10612957,10612958,10612959,9220275,9220276,9220277,9220279,10610040,10610041,10610048,10610296,8567170,10610825,10610834,10610835,10610920,10610921,10610922,10610923,10610924,6673507,9169301,6673508,9169302,6673509,6673510,10117526,10117527,7055497,9161492,6673723,9169560,10117930,10117939,10117940,10118017,10118018,10118019,10118020,10118021,10118022,10118023,10118024,10118025,10118026,9169898,6674110,10118185,10118192,10118193,10118194,6674248,6674307,6674308,6674309,6674310,6674311,6674312,6674313,6674333,6674334,6674336,10118336,10118337,10118344,10118345,10118652,10118653,10118684,10416230,10415329,10415330,10415331,10415332,10415333,10415334,10415335,10415336,10415337,10415338,10415339,10415340,6672626,6672629,6672630,6672632,6672633,6672634,6672635,6672636,6672637,6672638,6672639,10416356,6672640,6672641,6672642,6672643,6672646,6672647,6672648,6672649,10415369,10415370,10415371,9168463,9184499,9184500,9184501,10419471,10419473,10419475,10419478,10419479,10419480,10419482,10419484,10419485,10419487,10419489,10419491,10417501,10416536,10416546,10417587,10417599,10419602,10419603,10419604,10419605,10419606,10419607,10419608,10419609,10419610,10419611,10415611,10415612,10419612,10415613,10419613,10415614,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10417631,10419631,10417632,10419632,10417633,10419633,9168711,10419634,9168712,9168713,10419635,10419636,9168714,9168715,10417638,9168716,9168717,9168718,10419641,9168719,10419642,9168720,10419643,9168721,10419644,9168722,10419645,9168723,9168724,9168725,9168726,9168727,9168728,7014390,7014391,7014392,7014393,7014394,7014395,7014396,7014397,7014398,10419666,7014399,10419667,7014400,7014401,7014402,7014403,7014404,7014405,7014406,7014407,7014408,7014409,7014410,7014411,7014412,7014413,7014414,7014415,7014416,7014417,7014418,7014419,7014420,7014421,7014422,7014423,7014424,7014425,7014426,7014427,9168774,10416720,10416721,10416722,10416723,10416724,10416725,10416726,10416727,10416728,10416729,10416730,10416731,10416732,10416733,6673018,10416734,10416735,10416736,10416737,10416738,10416739,10416740,10416741,6673026,10416742,6673027,10416743,6673028,10416744,6673029,10416745,6673030,10416746,6673031,10416747,6673032,10416748,6673033,10416749,6673034,10416750,10416751,10416752,6673037,10416753,6673038,10416754,6673039,10416755,10416756,6673040,6673041,6673042,6673043,6673044,6673045,6673046,6673047,6673048,6673049,6673050,6673052,6673053,6673062,6673074,7014550,7014551,10418883,6673167,10418884,6673168,10418885,6673169,10418886,6673170,10418887,10418888,10418889,10418890,10418891,10418892,10418893,10418894,10418895,10418896,10418897,10418898,10418899,10418900,10418901,10418902,10418903,10418904,10418905,10418906,10418907,10418908,10418909,10418910,10418911,10418912,10418913,10418914,10418915,10418916,10418917,10418918,10418919,9169188,9169189,9169233,10419207,10419208,10419209,8549580,8549995,8550027,8550048,8550049,8550088,8550089,10469521,10469522,10469523,10469524,10469525,8550105,8550156,8550187,10467616,10469627,10469628,10469629,10469630,10469631,10469632,10469633,8550227,8550228,8550229,8550235,8916778,10468158,10468159,10468160,10468365,9167888,10468509,10116239,9168073,9168165,10468791,10468792,10468793,10468794,10468795,10468796,10468797,10468798,10468799,10468800,10468801,10468802,10468803,10468804,10468805,10468806,10468807,10468808,10468809,10468810,10468811,10468812,10468813,10468814,10468815,10468816,10468817,10468818,10468819,10468822,10154576,10883578,10888605,10888683,10946563,10946564,10946565,10884294,10884295,10884296,10884297,10884298,10884299,10884300,10884301,10889490,10889491,10889492,10889493,10889494,10889495,10884984,10884985,10890002,10890006,10890007,10890008,10890009,10890032,10890075,10890076,10890225,10885351,10885352,10885353,10885354,10885355,10885356,10885357,10885358,10885359,10885360,10885361,10885362,10885363,10885364,10885365,10885366,10885367,10885368,10887487,10887528,10882618,10882619,10153861,10153862,10183909,10888025,10888029,10888031,10888127,10888132,10888172,10888207,10888320,10627927,10885743,10885857,10885899,10885914,10162014,10162015,10162016,10162017,10162018,10162019,10162020,10162170,10162171,10162172,10167926,10167928,10167938,10167944,10167950,10167960,10167962,10167966,10167967,10167972,10167973,10167984,10167985,10168002,10168004,10168013,10168014,10168017,10168020,10168022,10626509,10168053,10168060,10168063,10168068,10168070,10897060,10897063,10168077,10168082,10168084,10897077,10887172,10887173,10887174,10887175,10887176,10887177,10887178,10887179,10887180,10887181,10887182,10887183,10887184,10887185,10887205,10647430,10647431,10647432,10647433,10647434,10647435,10647508,10647591,10647592,10647633,10527957,10505594,10507673,10507674,10507675,10507676,10507677,10507678,10507679,10507680,10507681,10507682,10507698,10507699,10507773,10507796,10507807,10507836,10507858,10507915,10507916,10507917,10507918,10507919,10507945,10507946,10507947,10507948,10507949,10507950,10507951,10507952,10507953,10507954,10507955,10507956,10507957,10507958,10507959,10507984,10507985,10409449,10488183,10407924,10489215,10489216,10489217,10489218,10489219,10489220,10489221,10489222,10489223,10489224,10489225,10489226,10489227,10489228,10489229,10489230,10408651,10410658,10410662,10472540,10472541,10472542,10472543,10472544,10472545,10472546,10472547,10472548,10472549,10472550,10472551,10472552,10472553,10408971) 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'