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(7068519,7068520,7068521,7068522,7068523,7202385,10874467,10874471,7202506,7202507,5654627,5654649,8629258,7066105,8629830,8561172,7067196,7198713,7198738,7198762,10855868,8908758,10869283,8616850,8907551,8907552,7197802,8624434,10246545,8624557,8624564,8555879,8555880,10868502,10868503,8624925,8634990,8634991,8634992,8634993,8634994,8634995,10231204,10231206,8612409,8612410,8905735,10283595,3923478,3923490,10866553,10866595,10866596,10866597,10866598,10866599,10866600,10866601,10853645,10866827,10838516,10838524,10838525,8554723,10838534,3924320,3924321,8860418,8860419,8860420,10838973,10863632,10863633,10863634,10863635,10863636,10863637,10863638,10863639,10863640,10863641,10863642,10863643,10863644,10863645,10863646,10863647,10863648,10863649,10863650,10850650,10863651,10863652,10863653,10863654,10863655,10863656,10863657,10863658,10863659,10863660,10863661,10863662,10863663,10863664,10863665,10863666,10863667,10863668,10863669,10863670,10863671,10863672,10863673,10863674,10863675,10863676,10863677,10863678,10863679,10863680,10863681,10863682,10863683,10863684,10863685,10863686,10863687,10863688,8633292,10229358,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10864066,8540566,8540567,3232079,3232080,3232081,3232082,3232083,3232084,3232085,3232086,8541212,8634500,8634501,8634502,8634503,8634648,8905252,8634966,8634967,8634968,8634969,8634970,8634971,8634972,8634973,8634974,8634975,8634976,8634977,8634978,8634979,8634980,8634981,8634982,8634983,8634984,8634985,8634986,8634987,8634988,8634989,10617322,10617361,8632575,8632591,8632592,10863529,10863536,10863546,10863547,10863548,10863549,10863550,10863551,10863552,10863553,10863554,10863555,10863556,10863557,10863558,10863559,10863560,10863561,10863562,10863563,10863564,10863565,10863566,10863567,10863568,10863569,10863570,10863571,10863572,10863573,10863574,10863575,10863576,10863577,10863578,10863579,10863580,10863581,10863582,10863583,10863584,10863585,10863586,10863587,10863588,10863589,10863590,10863591,10863592,10863593,10863594,10863595,10863596,10863597,10863598,10863599,10863600,10863601,10863602,10863603,10863604,10863605,10863606,10863607,10863608,10863609,10863610,10863611,10863612,10863613,10863614,10863615,10863616,10863617,10863618,10863619,10863620,10863621,10863622,10863623,10863624,10863625,10863626,10863627,10863628,10863629,10863630,10863631,10213107,10213108,10213109,10213110,10213111,10213112,10213113,10213114,10213115,10213116,10213117,10213118,10213119,10213120,10615229,10615329,10615330,10200651,10200652,8574308,8574309,8574310,10620920,10620921,10620922,10620923,10188379,10616329,10616332,10616333,10616475,10616655,10616888,8853208,8853230,8863986,6669823,9173728,9173729,9173730,10614497,10614498,10940297,10940298,10940299,10940300,9174069,10940301,10120212,10120213,10120214,10120215,9196457,9196461,6673523,6673529,6673538,10117529,6673540,9177571,9177572,9177573,9177574,9177575,9177576,9177577,9177578,9177579,9177580,9177581,9177582,9177583,9177584,9177585,9911864,9912193,6674222,7056334,9912438,9912457,8066177,9186776,991358,991359,8552308,9913360,8848127,8848128,8848130,10427755,10416362,10417443,10419480,10419481,10419482,10419483,10419484,10419693,8848739,8848856,10417063,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10417141,10417142,10417143,10417144,10417145,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,10417156,10417157,10417158,10417159,10417160,9190615,6670852,8550023,8550065,6666946,4971883,976358,976377,9207666,8847558,10468551,8848009,10884084,10910023,10896155,10896156,10896157,10896158,10896159,10896160,10896161,10896162,10896163,10896164,10896165,10896166,10896167,10896168,10896169,10896170,10896171,10896172,10896173,10896174,10896175,10886284,10626449,10887096,10887097,10892180,10892181,10892182,10887462,10650819,10650820,10582561,10649019,10649020,10649021,10601910,10421488,10507625,10508656,10421036,10425037,10421037,10425041,10479000,10479001,10479002,10479003,10479004,10409668,10496938,10496939,10496985,10478016,8563358,8563359,10497041,10493302,10412757,10411018) 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>