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(10939873,8575079,8066992,7066268,7066269,8583895,8583896,8583897,10951392,7066993,10929633,10929634,10929635,10939206,10845357,10845358,7067625,10985765,10985766,10985767,10985768,10985769,10985770,10985771,10985772,10985773,10985774,10985775,10985776,10985777,10985778,10985779,10985780,10985781,10985782,10985783,10985784,10985785,10985786,10985787,10985788,10985789,10985790,10985791,10985792,10985793,10985794,10985795,10985796,10985797,10985798,10985799,10985800,10985801,10985802,10985803,10985804,10985805,10985806,10985807,10985808,10985809,10985810,10985811,10985812,10985813,10985814,10985815,10985816,10985817,10985818,10985819,10985820,10985821,10985822,10985823,10985824,10985825,10985826,10985827,10985828,10985829,10985830,10985831,10985832,10985833,10985834,10985835,10985836,10985837,10985838,10985839,10985840,10985841,10985842,10985843,10985844,10985845,10985846,10985847,10985848,10985849,10985850,10985851,10985852,10985853,7072211,7072212,7072213,7201708,7201709,7201710,7201711,8835993,10960353,8911754,10999465,10999466,10999467,8836542,10960840,10960841,10960842,10960843,10960844,10104359,8572533,8572579,8572583,8572584,8834832,8834833,10842182,10842275,10842276,10842277,10842278,10842279,10842280,10842281,10842282,10842283,10842284,10842285,10842286,10842351,10842354,10842360,8835164,8835165,8835166,8835167,8835168,8835169,8835170,10944518,10944519,10940942,10940943,10940944,10940945,10940946,10940947,10940948,10940949,10940950,10940951,10940952,10940953,10940954,10940955,10940956,10940957,8908410,8908411,8908412,8908413,8908414,8908415,8908416,8908417,8908418,8908419,8908420,8908421,8908422,8908423,8908424,8908425,8908426,8908427,8908428,8908429,8908430,8908431,8908432,8908433,8908434,8908435,8908436,8908437,8908438,8908439,8908440,8908441,8908442,8908443,8908444,8908445,8908446,8908447,8908448,8908449,8908450,7069586,7069587,7069588,7069589,7069590,10840614,10840624,10840625,10840626,8615715,10996702,8564851,8564852,10101322,8616142,10101496,10958373,10101891,11048751,10101999,10622962,10622963,10622964,10622965,10622966,10622967,10622968,10622969,10622970,10622971,10622972,10622973,10622974,10622975,10622976,10622977,10622978,10622979,10622980,10622981,10622982,10622983,10622984,10622985,10622986,10622987,10622988,10622989,10622990,10622991,10622992,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623000,10623001,10623002,10623003,10623004,10623005,10623006,10623007,10623008,10623009,10623010,10623011,10623012,10623013,10623014,10623015,10623016,10623017,10623018,10623019,10623020,10623021,10623022,10623023,10623024,10623025,10623026,10623027,10623028,10623029,10623030,10623031,10623032,10623033,10623034,10623035,10623036,10623037,10623038,10623039,10623040,10623041,10623042,10623043,10623044,10623045,10623046,10623047,10623048,10623049,10623050,10623051,10623052,10623053,10623054,10623055,10623095,10618204,10994378,10838644,8907075,10838784,8614504,8614505,8614506,8614507,8614508,8614509,8614510,8614511,8614512,8614513,8614514,3232542,10836900,8612481,10622877,10622878,10622879,10622880,10622881,10622882,10622883,10622884,10622885,10622886,10622887,10622888,10622889,10622890,10622891,10622892,10622893,10622894,10622895,10622896,10622897,10622898,10622899,10622900,10622901,10622902,10622903,10622904,10622905,10622906,10622907,10622908,10622909,10622910,10622911,10622912,10622913,10622914,8612724,10622915,10622916,10622917,10622918,10622919,10622920,10622921,10622922,10622923,10622924,10622925,10622926,10622927,10622928,10622929,10622930,10622931,10622932,10622933,10622934,10622935,10622936,10622937,10622938,10622939,10622940,10622941,10622942,10622943,10622944,10622945,10622946,10622947,10622948,10622949,10622950,10622951,10622952,10622953,10622954,10622955,10622956,10622957,10622958,10622959,10622960,10622961,10951718,8570313,10615552,10930714,10965527,10965528,10965529,10965530,10965531,10965532,10965533,10965534,10965535,10965536,10965537,10965538,10922087,10922088,10922089,10922090,10922091,10922092,10922093,10922094,8541213,8541214,8541215,9189835,10611758,9166273,10119600,10612230,9212047,8862943,6676769,6676770,6676771,6676772,6676773,6676774,6676775,6676776,6676777,6676778,6676779,6676780,6676781,6676782,6676783,6676784,6676785,6676786,6676787,6676788,6676789,6676790,6676791,6676792,6676793,6676794,6676795,6676796,6676797,6676798,6676799,6676800,6676801,6676802,6676803,6676804,6676805,6676806,6676807,6676808,6676809,6676810,6676811,6676812,6676813,6676814,6676815,6676816,6676817,6676818,6676819,6676820,6676821,6676822,6676823,6676824,6676825,6676826,6676827,6676828,6676829,6676830,6676831,6676832,6676833,6676834,6676835,6676836,6676837,6676838,6676839,6676840,6676841,6676842,6676843,6676844,6676845,6676846,6676847,6676848,6676849,6676850,6676851,6676852,6676853,6676854,6676855,6676856,6676857,6676858,6676859,6676860,6676861,6676862,6676863,10120919,10120920,10120921,10120922,10120923,10120924,10120925,10120926,10120927,10120928,10120929,10120930,10120931,7026492,7026493,8863766,8863775,10515307,9185793,7056057,7056058,10513728,10513729,7057157,7057158,9160570,9160574,9160575,9160602,9160664,9160665,7054914,9160922,9161010,9161017,9161018,9161019,9161020,9161042,9161043,9161044,9161051,9161052,7055443,9166377,9166439,9166449,9166450,9166451,10123110,10123111,9182936,9182937,9182938,9182939,9182940,9182941,9182942,9182943,9182944,9182945,9182946,9182947,9182948,9182949,9182950,9182951,9182952,9182953,9182954,9182955,9182956,9182957,9182958,9182959,9182960,9182961,9182962,9182963,9182964,9182965,9182966,9182967,9182968,9182969,9182970,9182971,9182972,9182973,9182974,9182975,9182976,9182977,9182978,9182979,9182980,9182981,9182982,9182983,9182984,9182985,9182986,9182987,9182988,9182989,9182990,9182991,9182992,9182993,9182994,9182995,9182996,9182997,9182998,9182999,9183000,9183001,9191107,3963464,9175192,9175193,10123613,8550574,4972547,4972548,4972549,4972550,4972551,4972552,4972553,4972554,8917348,4972555,4972556,9191843,10628745,10628746,10628768,10628769,10628770,10628771,10628784,10628785,8069046,10170894,10170895,10170896,10170897,10170898,10170899,10170900,10170901,10170902,10170903,10170904,10170905,10170906,10170907,10170908,10170909,10170910,10170911,10170912,10170913,10627143,10627144,10632244,10163771,10627320,10161865,10626105,10949513,10631882,10626951,10626952,10539203,10521648,10534381,10526902,10526903,10526904,10526905,10526906,10526907,10526908,10526909,10526910,10526911,10526912,10526913,10526914,10526915,10526916,10526917,10526918,10526919,10526920,10526921,10526922,10526923,10526924,10526925,10526926,10526927,10526928,10526929,10526930,10526931,10526932,10526933,10526934,10526935,10526936,10526937,10526938,10526939,10526940,10526941,10526942,10526943,10526944,10526945,10526946,10526947,10526948,10526949,10526950,10526951,10526952,10526953,10526954,10526955,10526956,10526957,10526958,10526959,10526960,10526961,10526962,10526963,10526964,10526965,10526966,10526967,10526968,10526969,10526970,10526971,10526972,10526973,10526974,10526975,10526976,10526977,10526978,10526979,10526980,10526981,10526982,10526983,10526984,10526985,10526986,10526987,10526988,10526989,10526990,10526991,10526992,10526993,10526994,10526995,10526996,10526997,10526998,10526999,10421371,10421372,10421373,10421374,10421375,10421376,10421377,10421378,10421379,10421380,10421381,10421382,10421383,10421384,10421385,10421386,10421387,10421388,10421389,10421390,10422411,10422412,10422413,10422414,10422415,10422416,10422417,10422418,10422419,10422420,10422421,10422422,10422423,10422424,10422425,10422426,10422427,10422428,10422429,10422430,10422431,10422432,10422433,10422434,10422435,10422436,10422437,10422438,10422439,10422440,10422441,10422442,10422443,10422444,10422445,10422446,10422447,10422448,10424949,10424950,10424951,10424952,10424953,10424954,10424955,10424956,10424957,10424958,10498867,10477733,10477734,10477735,10477736,10477737,10477738,10477739,10477740,10477741,10477742,10477743,10477744,10477745,10477746,10477747,10477748,10477749,10477750,10477751,10477752,10477753,10477754,10477755,10477756,10477757,10477758,10477759,10477760,10477761,10477762,10477763,10477764,10477765,10477766,10477767,10477768,10477769,10477770,10477771,10477772,10477773,10477774,10477775,10477776,10477777,10477778,10477779,10477780,10477781,10477782,10477783,10477784,10477785,10477786,10477787,10477788,10477789,10477790,10477791,10477792,10477793,10477794,10477795,10477796,10477797,10477798,10477799,10477800,10477801,10477802,10477803,10477804,10477805,10477806,10477807,10477808,10477809,10477810,10477811,10477812,10477813,10477814,10477815,10477816,10477817,10477818,10477819,10477820,10477821,10477822,10482562,10482563) 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'