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(8574125,8574135,8574136,8574138,10939960,10939977,8569737,8583656,8583684,8583689,8573661,8573662,8573663,8573664,8573688,8573693,8573694,8573700,8573701,8573740,8573741,8573742,8573743,8573744,8573745,8573746,8573747,8573748,8573749,8573928,8573929,8573942,8573943,8573944,8573977,8574002,8574004,8574005,8574013,8574024,8574025,8574100,8574104,8066139,10102118,10102126,10102127,10102128,10102129,10102130,10102148,10102164,10102168,10102182,10102188,10102191,10102194,10102219,10866091,8835352,8835355,10969809,10969810,10969811,10969812,10969813,10969814,10969815,10969845,10969846,10969847,10969848,10969849,10969850,10969851,10969852,10969853,10969854,10969855,10969916,10969917,10969937,10969938,10970086,10970093,10970094,10970104,10970119,10970120,10970136,10970137,10970138,10970139,10970140,10970141,10970142,10970167,10970168,10970290,10970330,10970331,10970332,10970333,10970334,10970491,10970512,10970513,10970514,10970515,10970566,10970567,10970568,10970569,10970570,10970571,10970620,10970621,10970622,10970623,10970639,10970640,10970641,10970879,10970908,10970915,10970916,10970917,10970935,10970936,10970998,10971005,10971027,10971044,10971045,10971046,10971047,10971048,10971049,10971050,10971051,10971052,10971053,10971054,10971126,10971135,10971136,10971137,8613122,3924198,3924201,10968633,10968635,10968636,10968753,10968754,10968755,10968756,10968757,10968758,10968759,10968760,10968761,10968762,10968763,10968820,10968821,10968822,10968823,10968824,10968825,10968826,10968827,10968828,10968829,10968830,10968831,10968832,10968833,10968834,10968835,10968836,10968837,10968838,10968839,10968840,10968841,10968842,8555374,8555375,8907596,10954012,10620300,8853185,8853209,9913716,9913717,9913718,9913723,9913798,9913799,9913800,9913803,9913807,9913815,9913883,9913888,9913889,9913936,9913937,9913962,9913994,8567071,8863104,8863116,8863129,8863140,8863151,8863156,6674840,6674841,6674842,6674843,6674855,6674856,6674857,6674858,6674957,6674979,6675082,6675116,6675117,6675118,6675119,6675120,6675121,6675408,6675409,6675434,6675435,6675452,6675453,6675454,6675455,6675456,6675457,10419232,9176499,9176550,9176551,9176586,9176594,9176608,9176609,9176610,9176686,9176694,9176698,9176743,9176752,9176753,9176754,4971474,4971475,4971480,4971483,4971526,4971536,4971578,4971580,4971592,4971622,4971636,4971639,8550454,8550470,10164838,10164846,10164847,10164848,10164849,10164850,10164851,10164857,10164858,10164859,10164905,10164931,10165028,10165029,10165030,10165031,10165032,10165033,10165034,10165035,10165036,10165037,10165076,10165077,10165078,10165079,10165080,10165081,10165082,10165083,10165084,10165085,10165086,10165087,10165088,10165089,10165090,10165091,10165092,10165093,10165094,10165095,10165096,10165097,10894153,10894154,10894155,10894156,10894224,10894232,10894234,10894297,10894298,10894299,10894301,10165344,10165362,10165380,10165381,10165382,10894378,10894396,10894397,10894398,10165414,10165415,10165416,10165417,10165449,10165450,10165451,10165452,10165453,10165454,10165455,10165456,10165525,10165526,10165527,10165528,10165529,10894544,10894545,10894561,10894562,10165577,10165578,10165579,10165580,10165581,10165582,10165583,10165584,10165585,10165586,10165587,10165588,10165589,10165590,10165591,10165592,10165593,10165594,10165595,10165596,10165597,10165598,10165599,10165600,10165601,10165602,10894615,10165902,10165910,10165938,10165939,10165954,10165998,10165999,10166000,10166001,10166002,10166003,10166047,10166048,10166049,10166050,10164185,10164186,10164187,10164188,10164189,10164190,10164191,10164192,10164193,10164194,10164195,10164196,10164197,10164198,10164199,10164200,10164201,10164202,10164203,10164261,10164262,10164263,10164264,10164265,10164266,10164267,10164268,10164269,10164270,10164271,10164272,10164273,10164274,10164275,10164276,10164277,10164278,10164279,10164280,10164281,10164282,10164283,10164284,10164285,10164286,10164287,10949103,10649177,10649201,10649202,10649203,10649204,10649304,10649314,10649324,10649325,10649335,10649343,10649155,8562327,10478004,10478035,10478036,10478165,10478180,10478181,10478182,10714843) 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'