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(11027787,11027788,11027789,11027790,11027794,11027795,11027796,11027797,11027798,11027799,11027800,11027801,11027802,11027803,11027804,11027805,11027806,11027807,11027808,11027809,11027810,11027811,11027812,11027813,11027814,11027815,11027816,11027817,11027818,8838758,10870609,11002062,11002268,11002269,11002270,4970873,11002484,10963508,11015511,11002636,11002637,11002638,8621812,11002823,7074165,11002933,8575521,11003035,10849725,11003189,10862863,11003382,11003507,10961671,10961672,10961673,10961674,8620002,10987882,8837864,10447311,10447312,10447313,8620295,8838064,8838065,11014358,10972732,10972868,8627881,8627882,7072621,11025308,11025309,11025310,11025317,11025318,11025319,11025320,11025321,11025322,11025323,7072722,7072769,7202166,7202170,8836436,7202234,8066117,7202398,8628798,7202399,8619442,8619515,8619516,10961403,8619591,8619667,10961525,10961526,10961527,11023686,11023687,8617018,8617062,11023922,11023923,11024041,8617266,8617267,8617268,8617384,10985257,10985258,7200829,8617479,4430308,7071715,8614784,3925591,11034901,11021918,11021919,11021920,11021921,11021922,11021923,11021924,11021925,3925678,10863619,3925740,3925807,8615278,8615325,3925904,8615402,3925991,3926102,3926105,11035537,8615738,11022618,11022619,11022620,11022621,11035760,11035761,10970761,10970762,10970763,11022805,10970963,11035973,8909347,8909348,8909349,10997101,10997102,10971217,10971218,8909596,8909597,10997224,10997225,8909598,10997226,10997320,10997321,10997322,10997323,8909793,8909794,11023426,8909956,10617999,10618000,10618001,10918547,10618082,11032795,11032796,11032797,8906209,8906210,7156777,7156778,7156779,8906395,8906396,7156924,10918969,10918970,10918971,10918972,10918973,11033280,10919321,10919322,10919323,10919324,10919325,11033474,11033475,3924207,8906911,10994597,10968691,10968692,7157595,10994766,10994767,11033781,10994798,10919668,11020890,11020895,11020896,11020897,11020898,11020899,11020900,11020901,11020902,11020903,11020904,11020905,10994926,7157786,7157787,10919868,10919919,11034113,11034114,11034115,7157981,7157982,10839277,11034238,10969311,10969312,11034456,11034457,11034561,11034562,11034563,11034564,11034565,11034566,11034567,8541454,11005693,11005727,11031755,11031756,11031757,11031758,8542124,7156165,7156166,10918186,10918378,10918379,10918380,10918381,10918382,10918383,10918384,10918385,10918386,10614972,11003717,10615092,10620235,10620236,11029986,11029987,11029988,11029989,11029991,11029992,11029993,11029994,8570286,11029995,11029996,11029997,11029998,11029999,11030000,11030001,11030002,11004144,8576648,8576649,8633191,8633192,8576817,8576818,10991418,10991419,10991420,3231158,11004481,8576990,11004562,11030774,10426529,11004889,11004890,11004891,11004892,10921784,10921785,8577448,8577449,11005075,8541081,11031295,11031296,11031297,11031298,11031299,11031300,11031301,11005321,10851981,10851982,10851983,10851984,10851985,11031463,11031464,11031465,11031466,11031467,11031468,10616840,10616841,11005585,11005586,8853128,6677557,6677587,6677961,6677962,6677963,9190057,9916268,8853955,8853956,9916395,9916396,9190198,9203359,10609271,9187640,9203689,9187733,9187734,9187735,10557569,10557570,10557571,10557572,10557573,9203856,9187923,9188004,8851922,8851923,8851924,8851925,8851926,8851927,7058663,7058699,7058738,9204684,9915211,10117645,10117646,9193622,9193623,9193718,8849620,8593017,8593018,9194144,9194145,9194146,9194147,9194148,10556067,10556068,10556069,10556070,10556071,10556072,9202299,9194370,9194509,9202626,9194740,9194917,9171158,9171238,8848134,6680609,6680610,9192449,9200497,10416427,8848417,8848420,8848421,9200620,9200750,9200751,9200851,8848861,8849115,8849117,8849118,8854144,8854145,9916578,8854231,8854233,8854234,8854236,8854237,8854238,8854239,8854297,8854299,8854308,8854309,8854312,8854313,8854315,8854317,8854318,8854337,8854348,8854373,8854380,8854386,10122763,9916788,9916789,6678802,10122803,8854496,8854497,8854766,8854767,8854795,6679393,8855053,8855054,10469925,10123584,10115587,8847402,8847564,6679969,9175948,8847805,8847807,8847808,6680336,6680337,6680338,6680339,6680340,10179969,10909008,10180219,10180220,10180221,10165243,10165244,10904342,10914412,10914413,10894455,10894456,10894457,10914489,10904524,10904525,10180632,10180633,10180634,10180635,10180636,10914681,10904743,10904744,10904745,10904746,10904933,10904934,10904935,10904936,10904937,10180985,10180986,10180987,10180988,10914989,10629543,10166148,10166194,10166195,10166233,10166234,10166235,10181258,10629938,10629939,10629940,10183665,10183666,10183667,10183668,10183669,10912968,10912969,10912970,10912971,10913123,10888201,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10913263,10174386,10181524,10181525,10181526,10630074,10630103,10890805,10182074,10182075,10906167,10182238,10172299,10172300,10182393,10906497,10906498,10182653,10906841,10906842,10906843,10906844,10906845,10906846,10882037,10183160,10183340,10577230,10577231,10602157,10577578,10577579,10568708,10568709,10568710,10574806,10652960,10577938,10571951,10571952,10575219,10575220,10575221,10572321,10572374,10575582,10575700,10575701,10575702,10575703,10575704,10578798,10578799,10578800,10578843,10576000,10576001,10576002,10579140,10588734,10588735,10588736,10588737,10601594,10576798,10604655,10601712,10553283,10553284,10553285,10553286,10535487,10535488,10535489,10539718,10536110,10536111,10536112,10536434,10534683,10534684,10534685,10534686,10524816,10540824,10526911,10550974,10550975,10487942,10487943,10487944,10493945,10488027,10494041,8562384,10494150,8562557,10496922,10408658,10408659,10408660,10495520,10493768,10493769,10487835,10487865) 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'