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(10943463,10943464,8620886,8574522,10448381,3229036,10873932,10950295,8569743,10950566,8583434,11015674,7066004,10846814,10950768,10950769,9215884,10849689,10849695,10847178,10849781,10847246,10849829,11042290,8575901,10850061,8576107,8067969,8067971,8837700,8620126,8837788,8573487,11027032,11027067,11001083,8630093,8573641,8573670,8837989,8573689,8573717,8838049,10447441,8620465,8838120,8838132,8838139,10929953,7075833,8064918,8617872,8835537,8911139,10842841,10842842,8627828,8559236,7201608,7201614,7064386,8628153,8628154,8595174,8595251,10859036,10999603,10843688,10843718,3899599,7202602,7202603,10867700,8629114,8629115,8629116,8619462,10860072,10860073,7071008,3927404,8910470,8910471,10857750,10857752,10857753,11049399,11049400,10943243,7200934,7071821,10103048,8617767,10839727,10995932,10944668,3235834,3235835,3235836,3235838,10840204,10863867,3236069,8564432,8564451,10864163,7199405,7199411,7199414,11022860,11009903,3926758,3926794,8557522,8557523,3237193,3237195,8073537,8909907,8612812,7196332,7196333,11045848,10918752,8906303,8906320,10618294,8906333,8906423,8906446,8906462,11007111,11007112,11007113,8906499,7157020,3233966,11020516,10854371,11046826,11046832,11046848,11046866,10969012,7158039,8624489,11005631,11005637,11005638,11005639,11044650,10922548,10922549,11005707,11005712,11005713,8634677,10852475,10927735,10953906,10953907,10953908,10953909,8578565,7156114,7156117,7156274,7156275,7156295,7156296,3230454,10951740,10951741,3230628,9216866,3230692,8576572,10850723,11004138,10620551,11004242,8633222,10850952,10991372,10991373,10991374,10991375,9217393,8576973,10926446,11004607,10952563,8577145,11043673,11004737,3231478,11004796,11004797,3231558,9217876,8904333,8904336,8904358,8904367,11005019,11005020,11044086,7154965,11005124,11005125,11005126,11005127,11005229,11005230,11005231,8552563,11005437,11005442,8904821,8904823,11005516,8541351,8578029,8578030,8578031,9915537,8853309,8567996,6677701,6677704,8568016,8568017,8568018,7019176,9915760,10614221,6677815,8853587,8853629,8853630,8853631,8853632,3655036,3655037,3655042,6678060,6678061,6678072,6678073,6678074,8853763,8853764,8853765,8853766,6678156,8853785,8853787,8853788,6678173,6678174,6678175,6678176,6678177,6678178,6678179,8853823,8853825,8853826,9916236,3962371,6678294,8864686,6678421,6678430,8854061,9913639,10612198,10609544,9914160,9914186,10612931,10558323,9915077,9204909,7059089,8852822,7018780,9915348,9915355,9915364,8853063,7018929,8849248,10125851,7055835,9911995,9912045,9912046,9912218,8849935,7056384,7056388,9912431,9912438,9210416,9210535,9912932,9912934,9913037,9210922,9913230,9913330,8552468,10419241,10415285,10415286,10415287,10417300,10419316,9910638,9160487,9910717,9910926,9168723,10415662,10418693,9911163,6681164,6673310,7014844,10417113,10417115,10417117,10417118,10417127,9206320,9190328,6678611,8549568,8854300,8854301,9916747,9916750,8854669,8854694,8854761,8854946,8854974,8854984,8854985,3963621,8855185,8855186,8855187,8855188,8855189,8855190,8855212,8855213,8855231,8855232,8855235,8855243,8855244,8855245,8855246,8855248,8855288,8855291,8550728,9207611,9191662,8917349,9207719,9207853,9207855,9207857,9207858,6667879,9199931,8551199,6672502,10184492,10184495,10184498,10184501,10184505,10184507,10883623,10159747,10159786,10179818,10159820,10159936,10184966,10155244,10904308,10628799,10628800,10628801,10889465,10914614,10165679,10165680,10185825,10884820,10180866,10156115,10163547,10158789,10877816,10158837,10907880,7001104,7001114,10887965,10887966,10154018,10913152,10888158,10888165,10184197,10946055,10184436,10630101,10905703,10182186,10162266,10177553,10182580,10187647,10172920,10172921,10172922,10626407,10172960,10882345,10882357,10950172,10950183,10882410,10945238,10602551,10608578,10602658,10602661,10602695,10602708,10602715,10644134,10603420,10587624,10588089,10651322,10645473,10601801,10529452,10529478,10529479,10529480,10529490,10546161,10546432,10544687,10520945,10520946,10420365,10420425,10424458,10424459,10506392,10506393,10506394,10506395,10506396,10506397,10506398,10506399,10506400,10506401,10506402,10506403,10506404,10506405,10506406,10506407,10506408,10506409,10506410,10506411,10424563,10407235,10407241,10472917,10472920,10472921,10472922,10472923,10472924,10472925,10407312,10407338,10407495,10490177,10413537,10475236,10481422,10475626,10475627,10407977,10490632,10413992,10408016,10412348,10474155,10474156,10474157,10491160,10474231,10472294,10497488,10408948,10489630,10489631,10408999,10409002,10474713,10487794) 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'