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(10861804,10861805,10861806,10861807,10861808,10963334,10963335,10963336,10963337,10963356,10963357,10963358,7065967,7066087,7066089,10437208,10862657,10862807,10868927,8632327,8632328,7066845,7066879,8067924,8067925,7066997,10860324,10860329,10860330,10860335,10860336,10860337,10860340,10860352,10860354,10860355,10860356,10860358,10860362,10860363,8629728,10860375,10860377,10860379,10860380,10860381,10860382,10860445,10860517,10860520,10860522,10860529,8573429,8573430,7201117,7201319,8594788,8627809,8627815,7072184,8595157,7201818,7201819,7201837,7201838,7202695,7202696,7202697,7202698,10104816,8626609,7200644,7200674,7200675,7200676,7200677,7200678,7200716,7200721,7200726,11034924,7198784,7198803,7198805,7198821,7198824,7198828,7069593,11035343,10864115,10856308,10856367,10856368,10856369,10856371,10856372,10856373,10856374,10856375,10856376,10856377,10856378,10856380,10856381,10856383,10856384,10856385,10856386,10856390,10856391,10856392,10856401,10856419,10856427,10856428,10856435,10856436,10856437,10856438,10856439,10856440,10856441,10856442,10856443,10856444,10856446,10856447,10856448,10856449,10856451,10856452,10856453,10856467,10856473,10856474,10856475,10856476,10856478,10856479,10856480,10101527,10101528,8860342,3923551,3923619,10623493,8906625,8554695,8554758,10854318,11044697,11044698,10917973,10917978,10917979,10917980,8905679,8905682,8905686,8905826,9216477,10615351,10615615,10850886,10850887,10850888,10850889,10850890,10850891,10850892,10850893,10850894,10850905,10850906,10850907,10850908,10850909,10850914,10850915,10850916,10850917,10850929,10850930,10850931,10850932,10850933,10850934,10850935,8633700,8633701,8633702,8633703,8633704,8633705,8633706,9217834,8633881,8633882,8633883,8633884,8633885,8633886,8633887,8633888,8633889,8633890,8633891,8633892,8633893,8633894,8540887,10616525,10616526,10616527,10616528,10616529,10616530,10616596,10616866,10611151,10611152,10611153,10611156,10611158,10611159,10611161,10611162,10611163,10614289,10614297,10122115,10614591,10565939,10612087,6675681,8851704,8851980,8851981,9172578,9172579,9172580,9172581,10558442,10558443,10558444,10558445,10558446,9172634,9172635,9172636,9172637,9172638,9172639,9172640,9172641,8852540,10613380,10613382,10613389,10613392,10613416,10613422,10613440,10613442,10613445,10613475,10613479,10613539,10613560,6673566,6673575,9911598,10117716,10117717,10117718,10117719,10117720,10117723,10117724,10117725,10118038,10118039,10118040,9912091,9912092,10118108,10118190,9912250,6674481,6674487,6674505,6674516,6674576,10118679,6674902,8850548,8850549,6675074,6675093,9913503,10416278,10416370,10415652,10415653,10415654,10415655,10415656,9168887,9168895,9168897,6681155,10469158,10469187,10469188,10469197,10469199,10469202,10469209,10469210,10469212,6670854,10469249,9174887,10469513,9199045,9199046,9199047,10469908,976426,976507,10468351,10116224,10116225,10116226,10116227,10116228,10116229,10116230,10116236,10427649,10427650,10893757,10888838,10884205,10884206,10884207,10884208,10884211,10884214,10884215,10884216,10884217,10884219,10884220,10170920,10885464,10885466,10885467,10877480,10877481,10877482,10877483,10877484,10877485,10877486,8593475,10630089,10630104,10885763,10885764,10885773,10885785,10885791,10885792,10885865,10885866,10891867,10887152,10887153,10649462,10649463,10522469,10522470,10522471,10524799,10551012,10551013,10551014,10421238,10411413,10411414,10411415,10411418,10411419,10411420,10411421,10411422,10411423,10411424,10411426,10411427,10411428,10411429,10411430,10411433,10411434,10411435,10411458,10411467,10411468,10411473,10411474,10411475,10411476,10411477,10411478,10411479,10411480,10411481,10411482,10411483,10411485,10411486,10411487,10411489,10411490,10411491,10411492,10411506,10411510,10411511,10411512,10411513,10411517,10411518,10411519,10410062,10408086,10408087,10408088,10408089,10408090,10408091,10408092,10408093,10408102,10408103,10408104,10408105,10408106,10408113,10408114,10408115,10408116,10408127,10408128,10408129,10408130,10408131,10408132,10408133,10495018,10476266,10414649,10414654,10414663,10414665,10414667,10414668,10414671,10414675,10414676,10414680,10414681,10414700,10414798,10414799,10414800,10414802,10414810) 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'