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(8067423,10872232,10872233,10872234,10872235,10872236,10872237,10872238,10872239,10872240,10872241,10872242,10845413,10845414,10845415,10845416,10103762,10103763,10103764,10103765,10843637,8618798,8618799,8618800,8618801,8618802,8618803,8618804,8618805,8618806,8618807,8618808,8618809,8618810,5654797,5654798,8910794,8910795,8910796,8910797,8910798,8910799,3235500,3235501,3235502,3235503,3235504,3235505,3235506,3235507,3235508,3235509,11010608,11010609,11010610,11010611,11010612,11010613,3234538,3234909,3234944,8576391,10952180,10952181,10565350,10565351,10565352,10565353,10565354,10565355,10565356,10565357,10565358,10565359,10565360,10565361,10565362,10565363,10565364,10565365,10565366,10565367,10565368,10565369,10565370,10565371,10565372,10565373,10565374,10565375,10565376,10565377,10565378,10565379,10565380,10565381,10565382,10565383,10565384,10565385,10565386,10565387,10565388,10565389,10565390,10565391,10565392,10565393,10565394,10565395,10565396,10565397,10565398,10565399,10565400,10565401,10565402,10565403,10565404,10565405,10565406,10565407,10565408,10565409,10565410,10565411,10565412,10565413,10565414,10565415,10565416,10565417,10565418,10565419,10565420,10565421,10565422,10565423,10565424,10565425,10565426,10565427,10565428,10565429,10565430,10565431,10565432,10565433,10565434,10565435,10565436,10565437,10565438,10565439,10565440,10565441,10565442,10565443,10565444,10565445,10565446,10565447,10565448,10565449,10565450,10565451,10565452,10565453,10565454,10565455,10565456,10565457,10565458,10565459,10565460,10565461,10565462,10565463,10565464,10565465,10565466,10565467,10565468,10565469,10565470,10565471,10565472,10565473,10565474,10565475,10565476,10565477,10565478,10565479,10565480,10565481,10565482,10565483,10565484,10565485,10565486,10565487,10565488,10565489,10565490,10565491,10565492,10565493,10565494,10565495,10565496,10565497,10565498,10565499,10565500,10565501,10565502,10565503,10565504,10565505,10565506,10565507,10565508,10565509,10565510,10565511,10565512,10565513,10565514,10565515,10565516,10565517,10565518,10565519,10565520,10565521,10565522,10565523,10565524,10565525,10565526,10565527,10565528,10565529,10565530,10565531,10565532,10565533,10565534,10565535,10565536,10565537,10565538,10565539,10565540,10565541,10565542,10565543,10565544,10565545,10565546,10565547,10565548,10565549,10565550,10565551,10565552,10565553,10565554,10565555,10565556,10565557,10565558,10565559,10565560,10565561,10565562,10565563,10565564,10565565,10565566,10565567,10565568,10565569,10565570,10565571,10565572,10565573,10565574,10565575,10565576,10565577,10565578,10565579,10565580,10565581,10565582,10565583,10565584,10565585,10565586,10565587,10565588,10565589,10565590,10565591,10565592,10565593,10565594,10565595,10565596,10565597,10565598,10565599,10565600,10565601,10565602,10565603,10565604,10565605,10565606,10565607,10565608,10565609,10565610,10565611,10565612,10565613,10565614,10565615,10565616,10565617,10565618,10565619,10565620,10565621,10565622,10565623,10565624,10565625,10565626,10565627,10565628,10565629,10565630,10565631,10565632,10565633,10565634,10565635,10565636,10565637,10565638,10565639,10565640,10565641,10565642,10565643,10565644,10565645,10565646,10565647,10565648,10565649,10565650,10565651,10565652,10565653,10565654,10565655,10565656,10565657,10565658,10565659,10565660,10565661,10565662,10565663,10565664,10565665,10565666,10565667,10565668,10565669,10565670,10565671,10565672,10565673,10565674,10565675,10565676,10565677,10565678,10565679,10565680,10565681,10565682,10565683,10565684,10565685,10565686,10565687,10565688,10565689,10565690,10565691,10565692,10565693,10565694,10565695,10565696,10565697,10565698,10565699,10565700,10565701,10565702,10565703,10565704,10565705,10565706,9198998,9198999,9199000,9199001,9199002,9199003,9199004,9199005,9199006,9199007,9199008,9199009,9199010,9199011,9199012,9199013,9199014,9199015,9199016,8854894,8854895,10628831,10628832,10911850,10911851,10911852,10911853,10911854,10911855,10911856,10911857,10911858,10911859,10911860,10911861,10589528,10589529,10547734,10547757,10547758,10547759,10547760,10547761,10547762,10547763,10547764,10547777,10547778,10547779,10547780,10547781,10547792,10547875,10547877,10547878,10547879,10547880,10547881,10547882,10547883,10547884,10547885,10547886,10547887,10547888,10547889,10547890,10547891,10547892,10547898,10547899,10547900,10547901,10547905,10547906,10547907,10547908,10547909,10547912,10547915,10547916,10547917,10547918,10547919,10547920,10547921,10548026,10548027,10548028,10548029,10548030,10548031,10548032,10548033,10548040,10548041,10548049,10548050,10548051,10548052,10548053,10548064,10548068,10548069,10548070,10546449,10423411,10423412,10423413,10508019,10493045) 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>