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(10930423,8621888,8621889,8631901,8631902,8631903,8631904,8631905,8631906,8631907,8631908,8631909,8631910,8631911,8631912,8631913,8631914,8631915,8631916,8631917,8631918,8631919,8631920,8631921,8631922,8631923,8631924,8631925,8631926,8631927,8631928,8631929,8631930,8631931,8631932,8631933,8631934,8631935,8631936,8631937,8631938,8631939,8631940,8631941,8631942,8631943,8631944,8631945,8631946,8631947,8631948,8631949,8631950,8631951,8631952,8631953,8631954,8631955,8631956,8631957,8631958,8631959,8631960,8631961,8631962,8631963,8631964,8631965,8631966,8631967,8631968,8631969,8631970,8631971,8631972,8631973,8631974,8631975,8631976,8631977,8631978,8631979,8631980,8631981,8631982,8631983,8631984,8631985,8631986,8631987,8631988,8631989,8631990,8631991,8631992,8631993,8631994,8631995,8631996,8631997,8631998,8631999,8632000,8632001,8632002,8632003,8632004,8632005,8632006,8632007,8632008,8632009,8632010,8632011,8632012,8632013,8632014,8632015,8632016,8632017,8632018,8632019,8632020,8632021,8632022,8632023,8632024,8632025,8632026,8632027,8632028,8632029,8632030,8632031,8632032,8632033,8632034,8632035,8632036,8632037,8632038,8632039,8632040,8632041,8632042,8632043,8632044,8632045,8632046,8632047,8632048,8632049,8632050,8632051,8632052,8632053,8632054,8632055,8632056,8632057,8632058,8632059,8632060,8632061,8632062,8632063,8632064,8632065,8632066,8632067,8632068,8632069,8632070,8632071,8632072,8632073,8632074,8632075,8632076,8632077,8632078,8632079,8632080,8632081,8632082,8632083,8632084,8632085,8632086,8632087,8632088,8632089,8632090,8632091,8632092,8632093,8632094,8632095,8632096,8632097,8632098,8632099,8632100,8632101,8632102,8632103,8632104,8632105,8632106,8632107,8632108,8632109,8632110,8632111,8632112,8632113,8632114,8632115,8632116,8632117,8632118,8632119,8632120,8632121,8632122,8632123,8632124,8632125,8632126,8632127,8632128,8632129,8632130,8632131,8632132,8632133,8632134,8632135,8632136,8632137,8632138,8632139,8632140,8632141,8632142,8632143,8632144,8632145,8632146,8632147,8632148,8632149,8632150,8632151,8632152,8632153,8632154,8632155,8632156,8632157,8632158,8632159,8632160,8632161,8632162,8632163,8632164,8632165,8632166,8632167,8632168,8632169,8632170,8632171,8632172,8632173,8632174,8632175,8632176,8632177,8632178,8632179,8632180,8632181,8632182,8632183,8632184,8632185,8632186,8632187,10847385,7066880,8629694,8629695,8629696,8629697,8629698,8629699,8629700,8629701,8629749,8629750,8629798,8629802,8629803,10872655,10872656,10872657,10872658,10872659,10872660,10872661,10872662,10872663,10872664,10872665,10962454,10960077,10960078,10960079,10960080,10960081,10960082,7202525,7202526,7202527,7202528,7202529,7202530,10104577,7202700,8619761,3237389,3237390,3237391,3237392,3237393,3237394,3237395,3237396,3237397,3237398,10959008,7200892,8627341,8627342,8627343,8627344,8627345,8627346,8627347,8627348,8627349,8627350,8627351,8627352,8627353,8627354,8627355,8627356,8627357,8627358,8627359,8627360,8627361,8627362,8627363,8627364,8627365,8627366,8627367,8627368,8627369,8627370,8627371,8627372,8627373,8627374,8627375,8627376,8627377,8627378,8627379,8627380,8627381,8627382,8627383,8627384,8627385,8627386,8627387,8627388,8627389,8627390,8627391,8627392,8627393,8627394,8627395,8627396,8627397,8627398,8627399,8627400,8627401,8627402,8627403,8627404,8627405,8627406,8627407,8627408,8627409,8627410,8627411,8627412,8627413,8627414,8627415,8627416,8627417,8627418,8627419,8627420,8627421,8627422,8627423,8627424,10839702,8626070,10618304,10619169,3234578,3234579,3235028,3235029,3235030,3235031,3235032,3235033,8624407,8541548,8542255,10837679,10837680,10837681,10837682,10837683,9216600,10615083,8570158,10615352,10615532,8633265,8633266,8633267,8633268,8633269,8633270,8633271,8633272,8633273,8633274,8633275,8633276,8633277,8633278,8633279,8633280,8633281,8633282,8633283,8633284,8633285,8633286,8633287,8633288,8633289,8633290,8633291,8633292,8633293,8633294,8633295,8633296,10615708,9217411,11044119,11044120,11044121,11044122,11044123,11044124,11044125,11044280,11044283,11044284,11044285,8634297,8634298,8634299,8634300,7059519,7059520,7057638,7057639,7057649,9211517,9211811,10610048,10610049,10610051,10125574,10125842,10512577,9210937,2809653,9211271,8918096,8918097,9209104,9198970,9207295,9207296,9183308,10628162,7001366,10631206,10187807,10187808,10187809,10187810,10187811,10631623,10631624,10626808,10626809,10626810,10626811,10588700,10588701,10423614,10423615,10423616,10423617,10423618,10423619,10423620,10423621,10423622,10423623,10423624,10423625,10423626,10495500,10495501,10495502,10495503,10495504,10495505,10495506,10495507,10495508,10495509,10495510,10495511,10495512,10495513,10495514,10495515,10495516,10495517,10495518,10495519,10495520,10495521,10495522,10495523,10495524,10495525,10495526,10495527,10495528,10495529,10495530,10495531,10495532,10495533,10495534,10495535,10495536,10495537,10495538,10495539,10495540,10495541,10495542,10495543,10495544,10495545,10495546,10495547,10495548,10495549,10495550,10495551,10495552,10495553,10495554,10495555) 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'