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(8574304,8574305,8574306,8574307,8574308,8574309,8574310,10939780,10939781,10939782,11015144,11015145,11015148,7068514,7068515,7068516,7068517,7068518,7068519,7068520,7068521,7068522,7068523,10848868,10940294,10940295,10940296,10940297,10940298,10940299,10940300,10940301,8569686,10849164,10976616,10976617,10976618,10976619,10976620,10976621,10976622,10976623,10976624,10976625,10976626,10976627,10976628,10976629,10976630,10976631,10976632,10976633,10976634,10976635,10976636,10976637,8583618,8583619,8583620,10868500,10868501,10868502,10868503,8067781,8837457,8837458,11013719,11013720,8067947,10938733,10929393,11013979,7067352,7067353,7067354,7067355,7067356,8573539,10988304,11027368,11027542,11027544,11027545,11027546,11027547,11027548,11027549,11014553,11014554,11024842,11024843,11024844,11024845,11024846,11024847,10843022,11025068,11025069,11025070,11025071,11025072,11025074,11025075,11025076,11025077,11025078,11025079,11025080,8911498,3899162,8595425,8595426,8595427,11012520,11012523,11012524,11012525,11012526,11012527,8066025,8066026,8066027,8066028,8066029,8066030,8066031,8066177,11012962,11012963,11012964,11013017,11013018,11013019,11013020,11013021,11013022,8619282,9794597,10867937,10867938,10867939,8837162,8837163,8837422,8835069,8835070,11021793,11021794,8615026,8615027,8624925,10840332,10840333,10840334,10840335,10840336,10840337,10840338,10840339,10840340,10840341,10840342,10840343,3236037,3236038,3236039,3236040,3236041,3236042,3236043,3236044,8564725,8564726,11048612,11006659,7156987,3923992,3923993,7157174,7157175,7157176,7157177,7157178,7157179,7157180,7157181,7157182,7157183,7157184,7157185,7157186,7157187,7157188,7157189,7157190,10919291,10919292,3924318,3924319,3924320,3924321,8555064,8555065,8555066,8555067,8907328,10619478,10619479,10619480,8907549,8907550,8907551,8907552,8555876,8555877,8555878,8555879,8555880,10917507,11018882,11018883,11018884,11018965,11018966,11018968,11006251,8612526,8612527,8612528,8612529,8612530,8612531,8612532,11006420,11019453,11019470,11019471,11032474,11032475,9216679,10964761,10964762,10964763,10964764,10964765,10964766,10964767,10964768,10964769,11016770,10964770,11016771,10964771,11016772,10964772,11016773,10964773,11016774,10964774,11016775,10964775,11016776,10964776,11016777,10964777,11016778,10964778,10964779,11016779,11016780,10964780,11016781,10964781,11016782,10964782,11016783,10964783,11016784,10964784,11016785,10964785,11016786,10964786,10964787,11016787,11016788,10964788,11016789,10964789,10964790,10964791,10964792,10964793,10964794,10964795,10964796,10964797,10964798,10964799,10964800,10964801,10964802,10964803,10964804,11029825,10615190,11017010,11017011,11017012,11017013,11017014,11017015,11017016,11017017,10915870,10915871,11017019,11017020,10915872,11017021,10915873,11017022,11017023,11004143,11004190,11004191,11004333,10930676,11004547,10620905,10620906,10620907,10620908,10620909,10620910,10620911,10620912,10620913,10620914,10620915,10620916,10620917,10620918,10620919,10620920,10620921,10620922,10620923,11004844,11030971,11005246,11005283,11005284,11005285,11005554,11005574,7155450,7155451,7155452,7155453,7155454,7155455,7155456,7155457,6677652,9915809,9915810,9915858,9916109,6678326,6678327,9916355,9916371,6675558,9913573,9913574,9913575,9913576,9913577,9913578,9913579,9913580,8542803,10120207,10120208,10120209,10120210,10120211,10120212,10120213,10120214,10120215,8862883,8566950,8566951,3653769,3653770,3653771,3653772,3653773,8567152,8567153,8853036,4974334,9177559,9177560,9177561,9177562,9177563,9177564,9177565,9177566,9177567,9177568,9177569,9177570,9177571,9177572,9177573,9177574,9177575,9177576,9177577,9177578,9177579,9177580,9177581,9177582,9177583,9177584,9177585,8592733,9201608,9201609,4974462,9201610,9201611,9201612,4974479,7055983,7055984,7055985,7055986,7055987,7056334,9202262,6674611,6674612,6674613,6674614,6674615,6674616,6674617,6674618,6674619,6674620,6674621,6674622,8552243,8552244,8552308,7057302,10119459,10119460,10427762,10427763,10427764,10427765,10427766,10427767,10427768,9184791,9184792,9201278,9201279,4971183,4971184,4971185,4971186,4971187,9174402,9174403,9174404,9174405,9174406,9174407,9174408,9174409,9174410,9174411,9174412,9174413,9174414,9174415,9174416,9174417,9174418,9174419,9174420,9174421,9174422,9174423,9174424,9174425,9174426,9174427,9174428,9174429,9174430,9174431,9174432,9174433,9174434,6678873,6666794,6665176,6665177,6665178,6665179,6665180,6666946,3963345,4971881,3963346,4971882,3963347,4971883,3963348,6679579,8847767,8847771,976023,8593506,8593507,8593508,10903668,10914800,10914801,10914802,10914803,10629516,10156043,10156044,10156045,10156046,10156047,10156048,10156049,10156050,10156051,10156052,10156053,10156054,10156055,10156056,10166324,10163561,10163562,10163563,10163564,10163565,10163566,10163567,10163568,10163569,10163570,10163571,10163572,10163573,10163574,10163575,10163576,10163577,10163578,10163579,10163580,10892756,10892757,10892758,10892759,10892760,10892761,10892762,10892763,10892764,10892765,10892766,10892767,10892768,10892769,10892770,10892771,10892772,10892773,10892774,10892775,10892776,10627577,10627578,10888103,10888104,10181677,10896134,10896135,10896136,10896137,10896138,10896139,10896140,10896141,10896142,10896143,10896144,10896145,10896146,10896147,10896148,10896149,10896150,10896151,10896152,10896153,10896154,10896155,10896156,10896157,10896158,10896159,10896160,10896161,10896162,10896163,10896164,10896165,10896166,10896167,10896168,10896169,10896170,10896171,10896172,10896173,10896174,10896175,10949060,10949061,10187952,10187953,10187954,10178041,10178042,10178178,10178179,10902370,10652205,10571844,10571845,10571899,10571900,10571901,10571902,10571903,10571904,10644782,10644783,10644784,10644785,10644786,10644787,10587733,10587734,10587735,10587736,10587737,10587738,10587739,10654161,10654162,10654163,10648532,10648533,10648534,10648535,10648536,10648537,10648538,10648539,10648540,10648541,10648542,10648543,10648544,10648545,10648546,10649007,10649008,10649009,10649010,10649011,10649012,10649013,10649014,10649015,10649016,10649017,10649018,10649019,10649020,10649021,10601078,10601079,10571096,10529133,10519613,10519614,10519615,10519616,10519617,10519618,10519619,10519620,10519621,10519622,10519623,10519624,10519625,10519626,10519627,10519628,10519629,10519630,10519631,10519632,10519633,10519634,10519635,10519636,10519637,10519638,10519639,10519640,10519641,10519642,10519643,10519644,10519645,10519646,10519647,10528198,10528199,10528201,10528202,10528203,10528204,10528205,10528206,10528207,10528209,10521062,10521063,10521064,10521065,10521066,10521067,10521068,10521069,10521070,10420610,10420611,10508656,10508663,10508664,10508665,10421035,10421036,10421037,10478995,10478996,10478997,10478998,10478999,10479000,10479001,10479002,10479003,10479004,10714818,10714819,10493636,10493637,10493638,10493641,10476720,10476721,10476722,10476723,10476724,10476725,10476726,10476727,10476728,10476729,10476730,10476731,10476732,10476733,10476734,10476735,10476736,10476737,10476738,10476739,10476740,10476741,10476742,10476743,10476744,10476745,10476746,10476747,10476748) 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<br>
ERROR: Unknown column 'p.products_specials' in 'order clause'<br>