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(10962717,10845827,7068102,7068103,7068104,7068105,7068106,7068107,10940089,10940090,10940091,8574935,10868395,10868396,8067279,8067280,8067281,10951083,9216188,11042482,8560879,8560899,10844781,10929564,10930049,10998538,10998539,10998540,10998541,10998542,10998543,10998544,10998545,10998546,10998547,6000231,10103366,7201618,7201621,8595517,7065153,10844002,7202625,7202626,7202675,8629109,8629110,8629111,8629112,8629113,8629141,8629142,8629143,8629144,8629145,8629146,8629147,8629148,8629149,8629150,8629151,8629152,8629153,8629154,8629155,8629156,8629157,8629158,8629159,8629160,8629161,8629162,8629163,8629178,8629207,10844390,10865250,10857387,8558301,7200610,10102497,10865785,10865786,10865787,10865788,10865789,7200921,7200922,7200925,7200929,11011492,11011493,11011494,11011495,11011496,11011497,11011498,10944443,8908035,8908036,8908037,3925533,10840237,8625474,8625475,8625476,8625477,8625693,8625694,7199394,7199395,7199396,7199397,7199401,7199531,7199532,7199533,7199534,7199535,7199537,7199538,7199539,8557271,7070502,7070503,7070504,7070505,7070506,7070507,7070508,7070509,7070510,8557696,10837576,7156383,7156384,7196303,7196304,7196305,7196306,7196309,7196310,7196311,7196312,7196313,7196314,7196315,7196318,7196319,7196320,7196321,7196322,7196323,7196325,7196326,7196327,7196328,7196334,7196335,7196336,7196338,7196339,7196340,7196341,7196342,7196343,7196468,7196532,7196534,7196535,7196536,7196540,7196541,3923832,7197019,7197020,7197021,3234319,8613936,8613937,8555453,10982255,10982256,10982257,10982258,10982259,10982260,10982261,10982262,10982263,10982264,10982265,10982266,10982267,10982268,10982269,10982270,10982271,10982272,10982273,10982274,10982275,10982276,10982277,10982278,10982279,10982280,10982281,10982282,10982283,11005703,9216678,8570039,10964834,10964835,10848224,10620627,10620628,11043302,11043303,3231159,8864291,8864321,9173997,9173998,9173999,7057961,6676636,6676637,10120712,3653752,9180882,9180883,6677449,7055491,9193537,9193568,10517670,10514192,10514193,10514194,10514195,10514196,7057009,10418556,4973524,4973525,4973526,8549504,8549505,8549506,8549507,8549508,8865190,9190714,9190715,9191297,9191298,9191299,6667374,8917215,9199936,10888596,10908931,10889783,8069151,10171198,10171199,10171200,10171201,10171202,10171203,10895263,10895264,10895265,10895266,10895267,10895268,10895269,10895270,10895271,10895272,10895273,10907856,10627346,10627347,10627348,10164068,10885565,10173414,10173415,10173416,10173417,10173418,10173419,10173420,10173421,10173422,10173423,10173424,10653470,10651858,10652018,10543341,10545495,10545496,10545497,10545498,10545539,10545540,10545701,10552011,10552012,10552013,10552014,10552015,10552016,10552017,10552018,10552019,10552020,10552021,10552022,10552023,10552024,10552025,10552026,10552027,10552028,10552029,10507652,10507653,10420959,10420960,10482900,10482901,10482902,10482903,10482904,10482905,10482906,10482907,10482908,10482909,10482910,10482911,10482912,10482913,10482914,10482915,10482916,10482917,10482918,10482919,10482920,10482921,10482922,10482923,10482924,10482925,10482926,10482927,10482928,10482929,10482930,10482931,10482932,10482933,10482934,10482935,10482936,10482937,10482938,10482939,10482940,10482941,10482942,10482943,10482944,10482945,10482946,10482947,10482948,10482949,10482950,10482951,10482952,10482953,10482954,10482955,10482956,10482957,10482958,10482959,10482960,10482961,10482962,10482963,10482964,10482965,10482966,10482967,10482968,10482969,10482970,10482971,10482972,10482973,10482974,10482975,10482976,10482977,10482978,10482979,10482980,10482981,10482982,10482983,10482984,10482985,10482986,10482987,10482988,10482989,10482990,10482991,10482992,10482993,10482994,10496309,10477404,10477405,10477406,10477407,10477408,10477409,10477410,10477411,10477412,10477413,10477414,10477415,10477416,10477417,10477418,10477419,10477420,10477421,10477422,10477423,10477424,10477425,10477426,10477427,10477428,10477429,10477430,10477431,10477432,8562755,10477433,10477434,8562756,10477435,10477436,10477437,10477438,10480105,10480106,10487121,10476385,10476386,10476387,10476388,10476389,10476390,10476391,10476392,10476393) 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'