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(10845688,10962711,10962712,10962713,10962714,10962715,10962716,10962717,10962718,9214763,10845911,9214830,8838758,8630945,10861628,10861629,10861630,10861631,3228995,10873967,10873968,7073961,8621803,8621807,10963669,10963670,10963671,7074031,10862337,8067284,8575521,8575743,11042341,11042342,8067778,11013637,11013638,11013639,11013640,11013641,11013642,11013643,11013644,11013645,11013646,11013647,10961872,10961873,10961874,10961875,10961876,7067289,11039977,11039978,10860649,11040181,11040182,11014392,9214361,10998557,10998558,11037559,10998559,10998560,11037560,6000161,6000172,7071894,7071895,7071896,7071897,11037626,8911002,8911003,6000261,11011737,11011738,11011739,11011740,11037971,11037972,8559281,11012113,11012114,11012115,8559456,11038374,11038418,10103878,10103892,7072767,7072768,7072769,8595415,11038458,11038459,11038542,11038543,11038544,10999571,8066006,8066007,8066008,8066009,8066010,8618851,8618861,8618875,8618876,11038733,8618887,8618889,8618911,8619043,8619061,7073305,8619180,8560339,11039106,11039107,10859724,10859739,10859740,8836964,10974164,10859830,10859851,10859852,8837124,8837125,7073776,7073802,11036521,3927351,3927421,3927422,8910238,8910246,11037152,11037156,11037169,11037170,8617328,10959258,10858009,10858010,10858011,10858012,10858013,10102861,11008674,11008675,11008676,11008677,3656062,3656063,3656077,10840275,10840276,10840277,3926281,3236400,8565037,11023154,11023167,8860392,8860417,10856811,8073475,3927066,10942499,10837734,3923387,10618210,11006870,11006871,3923713,3923714,3923715,8554526,8554527,8554528,8554529,8554530,8554531,8554532,8554533,8554534,8555033,8555034,8555035,8555036,8555037,10619363,10619364,8624239,10839346,8624240,10839347,8624241,10839348,10839349,10839350,10917498,11005727,11005728,11005729,8541569,3232674,10953958,8634969,8634970,8634971,8905564,10460405,10460409,10460414,11016672,11016673,11016674,11016675,11016676,11016677,11016678,10915786,10915787,10915788,10915789,10915790,10915791,10915792,11016895,11016896,11016897,11016898,11016899,11016900,11016901,11016902,11016903,11016934,8570239,10850694,10926227,10926228,10926229,9217651,8610859,8633979,8633984,10992248,10852066,10922455,8577983,9165459,9213602,9915837,9206071,8864626,8864627,8864635,8864636,8864640,9174146,9174147,9174148,9174149,9206234,6675554,9171369,8542666,8542670,7058650,9172558,8863234,7026554,7055489,10125550,10125551,9169507,9169508,9201572,9201573,9201574,9185588,10515674,8849804,8849848,7023696,7023822,9912438,4975237,9912787,9200376,9192457,9192561,10415510,10415511,10415512,9911169,10416009,6681313,4974030,10117411,6670775,9190743,9190744,9190745,9198947,8854775,9917202,6679442,9199257,9191265,9191305,6667371,6667372,6667586,6667587,10123933,10123940,10123941,10123951,10124082,10124103,10116145,8917736,10159529,10159530,10169781,10169782,10893871,10909238,10909239,10909240,10909241,10909242,10909243,10629076,10629077,10629078,10629079,10629080,10629081,10629082,10629083,10629084,10629085,10629086,10629087,10629088,10629089,10629090,10629091,10629092,10884608,10629122,10629123,10629152,10170739,10170740,10170741,10170742,10155752,10155879,10155880,10155881,10155882,10155883,10155884,10155885,10155886,10155887,10879880,10879881,10879882,10879895,10166311,10166440,10892501,10892502,10892503,10892504,10158733,10158734,10158735,10158736,10158737,10158738,10158739,10158740,10158741,10158742,10158743,10158744,10158745,10158746,10158747,10912843,10907862,10913379,10171666,10171667,10171668,10171669,10171670,10171671,10171672,10171673,10626112,10626113,10626114,10187755,10187756,10187757,10178010,10178011,10178120,10912240,10912241,10912242,10912325,10912326,10912327,10912328,10912329,10173456,10173457,10173458,10586255,10586256,10586257,10586258,10586259,10586260,10586261,10586262,10586263,10586465,10586466,10586467,10586468,10586469,10586470,10586471,10586472,10586473,10586474,10652777,10652786,10650094,10650095,10650096,10650097,10650098,10650099,10650100,10599040,10650101,10650102,10650103,10650104,10650105,10650106,10584169,10584170,10644635,10644636,10644637,10644638,10644639,10644640,10644641,10644642,10650945,10606889,10606895,10606901,10606902,10606935,10654172,10654173,10654174,10654175,10606971,10606984,10567243,10567244,10651328,10651329,10651330,10645407,10645408,10645409,10570569,10645871,10645872,10586013,10586014,10551161,10551162,10551163,10551164,10519242,10519243,10519244,10519245,10519246,10519247,10519248,10519249,10519250,10519251,10519252,10519253,10519254,10519255,10529277,10525468,10525469,10525470,10525471,10525472,10525473,10525474,10525475,10525476,10525477,10525478,10525479,10525480,10525481,10525482,10525483,10525484,10525485,10525486,10525487,10525488,10525489,10525490,10525491,10525492,10553623,10553624,10553625,10553626,10553627,10553628,10553629,10522732,10520920,10508384,10505386,10505387,10505388,10424590,10505496,10505497,10506596,10498603,10498604,10498605,10498606,10498607,10498608,10498609,10498610,10498611,10498612,10498613,10498614,10498615,10498616,10498617,10498618,10498619,10498620,10498621,10498622,10411723,10496517,10496518,10496519,10496520,10413910,10414159,10414175,10414176,10414243,10414244,10414265,10414266,10474009,10474011,10412594,10412595,10412597,10412598,10412599,10408721,10414893,10414894,10476609,10476610) 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'