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(4970757,3229172,3229199,3229200,7065938,8583522,7066214,7066215,7066216,7066217,7066218,7066219,7066220,7066221,7066222,8629621,10939390,10939425,5654628,5654672,10857127,10857226,10857227,10865413,10865414,10865415,7200403,8627068,10857892,10855607,10855608,10855609,10855612,10855613,10855614,10855669,10855670,10855671,10855672,10855673,10855674,10855675,10855676,10855677,10855678,10855679,10855680,10855681,10855682,10855683,10855684,10855685,10855686,10855687,10855688,10855689,10855690,10855691,10855692,10855693,10855694,10855695,10855696,10855697,10855698,10855699,10855700,10855701,10855702,10855703,10855704,10855705,10855706,10855707,10855708,10855709,10855710,10855711,10855712,10855713,10855714,10855715,10855716,10855717,10855718,10855719,10855720,10855721,7198851,7199580,7199581,7199582,7199583,7199584,7199585,7199586,7199587,7199588,7199589,10101572,7199783,7199784,7199785,7199786,7199787,7199788,7199789,7199790,7199791,7199792,7199793,7199794,7199795,7199796,7199797,7199798,7199799,7199800,7199801,7199802,7199803,7199804,7199805,7199806,7199807,7199808,7199809,7199810,7199811,7199812,7199813,7199814,7199815,7199816,7199817,7199818,7199819,7199820,7199821,7199822,7199823,7199824,7199825,7199826,7199827,7199828,7199829,7199830,7199831,7199832,7199833,7199834,7199835,7199836,7199837,7199838,7199839,7199840,7199841,7199842,7199843,7199844,7199845,7199846,7199847,7199848,7199849,7199850,7199851,7199852,7199853,7199854,7199855,7199856,7199857,7199858,7199859,7199860,7199861,7199862,7199863,7199864,7199865,7199866,7199867,7199868,10865015,10865016,10865017,10865018,10865019,3923496,3923643,3923644,8906552,8906553,8906554,8906598,8906599,8906600,8906601,8906602,8906603,8906604,8906605,8906606,8906607,8906608,8906609,8906610,8906611,8906612,8906613,8906614,8906615,7197484,7197485,7197486,7197487,7197488,7197489,7197490,7197491,7197492,7197493,7197494,7197495,7197496,7197497,7197498,7197499,7197500,7197501,7197502,7197503,7197504,7197505,7197506,7197507,7197508,7197509,7197510,7197511,7197512,7197513,7197514,7197515,7197516,7197517,7197518,7197519,7197520,7197521,7197522,7197523,7197524,7197525,7197526,7197889,8905146,8905147,10616026,10616027,10616028,10616029,10616030,10616031,10616032,10616033,10616034,10616035,10616036,10616037,10616038,10616039,10616040,10616041,10616042,10616043,10616044,10616045,10616046,10616047,8611316,10616863,9165550,10714188,8851453,8566538,8852547,10610403,10610404,10610405,10610406,10610407,10610408,10610409,10610410,10610411,10610412,8852575,8852577,8852580,8852582,8852585,8852586,8852588,8852589,8852590,8852593,8852594,8852595,8852596,8852600,8852602,8852603,8852605,8852608,8852609,8852610,8852611,8852613,8852615,8852617,8852620,8852621,8852629,8852631,8852635,8852636,8852641,8852644,8852645,8852648,8852650,8852656,8852658,8852659,8852661,8852663,8852664,8852667,8852671,8852672,8852674,8852675,8852677,10610568,10610698,9169468,9911827,9169660,9169708,9169709,9169710,6674173,6674174,6674223,6674229,6674230,6674231,6674232,6674233,6674234,6674235,6674236,6674237,6674238,6674239,6674240,6674241,6674242,6674243,6674244,10118244,10118520,10118521,8850198,8850199,8850200,8850201,8850202,8850203,8850204,8850205,8850206,8850207,8850208,8850209,8850210,8850211,8850212,7013963,7013964,7013965,7013966,7013967,7013968,7013969,7013970,7013971,7013972,7013973,7013974,7014095,7014096,7014097,7014098,7014099,7014100,7014101,7014102,7014103,7014104,7014105,7014106,7014107,7014108,9910874,10117423,10117424,10468902,10468903,8550209,10467842,10467843,10467844,10467845,10467846,10467847,10467848,10467849,10467850,10467851,10467852,10467853,10468300,9167979,9167980,9167981,10470664,10470665,10470666,10470667,10470668,10470669,10470670,10470671,10470672,10470673,10470674,10470675,10470735,10470736,10470737,10470738,10470739,10470740,10470741,10470742,10470743,10470744,10470745,10470746,10470747,10470748,10470749,10470750,10470751,10470752,10470753,10470754,10470755,10470756,10470757,10470758,10470759,10470760,10470761,10470762,10470763,10470764,10470765,10470766,10470767,10470768,10470769,10470770,10470771,10470772,10470773,10470774,10470775,10470776,10470777,10470778,10470779,10470780,10470781,10470782,10470783,10470784,10470785,10470786,10470787,10470788,10470789,10470790,10470791,10470792,10470793,10470794,10470795,10470796,10470797,10470798,10427640,10427641,10883530,10889073,10889074,10889075,10889076,10889077,10889078,10889079,10889080,10889081,10889082,10889083,10889084,10889085,10889086,10889087,10889088,10889089,10889090,10889091,10889092,10889093,10889094,10889095,10889096,10889097,10889098,10889099,10889100,10889101,10889102,10889103,10889104,10889105,10889106,10889107,10889108,10889109,10889110,10889111,10889112,10889113,10889114,10889115,10889116,10889117,10889118,10889119,10889120,10889121,10889122,10889123,10889124,10889125,10889126,10889127,10889128,10889129,10889130,10889131,10889132,10889133,10889134,10889135,10889136,10889137,10889138,10889139,10889140,10889141,10889142,10889143,10889144,10889145,10889146,10889147,10889148,10889149,10889150,10889151,10889152,10889153,10889154,10889155,10889156,10889157,10889158,10889159,10889160,10889161,10889162,10889163,10889164,10889165,10889166,10889167,10889168,10889169,10889170,10889171,10889172,10889173,10889174,10889175,10889176,10889177,10889178,10889179,10889180,10889181,10889182,10889183,10889184,10889185,10889186,10889187,10889188,10889189,10889190,10889191,10889192,10889193,10889194,10889195,10889196,10889197,10889198,10889199,10889200,10889201,10889202,10889203,10889204,10889205,10889206,10889207,10889208,10889209,10889210,10889211,10889212,10889213,10889214,10889215,10889216,10889217,10889218,10889219,10889220,10889221,10889222,10889223,10889224,10889225,10889226,10889227,10889228,10889229,10889230,10889231,10889232,10889233,10884434,10884435,10885340,7000849,7000850,7000851,7000852,7000853,10882986,10888362,10883464,10883465,10883466,10161931,10885932,10885933,10885934,10885935,10162201,10876765,10876766,10647507,10647670,10647671,10647672,10647673,10508331,10508489,10505551,10505552,10505553,10505554,10505555,10505556,10410773,10410775,10410776,10410777,10410826,10410827,10410828,10410829,10410830,10410831,10410832,10410833,10410834,10410835,10410836,10410837,10410838,10410839,10410840,10410841,10410842,10410843,10410844,10410845,10410846,10410847,10410848,10410849,10410850,10410851,10410852,10410853,10410854,10410855,10410856,10410857,10410858,10410859,10410860,10410861,10410862,10410863,10410864,10410865,10410866,10410867,10410868,10410869,10410870,10410871,10410872,10410873,10410874,10410875,10410876,10410877) 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'