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(8630688,8630689,8630710,8630711,8630712,8630713,8630714,8630729,8630730,8630731,8630732,8630733,8630742,8630749,8630936,8631081,8631083,8631084,8631086,8631087,8631088,8631090,8631133,8631134,8631189,8631653,8631654,8631655,8631656,8631777,8631778,8631876,8631877,8631878,8631879,8631880,8631881,8631882,8631883,8631884,8631885,8631886,8631887,8631888,8631889,8631890,8631891,10849783,8632420,8632524,8632525,8629598,8629611,8629640,8629643,8629718,8629719,8629720,8629721,8629722,8629723,8629724,8629725,8629726,8629727,8629728,8629729,8629730,8629731,8629732,8629733,8629734,8629735,8629736,8629769,8629831,8629832,8629927,11001213,11001214,11001215,11001216,8630250,8630251,8630252,8630258,8630259,8630260,8630261,8630262,8630263,8630264,8630324,8630325,8630326,8630327,8630328,8630329,8630330,8630331,8630332,8630333,8630334,8630335,8630336,8630337,8630338,8630339,8630340,8630341,8630342,8630343,8630344,8630345,8630346,8630347,8630348,8630349,8630350,8630351,8630352,8630353,8630354,8630355,8630356,8630357,8630359,8630360,8630361,8630362,8630363,8630364,8630365,8630366,8630367,8630368,8630369,8630370,8630371,8630372,8630373,8630374,8630375,8630376,8630377,8630378,8630379,8630380,8630381,8630382,8630383,8630384,8630385,8630386,8630406,7075771,7075773,8630435,8630478,7201266,8559069,8559070,8559071,8627793,10103440,8628031,8628032,8628033,7201692,7201693,7201694,7201695,7201696,7201697,7072474,8628240,8911721,8628649,8628753,8628754,8628755,8628756,8628757,8628758,8628759,8628760,8628761,8628762,8628763,8628764,8628765,8628766,8628767,8628768,8628769,8628770,8628771,8628772,8628782,8628783,8628784,8628785,8628790,8628791,8628792,10844029,11000099,8629269,8629270,8629271,8629272,10867991,8629392,8629393,8629394,8629395,8629396,8629397,8629398,8629399,8629400,8629440,8629441,8629442,8629443,8629444,8629445,8629446,8629447,8629448,8629449,8629450,8629465,8629466,8629475,8629518,8629519,8629520,8629521,11010648,11010649,11010650,11010669,11010670,11010671,11010672,11010673,11010674,11010675,11010676,11010677,11010678,11010679,11010680,11010681,11010682,11010683,11010684,11010685,11010686,11010687,11010688,11010689,11010690,11010691,8626711,8626754,8626755,8626756,3927619,8627377,8627378,8627379,8627380,8627381,8627382,8624800,8624802,8624803,8624805,8624807,8624809,8624927,8625089,8625138,8625462,8625464,8625465,8626028,8626029,8626030,8626031,8626032,8626033,8626044,10101690,8626227,8626229,8626230,8626231,8626232,8626233,8626234,8626235,10101771,8612813,11008235,8634615,8634616,8634617,8634618,8634619,8634620,8634621,8634622,8634623,8634624,8634625,8634626,8634627,8634628,8634629,8634630,8634631,8634632,8634633,8634634,8634635,8634636,8634637,8634638,8634639,8634640,8634641,8634642,8634645,8634646,11044697,11044698,11044699,8634874,8634875,8634876,8634877,8634878,8634879,8634880,8634948,8634949,8634950,8634951,10927886,10927887,8632734,8632737,10620183,8632853,8633134,8633252,8633280,8633281,8633290,8633291,8633379,8633380,8633381,8633382,8633383,8633384,8633385,8633386,8633387,8633449,8633450,8633451,8633452,8633453,8633454,8633455,8633456,8633457,8633458,8633459,8633460,8633461,8633462,8633463,8633464,8633465,8633466,8633467,8633468,8633469,8633470,8633471,8633472,8633473,8633474,8633475,8633476,8633477,8633478,8633479,8633480,8633481,8633482,8633483,8633484,8633485,8633486,8633487,8633488,8633489,8633490,8633491,8633492,8633493,8633494,8633495,8633496,8633497,8633498,8633499,8633500,8633501,8633502,8633503,8633504,8633505,8633506,8633507,8633508,8633509,8633510,8633511,8633512,8633513,8633514,8633515,8633516,8633517,8633518,8633519,8633520,8633521,8633522,8633523,8633524,8633525,8633526,8633527,8633528,8633529,8633530,8633531,8633532,8633533,8633534,8633535,8633536,8633537,8633538,8633539,8633540,8633541,8633542,8633543,8633544,8633545,8633546,8633547,8633548,8633549,8633550,8633551,8633552,8633553,8633554,8633555,8633556,8633557,8633558,8633559,8633560,8633561,8633562,8633563,8633564,8633565,8633566,8633567,8633568,8633569,8633570,8633571,8633572,8633573,8633574,8633575,8633576,8633577,8633578,8633579,8633580,8633581,8633582,8633583,8633584,8633585,8633586,8633587,8633588,8633589,8633590,8633591,8633592,8633593,8633594,8633595,8633596,8633597,8633598,8633599,8633600,8633601,8633602,8633603,8633604,8633605,8633606,8633607,8633608,8633609,8633610,8633611,8633612,8633613,8633614,8633615,8633616,8633617,8633618,8633619,8633620,8633621,8633622,8633623,8633624,8633630,8633639,8633645,8633665,8633673,8633679,8633682,8633693,8633704,8633714,8633728,8633731,8633732,8633733,8633734,8633735,8633736,8633737,8633738,8633739,8633740,8633741,8633742,8633743,8633744,8633745,8633746,8633747,8633748,8633749,8633750,8633751,8633752,8633753,8633754,8633755,8633756,8633757,8633758,8633759,8633760,8633761,8633762,8633763,8633764,8633765,8633766,8633767,8633768,8633769,8633770,8633771,8633772,8633773,8633774,8633775,8633776,8633777,8633778,8633779,8633780,8633781,8633782,8633783,8633784,8633785,8633786,8633787,8633788,8633789,8633790,8633791,8633792,8633793,8633794,8633795,8633796,8633797,8633798,8633799,8633800,8633801,8633802,8633803,8633804,8633805,8633806,8633807,8633808,8633809,8633810,8633811,8633812,8633813,8633814,8633815,8633816,8633817,8633818,8633819,8633820,8633821,8633822,8633823,8633824,8633825,8633826,8633827,8633828,8633829,8633830,8633831,8633832,8633833,8633834,8633835,8633836,8633837,8633838,8633839,8633840,8633841,8633842,8633843,8633844,8633845,8633846,8633847,8633848,8633849,8633850,8633851,8633852,8633853,8633854,8633855,8633856,8633857,8633858,8633859,8633860,8633861,8633862,8633863,8633864,8633865,8633866,8633867,8633868,8633869,8633870,8633871,8633872,8633873,8633874,8633875,8633876,8633877,8633878,8633879,8633880,8633881,8633882,8633883,8633884,8633885,8633886,8633887,8633888,8633889,8633890,8633891,8633892,8633893,8633894,8633895,8633896,8633897,8633898,8633899,8633900,8633901,8633902,8633903,8633904,8633905,8633906,8633907,8633908,8633909,8633910,8633911,8633912,8633913,8633914,8633915,8633916,8633917,8633918,8633919,8633920,8633921,8633922,8633923,8633924,8633925,8633926,8633927,8633928,8633929,8633930,8633931,8633932,8633933,8633934,8633935,8633936,8633937,8633938,8633939,8633940,8633941,8633942,8633943,8633944,8633945,8633946,8633947,8633948,8633949,8633950,8633951,8633952,8634289,8634410,8634412,8634413,8634433,11044609,11044610,11044611,11044612,11044613,11044614,7059786,9211568,10515280,10515281,10515282,10517801,10517802,10517803,10517804,10517805,10517806,10517807,10517808,10516128,10516129,10516130,10516131,10516132,10516157,10516158,10516160,10516161,10516162,10516163,10516164,10516165,10516166,10514386,10514387,10514388,10514389,10514390,10514391,10514392,10514393,10514394,10514395,10514396,10514397,10514398,10514399,10514400,10514401,10514402,10514403,10514404,10514405,10514406,10514407,10514408,10514409,10514410,10514411,10514412,10514413,10514414,10514415,10514416,10514417,10514418,10514419,10514420,10514421,10514422,10514423,10514424,10514425,10514426,10514427,10514428,10514429,10514430,10514431,10514432,10514433,10514434,10116700,10116701,10116702,10116703,10116704,10116705,10116706,10116707,10116708,10116709,10116710,10116711,10428361,9199062,9199063,9199066,9199067,9199071,9199072,8854898,9199074,8917030,8855331,10628291,10176518,10566137,10566138,10566139,10566149,10541446,10541447,10541448,10528578,10528579,10528580,10528581,10528582,10528583,10508392,10420643,10507778,10508030,10407314,10407163) 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'