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(10861156,10962563,7067887,10861347,10861348,10861394,10861478,10861479,10848687,10848688,3229101,10862167,8575080,8575081,8575084,10862253,10950748,7066141,8583683,10862543,10862582,10862583,10862718,10862719,10862731,10862732,3229967,10862892,10860300,8573268,10860459,10860484,10860753,10959549,10959550,10866195,10866210,10866211,10866212,10866218,10866220,10866221,7201383,10866453,10866506,10103438,10866620,10866628,10866643,10866655,10866660,10866663,7201622,10866666,10858789,10866789,10866790,10866791,10858794,8911575,8911578,8911579,8911580,10866912,10866918,7201928,10858975,10859175,10859410,10859411,10859424,10859801,10859802,10859808,10859819,10859828,10859829,10859840,10859850,10860033,3227190,7200148,10865235,8616850,7200340,10102359,10857684,10857685,10865786,10865787,10959260,10857894,7201001,10858080,10863265,7198347,7198348,7198486,10855751,8625173,8625174,8625175,7199054,7199070,10864115,10864238,10856343,10856344,10856345,10856346,7199317,10856367,7199329,10856371,10856372,10856373,10856375,10856377,10856378,10856379,10856383,10856384,10856387,10856390,10856393,10856396,10856397,10856405,10856409,10856410,10856411,10856412,10856417,10856418,10856421,10856422,10856425,10856426,10856427,10856429,10856430,10856432,10856435,10856436,10856438,10856439,10856441,10856444,10856445,10856446,10856447,10856450,10856451,10856452,10856454,10856455,10856456,10856457,10856459,10856460,10856462,10856467,10856473,10856474,10856478,10856479,10856481,10856487,8626059,8860360,7199814,10856925,10865056,8905952,8905965,10853265,10853266,10853267,10853268,10853274,10853282,10853283,10853284,10853285,10853286,10853355,3923497,10967808,10967809,10967810,10967811,10967812,10618292,10618299,10618302,10618304,10853468,7196479,7196574,10853889,8906871,10854244,10838970,7197893,8907722,8904989,10617150,10617379,10953951,8905401,10617509,3922816,8905734,8905802,8905804,8905854,10614970,10614974,10614991,10615037,8632548,8632549,10615078,10615079,10850223,10850225,10850230,10850234,10850254,10620119,10850266,10850271,10850272,10850290,10850296,10850305,10850307,10850308,10850311,10850312,10850318,10850323,10850330,10850333,10850336,10850340,10850342,10850343,10850347,10850350,10850355,10850360,10850365,10615351,11043201,10850814,10615674,10615675,10850886,10850887,8633251,10850895,10850896,10850905,10850910,10850918,10850923,10850927,10850929,10850936,10850941,10615819,8633339,10851172,10616034,10616048,8540602,10616595,10616726,10616902,8634438,10614142,10611151,10611152,10611153,10611154,10611156,10611158,10611161,10611162,10611163,10614175,10614237,10614436,10611445,10122076,10614600,10611696,10611718,10614719,10611864,10614867,10614893,10614936,10609034,10609072,10612093,10609349,10609357,10609364,10612433,8851704,10612850,10612852,10612854,10612856,10609858,10609910,10612912,10613019,10613055,8852398,10610271,10613350,10613526,10613719,10610773,10613932,7055502,9911558,9911559,9169372,10117575,9169402,10117679,7055649,10515320,10515321,10117716,10117717,8849352,10117724,10117727,10117728,10117731,10117812,9169668,10125985,9169805,9912025,10118037,10118045,8849705,9912090,9912092,9912096,6674172,9912192,10118302,9912355,9912356,8849992,9912404,9912408,10118679,9912724,8850381,8850382,8850383,9912882,8850548,8850549,8850555,8850577,8850587,9913051,9913052,9913053,9913054,9913055,9913056,9913057,9913058,9913059,9913155,9913288,9913365,10419304,10415312,10415313,10419319,10419320,10419321,10416321,10416322,10419328,10416328,10419330,10419331,10415339,10418341,6672647,10415387,10419398,10419427,10419450,10416460,9168563,10419505,10419516,10419528,6672815,6672816,10419532,6672817,6672818,6672819,10419535,6672820,6672821,6672822,6672823,6672824,6672825,10418542,6672826,6672827,6672828,10417570,6672921,6672935,6672936,10419653,10419654,10419655,10419792,10419798,6673093,6673101,6673104,10415873,10415887,6673181,6673187,10418914,10117317,9169159,10416182,6673494,6673497,10469149,6670854,10467260,10469340,10469342,8549927,10469458,8550185,8847334,976353,976354,10468258,10115982,10116236,10468668,10468669,9168154,10427649,10888710,10888820,10174934,10883951,10884014,10889074,10889107,10889125,10884206,10884214,10884216,10884219,10884258,10884313,10884371,10884459,10884476,10889476,10884486,10884513,10884515,10884584,10889618,10884780,10170920,10170922,10884947,10890024,10885077,10875131,10885174,10885206,10885214,10885296,10885297,10885302,10885303,10885380,10885396,10877480,10877481,10877489,10877490,10887576,10882617,10887913,10882924,10887949,10882954,10882955,10882971,10882975,10908034,10883172,10627749,10627775,10883381,10883407,10888463,10885511,10161841,10885983,10886040,10162083,10886099,10886110,10886131,10886188,10886197,10162236,10886228,10886236,10886237,10886247,10886270,10886316,10886378,10886429,10886440,10881488,10881491,10886564,10886567,10886596,10886636,10886690,10626193,10886705,10886733,10886734,10886806,10876808,10886914,10886951,10886970,10886974,10887032,10882083,10887129,10887130,10882234,10602145,10602158,10608545,10644449,10647506,10647542,10647561,10647562,10647579,10647660,10603653,10603654,10603655,10604522,10607611,10607612,10607613,10601680,10601681,10521565,10546486,10546487,10546488,10546491,10546492,10546493,10546494,10546495,10546542,10546543,10546544,10546545,10546546,10546547,10546548,10538842,10538849,10507962,10413351,10413355,10411394,10411395,10411413,10411418,10411419,10411420,10411422,10411423,10411425,10411427,10411428,10411431,10411433,10411436,10411439,10411440,10411445,10411450,10411451,10409451,10411452,10409452,10409453,10411456,10411457,10411460,10411461,10409461,10411464,10411465,10411467,10411469,10409469,10409470,10411471,10409471,10409472,10411473,10409473,10411474,10409474,10411475,10409475,10411477,10413477,10411479,10411482,10411484,10411485,10411488,10411489,10411491,10411493,10411494,10411495,10411496,10411498,10411499,10411501,10411506,10411510,10411511,10411514,10411515,10411517,10411518,10411520,10411525,10407584,10407586,10407591,10407595,10407603,10409609,10409610,10407617,10407629,10407630,10407635,10407654,10407657,10413659,10407663,10407674,10407676,10407677,10407680,10407681,10407687,10407698,10407701,10407703,10407707,10407710,10407714,10407717,10407722,10407727,10407733,10411819,10413873,10413874,10413883,10413890,10410008,10408086,10408087,10408094,10408102,10408107,10408114,10408117,10408122,10408127,10408134,10408140,10408200,10414221,10414234,10414242,10414255,10414264,10414426,10412477,10414643,10414741,10406953,10406954,10406955,10411186) 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'