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(4970685,11041164,11041165,11041166,11041167,11041168,11041169,11041170,11041171,11041172,11041173,11041174,11041175,11041176,11041177,11041178,11041179,11041180,11041181,11041182,11041183,11041184,11041185,11041186,11041187,11041188,11041189,11041190,11041191,11041192,11041193,11041194,11041195,11041196,11041197,3228951,3228952,8621376,8621377,8621378,8621379,8621380,8621381,3229106,3229107,3229108,3229109,3229110,10933336,10933337,10846992,10846993,10846994,10846995,10846996,10846997,10846998,10846999,10847000,10847001,10847002,10847003,10847004,10964359,8632403,8632409,8632412,8632413,8632414,8632417,8632418,10863076,10863077,10863078,10863079,10863080,8632471,8632472,8632473,8632474,8632475,8632476,8632506,8632526,8632541,8629672,8629673,8573262,7075126,7075127,7075128,7075129,7075130,7075131,7075132,7075133,7075134,7075135,7075136,8561313,8561314,10869699,10869700,10869701,10869702,10869703,10869704,10869705,10869706,10869707,10869708,10869709,10869710,10869711,10869712,10869713,10869714,10869715,10869716,10869717,10869718,10869719,10869720,10869721,10869722,10869723,10869724,10869725,10869726,10869727,10869728,10869729,10869730,10869731,10869732,10869733,10869734,10869735,10869736,10869737,8630236,8630237,8630238,8630239,8630240,8630241,8630242,8630269,8630270,10939418,9214475,9214476,9214477,8561814,10873213,10873214,10873215,8627698,8627701,3238520,10842884,7201520,7201521,7201522,7201523,7201524,7201525,7201664,8628126,8628127,8595177,7201860,10999730,10104330,8560204,8595904,7202581,7202596,10104608,10104614,10104615,10104616,9794579,8629307,3227340,8626798,8626799,10857524,10857525,10857526,10857527,10857528,10857529,10857530,10857531,10857532,10857533,10857534,10857535,10857536,10857537,10857538,10857539,10857540,10857541,10857542,10857543,10857544,10857545,10857546,10857547,10857548,10857549,10857550,10857551,10857552,10857553,10857554,3927867,8627294,8627295,8627296,8627297,8627298,8627299,8627300,8627301,8627302,8627303,8627304,8627305,8627306,8627307,8627308,8627309,7200935,10866008,10866049,10866050,10866051,10866052,10866053,10866054,8627468,8627477,8627481,8627482,8627483,8627484,8627485,8627486,8627487,8627488,8627489,8627490,8627499,8627500,8627504,8627505,8627506,8627513,8627514,8627525,8627526,8627527,10839995,10855616,7198680,10863842,8625276,8625280,10957375,8625351,10856029,10856030,10856031,10856032,10856033,10856034,10856035,10856036,10856037,10856038,10856039,10856040,10856041,10856042,3236286,3236287,3236288,3236289,3236290,3236291,3236292,3236293,3236294,3236295,3236296,3236297,10101539,10101715,10101716,10101717,3923477,10618215,8554306,3233798,8906825,10624667,7197947,10839553,10619862,8634624,8634625,8634626,8634627,8634628,8634629,8634630,8634631,8634632,8634633,8634771,8634772,8634773,8905221,8553218,10954101,3232862,11045217,8553539,8542168,8542169,8542170,8542171,8542172,8542173,10837434,10837435,8905814,10853070,10853071,10853072,10853073,8570033,10615096,10847965,10925840,10925841,10925842,10925843,10925844,10848167,10848168,10848169,10848170,10848171,10848172,8570497,8633265,8633282,10952434,10952435,10952436,8540513,10931019,10426454,10426455,10426456,10426457,10426458,10426459,9217795,8633958,8633959,8633963,10921966,10921967,10921968,10921969,8634293,8634423,8634424,8634547,8634549,8634551,8634552,8634554,10616944,10616945,10616946,10616947,10616948,10616949,10616950,9915529,7059516,10614085,10614086,10614199,10614200,10614201,10611338,10714200,10612223,10612320,10612321,7057862,10609392,8566545,8566546,8567068,10613318,10613319,9196928,9189002,10610694,10610698,10610699,10610700,10610701,9915245,10610702,10610703,10610704,10610705,10117675,8849330,8849332,10515377,10515422,10515423,9912023,9912024,9912025,9169854,9169855,9169856,10513726,7056174,10514029,10514030,3651687,8850411,9211202,8848127,8848143,8848159,8848168,8848195,10417293,6672815,6672816,6672817,6672818,6672819,6672820,6672821,6672822,6672823,6672824,6672825,6672826,6672827,6672828,6672829,6672830,6672831,6672832,6672833,6672834,6672835,6672836,6672837,6672838,6672839,6672840,6672841,6672842,6672843,6672844,6672845,6672846,6672847,6672848,6672849,6672850,6672851,6672852,6672853,6672854,6672855,6672856,6672857,6672858,6672859,6672860,6672861,6672862,6672863,6672864,6672865,6672866,6672867,6672868,6672869,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672877,6672878,6672879,6672880,6672881,6672882,6672883,6672884,6672885,6672886,6672887,6672888,6672889,6672890,6672891,6672892,6672893,6672894,10416629,10428086,10416630,10428087,10416631,10428088,10416632,10428089,10416633,10428090,10428091,10428092,10428093,10428094,10428095,10428096,10428097,10428098,10428099,10428100,10428101,10428102,10428103,10428104,10428105,10428106,10428107,10428108,10428109,10428110,10428111,10428112,10428113,10428114,10428115,10428116,10428117,10428118,10428119,10428120,10428121,10428122,10428123,10428124,10428125,10428126,10428127,10428128,10428129,10428130,10428131,10428132,10428133,10428134,10428135,10428136,10428137,10428138,10428139,10428140,10428141,10428142,10428143,10428144,9168841,8848719,8848724,8848726,8848730,8848741,8848744,8848747,8848758,8848760,8848829,8848838,8848886,8848894,8848896,8848902,8848905,8848906,10125312,10419196,10419197,10419198,10419199,10419200,8549454,8549455,8549456,10471150,10471151,8549882,8549883,8549884,8549885,8549890,8549894,8549896,8549897,8549898,8549899,8549900,8549902,8549918,8549919,8854677,9207233,9207234,9207235,9207236,9207237,9207238,9207239,9207240,9207241,9207242,9207243,9207244,9207245,9207246,9207247,9207248,9207249,9207250,9207251,9207252,9207253,9207254,9207255,9207256,8855255,8855256,8855257,8855258,8855259,8855260,8855261,8855262,8855263,8855264,8855265,8855266,8855267,8855268,8855269,8855270,8855271,8855272,8847476,9167679,8847518,8847594,9175814,6474275,9168025,9168026,9168027,9168028,8551315,8848002,8848006,8848033,8848036,8848037,8848046,8848052,8848058,8848071,8848079,9168274,9168275,9168276,8848113,8848118,8848119,10883693,10883694,10883695,10883696,10883697,10883698,10883699,10883700,10883701,10883702,10883703,10883704,10883705,10883706,10883707,10883708,10883709,10883710,10883711,10883712,10883713,10879015,10879016,10879017,10879018,10879019,10879020,10879021,10879022,10889255,10889256,10889257,8594543,10889827,10889828,10889829,10889830,10889831,10889832,10889833,10889834,10889835,10627918,10627919,10627920,10627921,10627922,10627923,10627924,10630022,10176560,10631199,10887049,10887050,10631893,10647461,10647462,10647463,10647464,10644484,10582471,10582472,10582473,10582474,10582475,10582476,10582477,10582478,10582479,10582480,10582481,10582482,10582483,10582484,10582485,10582486,10582487,10582488,10582489,10582490,10582491,10582492,10582493,10582494,10582495,10582496,10582497,10582498,10582499,10582500,10582501,10582502,10582503,10582504,10582505,10582506,10582507,10582508,10582509,10582510,10649036,10541438,10541439,10541440,10541441,10541442,10544844,10544890,10539017,10508112,10508113,10508114,10508115,10508116,10508117,10508118,10508119,10508120,10508121,10508122,10508123,10508124,10508125,10508126,10508127,10508128,10508129,10508130,10508131,10508132,10508133,10508134,10508135,10508136,10508137,10508138,10508139,10508140,10508141,10508142,10508143,10508144,10508145,10508146,10508147,10508148,10508149,10508150,10508151,10508152,10508153,10508154,10508155,10508156,10508157,10508158,10508328,10421757,10421758,10421759,10421760,10421761,10421762,10421763,10421764,10421765,10421766,10421767,10421768,10421769,10421770,10421771,10421772,10421773,10421774,10421775,10507666,10421776,10421777,10421778,10421779,10421780,10421781,10421782,10421783,10421784,10421785,10421786,10421787,10421788,10421789,10421790,10421791,10421792,10421793,10421794,10421795,10507720,10423915,10506825,10508085,10508086,10508087,10508088,10508089,10508090,10508091,10508092,10508093,10508094,10508095,10508096,10508097,10508098,10508099,10508100,10508101,10508102,10508103,10508104,10508105,10508106,10508107,10508108,10508109,10508110,10508111,10409307,10409308,10409309,10409310,10486167,10494991,10410779,10411178,10411179,10411180,10411181,10411182,10411183,10411184,10411185,10411186,10411187,10411188,10411189,10411190,10411191) 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'