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(10939826,10846111,9215018,10846127,7068876,7074061,7074109,7074110,7074111,7074112,7074113,7074114,7074117,7074118,7074119,7074120,7074121,7074122,7074123,7074125,7074126,7074128,7074129,7074136,7074153,7074171,10437283,10437302,10437303,11042554,8619781,8573288,8620116,8620117,8620118,8620119,8620120,8620121,8620122,8620123,8620124,8620125,8620126,8620127,8620128,8620129,8620130,8620131,8620132,8620133,8620134,8620135,10872621,10872622,10872623,10872624,10872625,10872626,10872627,10872628,10872629,8620334,8838043,8838044,8838045,10845338,8838080,8838082,10929923,10929928,10929932,11001356,8838186,8838187,8838193,10861051,7071987,10931482,8618284,8595203,8559511,8595261,10843487,8628899,8628900,8628901,8628902,8628903,8628904,8628905,8628906,8628907,8619251,5654811,10102699,10857902,4430407,4430421,4430422,4430435,4430466,4430469,4430470,4430498,11034650,11034651,11034652,11034653,11034654,11034655,11034656,11034657,11034658,11034659,11034660,11034661,11034662,11034663,11034664,11034665,7198489,10995962,3656259,8615549,8615552,11035427,11035659,11035660,11035661,11035662,11035721,11035722,11035734,11035821,11035822,11035823,7070278,8557379,8557390,3927141,3927151,3927152,8073514,8073515,8073516,10618182,10618219,3924183,10623944,8614691,11047547,8553484,8905807,8542281,8610338,10615852,10615858,10921388,10921389,10921390,10921391,10921392,10921393,10921394,10921395,10921396,10921397,10921398,10921399,10921400,10921401,10921402,10921403,10921404,10921405,10921406,10921407,10921408,10921409,10921410,10921411,10921412,10921413,10921414,10921415,10921416,10921417,10921418,10921419,10921420,10921421,10921422,10921423,10921424,10921425,10921426,10921427,10921428,10921429,10921430,10921431,10921432,10921433,10921434,10921435,10921436,10921437,10921438,10921439,10921440,10921441,10921442,10921443,10921444,10921445,10921446,10921447,10921448,10921449,10921450,10921451,10921452,10921453,10921454,10921455,10921456,10921457,10921458,10921459,10921460,10921461,10921462,10921463,10921464,10921465,10921466,10921467,10921468,10921469,10921737,10921738,10921747,10921755,10921756,10921757,10921758,10921784,10921806,10921841,10921842,10921845,10921846,10921847,10921848,10921849,10921850,10921952,10921953,10921954,8853169,8853170,8853172,8853173,8853174,8853175,8853176,8853184,8853207,8853208,8853209,8853210,8853211,8853212,8853213,8853214,8853215,8853217,8853219,8853220,8853221,8853222,8853223,8853224,8853228,8853229,8853230,8853231,3654614,8853232,8853233,8853234,8853235,8853236,8853237,8853238,8853239,8853240,8853241,8853242,10562407,6669917,10560509,10560511,10560517,9204190,9204191,9204192,9204193,9204194,9204195,9204196,9204197,9204198,9204199,9204200,9204201,9204202,9204203,9204204,9204205,9220199,9220200,10120437,10613074,9204535,9204545,9204575,9204584,9204585,9204634,9204637,9204638,9204685,9188735,10564557,10610408,10564598,9188801,9188802,10564654,10564671,10564766,10558853,10610721,10610946,10610947,10515261,10513403,990024,990033,7023538,7023539,7023540,7023541,7023542,10126215,10126223,8552213,10512806,10512807,10518815,8848141,10124517,8848150,8848159,8848178,8848187,8848193,8848203,8848205,10427992,9168718,8848784,8848800,8848832,8848879,8848880,10428499,9169137,9169138,9169139,9169140,9916832,9916833,10469473,9207292,9207293,9183586,8847489,10470484,10470547,10470548,8847996,8848025,8848029,8848047,8848050,8848060,8848087,8848094,8848095,8848096,8848106,10884035,10884036,10884037,10884038,10884039,10629881,10629914,10629915,10629916,10629917,10629938,10629957,10629958,10629959,10629960,10629961,10902561,10183604,10183605,10183606,10183607,10183608,10183609,10183610,10183646,10183720,10183746,10183783,10183806,10183822,10183830,10183837,10183838,10183839,10878029,10629962,10629989,10629990,10629991,10905502,10161724,10171817,10625325,10625326,10625327,10911481,10172533,10172647,10172689,10631249,10182965,10182966,10182967,10182968,10182969,10182970,10182971,10182972,10182973,10182974,10182975,10182976,10182977,10182978,10182979,10182980,10182981,10182982,10182983,10182984,10182985,10182986,10182987,10182988,10182989,10182990,10182991,10182992,10182993,10182994,10182995,10182996,10182997,10182998,10182999,10183000,10183001,10183002,10183003,10183004,10183005,10183006,10183007,10183008,10183009,10183010,10183011,10183012,10183013,10183014,10183015,10183016,10183017,10183018,10183019,10183020,10183021,10183022,10183023,10183024,10183025,10183026,10183027,10183028,10183029,10183030,10183031,10183032,10183033,10183034,10183035,10183036,10183037,10887025,10183038,10183039,10183040,10183041,10183042,10183043,10183044,10183045,10183046,10183047,10183048,10887199,10887200,10887201,10626756,10626781,10602125,10602189,10602192,10602196,10602230,10574788,10574789,10653191,10653192,10572195,10578239,10578240,10578241,10578242,10578243,10578244,10578245,10578246,10578247,10578248,10578249,10578250,10578251,10578252,10578253,10578254,10578255,10578256,10578257,10578258,10578259,10578260,10578261,10578262,10578263,10578264,10578265,10578266,10578267,10578268,10578269,10578270,10578271,10578272,10578273,10578274,10578275,10578276,10578277,10578278,10578279,10578280,10578281,10578282,10578521,10578523,10578537,10569665,10575763,10575764,10572867,10572868,10572869,10572870,10578926,10578928,10578929,10578933,10578953,10578954,10578955,10578956,10579050,10579077,10579078,10579080,10579086,10579089,10579090,10579091,10579092,10579093,10579094,10579095,10579096,10579100,10579167,10579168,10579179,10579189,10579195,10579196,10579197,10579198,10579199,10579200,10579201,10579203,10579204,10579209,10579217,10579218,10579298,10579371,10579382,10579433,10570974,10570975,10519274,10519602,10537621,10537623,10537634,10537635,10529667,10529673,10529679,10529680,10529681,10529691,10529692,10529693,10529695,10537696,10537698,10537702,10537707,10537709,10537748,10537749,10538271,10532888,10523025,10523026,10423270,10424310,10504268,10423382,10423388,10504333,10504358,10423606,10423607,10423608,10506580,10494217,10494218,10494219,10494277,10494317,10483617,10412486,10485305,10415064) 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'