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(7075967,10939616,11001732,11001733,11001734,8594633,10963076,10963081,10963082,10963083,10963084,10963085,10963086,10963087,10963088,10846246,11015382,10846467,9215571,11041608,11041644,7073987,10950924,10951042,3229976,10437454,10437455,10437456,10847536,10860256,8629705,8561135,7067304,10845070,7075459,7067472,7067473,8561424,8630223,8617792,8617793,8617794,8617795,8617796,7201206,7201207,8617797,8617798,8617799,8617800,8617801,8617802,8617803,8617804,8617805,8617806,8617807,8617808,8617809,8617810,8617811,8617812,8617813,8617814,8617815,8617816,8617817,8617818,8617819,7201254,8627919,10931622,8627922,8627933,10103619,10999253,8618468,8618471,8559620,8559621,8559622,8559626,8595435,8628445,10932451,10932452,10932453,7202357,7202359,10932468,10867487,10843977,10104488,11000164,10844283,10844284,10844285,10844286,7065616,7065620,10987346,10844424,10844425,10844426,10844427,10844428,10844429,10844430,10844431,10844432,7065681,10844433,10844434,10099831,10844435,10099899,11036638,11036639,8626898,7200648,7200651,7200653,7200655,7200662,7200663,7200670,7200672,7200678,7200681,7200688,7200692,7200696,7200702,8910776,10102915,10102919,8558781,8558782,8558789,8558790,8558791,10839720,10944770,10840450,10840451,10840452,10840453,10840454,10840455,11009430,11009431,11009432,11009433,11009442,11009443,10840966,10840967,3926669,10101652,10101944,10101945,10101946,10984526,7196333,11006878,11006879,11006880,11006881,11006882,7196455,7196456,7196457,7196458,7196459,7196460,7196461,7196462,7196463,7196464,7196465,7196466,7196467,7196468,7196469,11045937,11045938,10623374,3923779,3923917,10981275,10981276,10838357,8554640,10838477,8613864,8555033,10854380,10621977,10927528,10927529,10927530,10836899,10917866,8541983,8541984,8553545,10993408,3230448,3230449,3230450,8570181,8576424,8576425,9216963,9216964,10951971,10951972,10951973,10850840,3582049,3582050,3582051,3582052,11043392,11043393,11043394,11043395,3582160,10978633,10978634,8610863,10952661,8540670,10916707,10916708,8611121,10926898,8552542,10621689,10621690,10621691,10621692,10621693,10621694,10621695,10621696,10621697,10621698,10621699,10621700,10922215,10922216,10917347,8634471,10852115,9197882,10562725,10562726,10562727,10562728,10562729,10562730,10562731,10562732,10562733,10562734,10562735,10562736,10562737,10562788,10562789,10119503,10119504,9211380,9187414,10612132,8542648,9171666,9171879,9914116,9914117,9914118,6676121,6676122,6676123,6676124,9212139,9196220,9212288,9212289,9914628,9914629,9914630,9914631,9914632,9914633,9914634,9914635,9914636,9914637,9914638,9914639,9914640,9914641,9914642,9914643,9914644,9914645,9914646,9914647,9914648,9914649,9914650,9914651,9914652,9914653,9914654,9172669,9172670,9172671,9172672,9172673,9172674,9172675,8567382,9172910,10121118,9189127,9189193,9189219,7015069,10125637,10125644,10515377,10515422,10125807,10515423,10513739,10516056,3285954,6674538,10516374,10516375,10516462,10516463,10516464,10516465,10516466,10516467,10516468,10516469,10516470,10516473,10516474,10516475,10516476,10516477,10516478,10516479,10516480,10516481,10516482,10516483,10516484,10516485,9203022,10119309,10517028,10124556,10117025,10117206,10117308,10122525,9190742,8569256,9174848,9174849,9174850,9174851,9174852,9174853,9174854,9174855,9174856,9174857,9174858,8569366,3963595,3963597,6679494,10123706,10123776,9207725,6474179,8917588,9176229,10174491,10169877,10175230,10175231,10175232,10175233,10175234,10175235,10175236,10175237,10175238,10175239,10175240,10175241,10175242,10175243,10175244,10175245,10175246,10175247,10175297,10175298,10175299,10175300,10175301,10175302,10175303,10175304,10175305,10175306,10175307,10175308,10175309,8594322,8594323,10894756,10909946,10909947,10909948,10909949,10892557,10163613,10163930,10892988,10892989,10892990,10892991,10893034,10179062,10184211,10184212,10174453,10174481,10167021,10167022,10891153,10891154,10891177,10891178,10881551,10162854,10631749,10574240,10574241,10652423,10574549,10587077,10587078,10653396,10603571,10573316,10648600,10520355,10520356,10520357,10520358,10520359,10520360,10520361,10520362,10520363,10520364,10520365,10520366,10520367,10520368,10520369,10520370,10520371,10520372,10520373,10520374,10520375,10520376,10520377,10520378,10520379,10520380,10520381,10520382,10520383,10520384,10520385,10520386,10520387,10520388,10520389,10520390,10520391,10520392,10520393,10520394,10508486,10507607,10425026,10473155,10473156,10490317,10494348,10490512,10490513,10490520,10490521,8562998,8562999,8563000,10473693,10410108,10473881) 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'