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(8630939,8630943,10873798,3228941,3228942,10862036,10950681,10950682,8629685,10860794,10861004,10861005,10861006,10861007,10861008,10861009,10861010,10861014,10861017,10861018,10861021,10939386,10939387,10939409,8595016,8595017,8595018,8595019,8595020,8595021,8595023,8595024,8595032,8911578,8911579,8911580,8911581,10858993,10858994,10858995,7202187,10859667,10859668,10859670,10859672,10859674,10859675,10859676,10859678,10859776,10859781,10859788,10859791,10859795,8910253,10865647,7200938,7200939,10866136,10866137,10866139,7201102,7201104,7201105,7201135,7201144,7201147,7201148,7201173,10855528,10855529,10855531,10855532,10855533,10855534,10855535,10855536,10855537,10855538,10855539,10855540,10855541,10855542,10855543,10855544,10855545,10855546,10855547,10855548,10855550,10855551,10855552,10855553,10855554,10855555,10855556,10855557,10855558,10855559,10855560,10855561,10855562,10855563,10855564,10855565,10855566,10855567,10855569,10855570,10855571,10855572,10855573,10855574,10855575,10855576,10855577,10855578,10855579,10855580,10855581,10855582,7198681,7198690,7198746,10856913,3923425,3923426,3233612,8554290,10853777,10853783,10853784,10853785,10853791,10853836,10853885,10853915,10853917,10853923,10853927,10854104,10854111,10854114,10854115,10854116,10854122,10854204,10854232,10854240,10854241,10854245,7198162,7198163,8904993,10852288,8905114,8905115,8905116,8905117,8905280,8905281,8905283,8905284,8905286,8905287,8905288,8612185,3232859,10622536,8905783,8905784,8905785,8905786,8905787,10615769,10616049,10616654,10851996,10614078,10614079,10614080,10614081,10614082,10614083,10614084,10614087,10614088,10614090,10614091,10614092,10614093,10614094,10614095,10614734,10611799,10612085,10609239,10609408,10609412,10609415,10609419,10609463,10609568,10609569,10609609,8851775,10609614,10609636,10609700,10609701,8852024,8852025,8852026,8852027,8852028,8852029,8852032,8852033,8852034,8852035,8852036,8852038,10612886,10612888,10610348,10610349,10610350,10610678,6673511,9911617,9911654,9911658,9911682,9911685,9911687,9911689,9911690,9911707,10117921,10117923,10117929,7015406,7015407,7015408,7015409,7015410,7015411,7015412,7015413,7015414,7015415,7015416,7015417,7015418,7015419,7015420,9911973,7015421,9911974,7015422,7015423,7015424,7015425,7015426,7015427,7015428,7015429,7015430,7015431,7015432,7015433,7015434,7015435,7015436,7015437,7015438,7015439,7015440,7015441,7015442,7015443,7015444,7015445,7015446,7015447,7015448,7015449,7015450,7015451,7015452,7015453,7015454,7015455,7015456,7015457,7015458,7015459,7015460,7015461,7015462,7015463,7015464,7015465,7015466,7015467,7015468,7015469,7015470,7015471,7015472,7015473,7015474,7015475,7015476,7015477,7015478,7015479,7015480,7015481,7015482,7015483,7015484,7015485,7015486,7015487,7015488,7015489,7015490,7015491,7015492,7015493,7015494,7015495,7015496,7015497,7015510,7015511,7015512,7015513,7015542,7015543,7015544,7015545,7015572,7015573,7015586,7015587,7015588,7015589,10118156,7015618,7015619,7015620,7015621,7015646,7015647,7015648,7015649,7015650,7015651,7015652,7015653,7015654,7015655,8850178,8850179,8850180,8850181,8850182,9912663,9912664,9912665,9912666,9912667,9913005,9913006,8552159,10419257,6672814,9168748,9168749,10415789,10418874,6673167,6673287,6673288,6673289,6673290,6673291,9169097,9169098,9169100,10416076,10416113,10416118,10117446,8549904,10469389,10469390,10469391,10469394,10469395,8550055,10467487,10467523,976412,976414,976421,976422,976423,9167691,9167692,976481,8848027,10883585,10883586,10889498,10884605,10882473,10882474,10882475,10882483,10882522,10882523,10882563,10882942,10883443,10883444,10161814,10161848,10949011,10886881,10886882,10886883,10886884,10886885,10886887,10886894,10886895,10886896,10886897,10886899,10886900,10886901,10886902,10886903,10886904,10886905,10886906,10887078,10882447,10882448,10882453,10602160,10602163,10602167,10602175,10602177,10602180,10602252,10647320,10647321,10647322,10647390,10647391,10647578,10424427,10508603,10413496,10413497,10413498,10486247,10486248,10486249,10486251,10486252,10486253,10486254,10409761,10409767,10409792,10409793,10409969,10409970,10409995,10410005,10414097,10414098,10414099,10414100,10414101,10414102,10414104,10414105,10414106,10414108,10414201,10414206,10414211,10414214,10414217,10410694,10410695,10410696,10410697,10410698,10410699,10410700,10410701,10410702,10410703,10410704,10410705,10410706,10410707,10410708,10410709,10410710,10410711,10410712,10410714,10410715,10410716,10410717,10410718,10410719,10410720,10410721,10410722,10410723,10410724,10410725,10410726,10410727,10410728,10410729,10410730,10410731,10410733,10410734,10410735,10410736,10410737,10410738,10410739,10410740,10410741,10410742,10410743,10410744,10410745,10410746,10408832,10412859,10414883,10414980,10415033,10415034,10415035,10415036,10415037,10415038,10415039,10415040,10415045,10415048,10415049,10415052,10407118,10415169,10415179,10415198) 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
ERROR: Unknown column 'p.products_specials' in 'order clause'