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(11027620,11027621,7068366,10861780,10989334,10846410,10963359,10963360,10963361,10963362,9215545,10976651,10950773,10868435,7074265,10849836,10849844,8622473,8609571,8609573,3230158,10990548,10990549,10990550,10990551,10990552,10990553,10990554,8837463,8837464,8837465,8573254,10844850,10961945,10961948,10961950,10961951,10961952,10961953,10872755,8620614,11014592,11027614,11027615,11027616,11027617,11027618,11027619,7201193,8617792,8617793,8617794,8617795,8617796,8617797,8617798,8617799,8617800,8617801,8617802,8617803,8617804,8617805,8617806,8617807,8617808,8617809,8617810,8617811,8617812,8617813,8617814,8617815,8617816,8617817,8617818,10103271,8627915,8627916,11025145,11025146,11025147,11025148,11025149,11025150,11025151,11025152,11025153,11025154,11012545,11012546,11012547,11012548,11012549,11012550,10104002,10999628,10867281,7202558,7202559,11013029,11013030,7202712,7202729,7202730,10844424,10844425,10844426,10844427,10844428,10844429,10844435,3927334,11023676,7071677,8064733,8910890,8910891,7201153,3925444,11021841,11021842,11021843,11021844,10100313,8625001,3656318,3656319,3656320,3656321,3656322,3656323,3656324,3656325,3656326,3656370,3656371,8625485,10841237,10841238,8626178,10101758,3927023,3927036,11023362,10857004,7070789,11045759,11045760,11045761,11045762,10993779,10993780,10993781,11019819,11006878,11006879,11006880,11006881,11006882,11019971,11019972,11019973,11019974,10918928,7196677,11020234,8554551,10981856,7197432,10920181,10920182,10920183,10920184,10920185,10839680,10917526,10917527,11005777,11005905,10622306,10953989,10922903,10922904,10922905,10922906,10922907,10922908,10922909,10922910,10922911,10918038,10918039,11006263,11006264,11006265,11006266,11006267,8542132,8542133,11032490,11032491,11032492,11032493,11032494,11032495,11032496,10990623,8570035,10620123,8632752,10990791,8632753,8632754,10990793,10990794,10990795,10990796,10990797,11016834,11016835,10915752,10990997,10990998,10990999,10991000,10991001,10991002,10991003,10951971,11017063,11017064,11017065,11017066,11017067,11017068,11017069,11017070,11017071,11017072,11017073,11017074,11017075,11017076,11017077,11017078,11017079,10915933,10915934,10915935,10915936,10915937,10915938,10915939,10915940,10915941,10915942,10915943,10915944,10915945,10915946,10915947,10915948,10850770,10850771,10850774,10850775,3581876,10991258,10991282,10991283,10991284,10991285,10991286,10991291,10991292,10991297,10991298,3582160,11004857,8540815,10917100,10917101,10917102,10917103,10917172,10917173,10917174,10992332,10992333,10992334,10992335,10992336,10992337,10992338,10992339,3232074,10992340,3232075,10992341,10992342,10992343,10992344,10992345,10992346,10992347,10992356,10992360,10992361,10992362,10992363,8541231,9915819,6677945,10559622,6678336,10122354,9916376,9916377,8851328,8851548,10120077,10120078,7058377,9180240,9212336,7058801,9188850,9197097,9197098,9205201,8567717,9177311,4974199,4974200,9193347,4974201,9193348,9201630,4974485,9201633,4974486,9201689,9201690,9201691,9201692,9201693,9201694,8849787,8849788,9170030,9186060,9170064,9186064,9186068,9186069,9186071,9186072,9186073,9186075,9186077,6674434,9202289,7016008,7016009,10118649,10118662,7056823,9912966,7056930,9913152,9202963,9202964,9202965,9202966,9202967,9202968,9202969,9202970,9202971,8850802,8850852,8850985,6680606,4973434,10415630,10117379,10420108,9169264,9201292,9201293,9190807,9190808,9190811,9190816,8550315,6667451,10464247,6667692,6667727,9175972,6680303,6668180,9200298,10889217,10628829,10914482,10909946,10909947,10909948,10909949,10915111,10183959,10163995,10163996,10883130,10913336,10913386,10187598,10187680,10187681,10187682,10162836,10162839,10162840,10162841,10187958,10178068,10178223,10178224,10178225,10178226,10178227,10178228,10178229,10178230,10178231,10178232,10178233,10178234,10178235,10178236,10178237,10178238,10571471,10571472,10571473,10571474,10571475,10568685,10602739,10652949,10652950,10571926,10571927,10574950,10568953,10653074,10584365,10584366,10584367,10584368,10572645,10572646,10572647,10572648,10575850,10575851,10575852,10575853,10575854,10575855,10606885,10654106,10591456,10591457,10591458,10570653,10570654,10570655,10570656,10570657,10573800,10573801,10573802,10573803,10573804,10573805,10573806,10573807,10573808,10573809,10573810,10523235,10533369,10533370,10533371,10533372,10533373,10533374,10533375,10533376,10533377,10533378,10537768,10537769,10537770,10523984,10523985,10530694,10530695,10530696,10530699,10530700,10530701,10530702,10530705,10530707,10530708,10530750,10423693,10407344,10407352,10411860,10714809,10480438,10480446,10493626,10493639,10480866) 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>