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(3228947,3228962,3228996,10862131,10862132,10862133,10862134,10862135,10862136,10862137,10862138,10862139,10862140,10862141,10862142,10862143,10862144,10862145,10862146,10862147,10862148,10862149,10862150,10862151,10862152,10862153,10862154,10862155,10862156,10862157,10862158,10862159,10862160,10862161,10862162,10862163,10862164,10862165,10862166,10862167,10862168,10862169,10862170,10862171,10862172,10862173,10862174,10862175,10862176,10862177,10862178,10862179,10862180,10862181,10862182,10862183,10862184,10862185,10862186,10862187,10862188,10862189,10862190,10862191,10862192,10862193,10862194,10862195,10862196,10862197,10862198,10862199,10862200,10862201,10862202,10862203,10862204,10862205,10862206,10862207,10862208,10862209,10862210,10862211,10862212,10862213,10862214,10862215,10862216,10862217,10862218,10862219,10862220,10862221,10862222,10862223,10862224,10862225,10862226,10862922,10862923,10862924,10862925,7201645,7201667,8065805,5654576,5654636,10865440,10865441,10865442,10865443,10855592,10855593,10855594,10855595,10855596,10855597,10855598,10855599,10855600,10855601,10855602,10855603,10855604,10855605,10855606,10855607,10855608,10855609,10855610,10855611,10855612,10855613,10855614,10855615,10855616,10855617,10855618,10855619,10855620,10855621,10855622,10855623,10855624,10855625,10855626,10855627,10855628,10855629,10855630,10855631,10863905,7199299,11048440,11048441,3923408,10853672,10853673,10623582,7197419,7197420,7197421,7197422,7197423,7197424,7197425,7197426,7197427,7197428,7197429,7197430,7197431,7197432,7197433,7197434,7197435,7197436,7197437,7197438,7197439,7197440,7197441,7197442,7197443,7197444,7197445,7197446,7197447,7197448,7197449,7197450,7197451,7197452,7197453,7197454,7197455,7197456,7197457,7197458,7197459,7197460,8905118,8905119,8905120,8905121,8905122,8905123,8905124,8905125,8905126,8905127,8905896,8905897,8905898,10426218,10426219,10426220,10426221,10426222,10426223,10426224,10426225,10426226,10426227,10426228,10426229,10426230,10426231,10426232,10426233,10426234,10426235,10426236,10426237,10426238,10426239,8611314,8611396,10614096,10714172,10614742,10614743,10614744,8852254,8852255,10610352,10610353,10610354,10610355,10610356,10610357,10610358,10610359,10610360,10610361,10610362,10610363,10610364,10610365,10610366,10610367,10610368,10610369,10610370,10610371,10610372,10610373,10610374,10610375,10610376,9169354,9169355,9169356,10117567,10117568,9911602,6673760,6673761,6673762,6673763,6673764,6673765,6673766,9169719,9911975,9911976,9911977,10118093,10118273,10118274,10118275,10118276,10118277,8850183,9912859,9912860,9912861,9912862,9912863,9912864,9912865,8850544,9171075,6672713,6672714,6672715,6672716,6672717,6672718,6672719,10416495,10418732,10418733,10415841,10415842,10415843,10415844,10415845,10415846,10415847,10415848,10415849,10415850,10415851,10415852,10415853,10415854,10415855,10415856,10415857,10415858,10415859,10415860,10415861,10415862,10415863,10415864,10415865,10415866,10415867,10415868,10415869,10415870,10415871,10415872,10415873,10415874,10415875,10415876,10415877,10415878,10415879,10415880,10415881,10415882,10415883,10415884,10415885,10415886,10415887,10415888,10415889,10415890,10415891,10415892,10415893,10415894,10415895,10415896,10415897,10415898,10415899,10415900,10415901,10415902,10415903,10415904,10415905,10415906,10415907,10415908,10415909,10415910,10415911,10415912,10415913,10415914,10415915,10415916,10415917,10415918,10415919,10415920,10415921,10415922,7055445,8549966,8916795,10467815,10467816,10467817,10467818,10467819,10467820,10467821,9167971,9167972,9167973,9167974,9167975,9167976,9167977,9167978,9168141,10884606,10884607,10884608,10884609,10884610,10884611,10887699,10887700,10887701,10887702,10887703,10887704,10887705,10887706,10887707,10887708,10887709,10887710,10887711,10627727,10883445,10883446,10883447,10883448,10883449,10883450,10883451,10883452,10883453,10883454,10883455,10883456,10883457,10883458,10883459,10883460,10883461,10886907,10886908,10886909,10647392,10647393,10524907,10524908,10507599,10507600,10507601,10507602,10507603,10507604,10507605,10507606,10507607,10507608,10507609,10507610,10507611,10507612,10507613,10507614,10507615,10507616,10507617,10507753,10508046,10409690,10409691,10410756,10410757,10410758,10410759,10410760,10410761,10410762,10410763,10410764,10410765,10410766,10410767,10410768,10410769,10410770,10410771,10410772,10410773,10410774,10410775,10410776,10410777,10410778,10410779,10410780,10410781,10410782,10410783,10410784,10410785,10410786,10410787,10410788,10410789,10410790,10410791,10410792,10410793,10410794) 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'