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(10861391,10861412,10861413,8631073,8631075,7066026,10862703,10862704,8067927,10860733,8630402,8630403,10858106,8627790,10858727,8628397,8628440,8628728,10859490,5654576,10859579,7202654,7202667,7200091,10865148,7200119,7200184,7200185,7200189,3237398,7200243,7200244,8626706,7200374,7200375,10865444,10865445,10865446,10865447,10865448,10865452,10865486,10865502,8834759,10865642,10865644,10865645,10857661,10865707,10865708,10865737,10865887,10857964,10857974,10858014,10858015,10858016,10858021,10858022,10858027,10858032,10858033,10858035,10858036,10858039,10858040,10858042,10858043,10858056,10858057,10858058,10858060,10858086,10858088,10858090,10858092,10858093,10858096,10858100,7198136,8624573,7198325,7198327,7198496,10855593,10855594,7198694,7198720,7198721,7198722,7198724,7198734,7198735,7198741,7198753,7198754,7198755,7198761,7198763,7199095,7199096,7199104,10856186,7199191,7199646,7199660,7199664,7199727,7199728,7199740,7199826,7199868,7199904,7199905,7199906,7199907,7199908,7199952,10865022,10853294,8554365,8906598,8906620,8906625,8906649,8906659,8906660,8906736,8906755,8906756,8906768,8906795,8906804,7197000,10838915,10838916,10838920,10838924,10838932,10838933,7197480,7197544,10854913,8624345,8624400,10855054,10855057,8907855,10622456,8632467,8632468,10615015,8609758,10615091,10425487,10425573,10425582,10425940,10425941,10426012,10426014,10615912,10615931,10426152,10616047,10616064,10616065,10616066,10616067,10616145,10616146,10616147,10616148,10426408,10616211,10616212,10616213,10616214,8540635,10616364,10616365,10616540,10616592,10616593,10616594,8611290,10616684,10616707,10616708,10616709,10616710,10616711,10616712,8634318,8634319,8634344,10610978,9165552,10614320,6669880,10714167,10614369,10614370,10614464,10614541,10611831,10614862,10609285,10612344,10612431,10612485,10612488,10612489,10612498,7017535,7017536,7017541,7017542,7017547,7017548,7017553,7017554,7017557,7017558,7017581,7017582,10612607,7017605,7017606,10612620,10612625,10612626,7017629,7017630,10612657,7017653,7017654,10612673,10612711,10612713,10612718,10612720,10612721,10612722,10609739,10612746,10612847,10612862,10612881,10612915,10609944,10609945,10612970,10609975,10609979,10613127,8852549,10610389,8852575,8852576,8852577,10610503,10610504,10610505,10610506,10613513,10613514,10613649,10613689,10613690,10613691,10613716,10613717,10613722,10613767,10613837,10613844,6673685,9169658,9169675,9169688,9169689,9169732,9169759,9169775,9169776,9169839,9169971,6674249,990554,990555,990564,10118522,10118533,8850183,9912751,9912947,9913195,9913248,9913251,9913252,9913295,6672576,10415353,10415354,10416393,6672720,6672722,6672723,10418462,10418734,10418735,10418736,10418737,10418775,10418871,10418872,8848782,6673163,8848785,6673166,10418953,9169107,10419037,10419057,10470877,10470878,10470890,10471012,10471054,10471124,10469525,8550165,8550238,9167540,976521,976539,976547,9183980,9168095,9168103,10470804,10470805,8848054,10470827,10888932,10888986,10884020,10884030,10884031,10884032,10884033,10884069,10889133,10889223,10889242,10889243,10889244,10889245,10889274,10889483,10889515,10889540,10889583,10889611,10889682,10889721,10889723,10889778,10889780,10889781,10879929,10889937,10885107,10887551,10877605,10877610,10877611,10882998,10888366,10888434,10161829,10885929,10885931,10885943,10162199,10647389,10647534,10647595,10647675,10508170,10508331,10508487,10508532,10508534,10413268,10411283,10413946,10414020,10410164,10412259,10410270,10714786,10412551,10412560,10412600,10412601,10412602,10412605,10412606,10412611,10412616,10412619,10412620,10412622,10412623,10412624,10412634,10412635,10412636,10412638,10412639,10412665,10412667,10412669,10412671,10412672,10412674,10412676,10412680,10412685,10410756,10410757,10410758,10414966) 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>