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(10861448,10861671,10848694,10861759,10861760,8631143,3229017,3229018,3229059,3229060,3229061,3229062,3229063,3229064,10862004,10862005,10862012,3229175,7065945,8631630,8631635,7066044,7066077,7066078,10950726,7066210,10849561,10849592,10862815,10862818,10849869,8609702,10929252,8067903,8067938,10869339,8573230,8573239,8573240,10860387,10939392,8630469,10861164,10861170,10861183,10861195,10861201,7201202,7201204,7201211,7201267,10858325,3238537,3238538,7201375,7201400,10866487,7201452,7201605,10866652,7201611,10866653,10866654,10866655,10866656,10866657,10866658,10866659,10866660,10866661,10866662,10866663,10866664,10866665,10866666,10866667,10866668,7201631,8595043,7201664,10866727,10858832,7201940,7201941,7201942,7201943,7201944,7201945,7201946,7201947,7201948,7201949,7201960,7201964,7201970,7201971,7201972,7201973,7201974,8065838,10859174,7202145,7202160,7202180,7202182,7202222,7202256,7202266,7202270,10859710,10859721,7202687,10859731,7202740,10860152,10857226,10857227,10865245,10857284,7200348,7200353,7200357,8626840,8626953,10857645,7200626,10857679,7200646,7200647,7200649,7200650,8627052,8627053,8627057,8627058,8627059,7200659,8627060,8627061,7200665,7200675,7200676,7200680,7200683,7200684,7200685,7200689,7200691,7200695,7200700,10865751,10865752,7200714,8627116,8627117,8627119,10865802,10865803,10865811,10865828,8910679,8910680,8910764,7201007,7201008,8627447,10855495,10855626,8908418,8908419,8908420,8908426,8908427,8908429,8908430,8908431,8908432,8908433,8908435,8908436,8908437,8908438,8908439,7198680,7198686,7198695,7198696,7198698,7198700,7198701,7198702,7198707,7198710,7198715,10855757,10855758,10855759,10855760,7198722,7198736,7198738,7198751,7198752,7198757,7198758,7198759,7198760,7198762,7198764,7198769,10864039,10864040,10864041,10864042,10864043,10864044,10864045,10864046,10864047,10864048,10864049,10864050,10864051,10864052,10856137,7199138,10864315,10864316,10864317,10864393,10864394,10864408,10856552,10856687,10856688,11048308,10856704,8626085,8626086,10856730,10856731,10856732,10864741,11048435,8626239,8626240,8626241,8626242,10857123,8626502,8626503,8626504,10865184,7200172,7196217,3923406,10853328,10853329,10853333,7196301,7196302,3923492,3923493,10618180,3923584,10853555,10853576,10853601,10853605,10853607,10853611,7196591,7196624,10623499,8906788,7196981,8906892,10968547,8906934,8906935,8906937,7197282,7197616,7197617,7197618,7197620,7197623,7197624,10839143,7197652,7197655,7197656,7197658,7197659,7197665,8907606,3235061,3235075,3235077,3235078,7197982,8624428,10855124,10855126,10852260,10852262,10852272,10852286,10617031,10852371,10617136,10617145,10617146,10617148,10617149,10617155,10617156,10617157,8905365,3922823,10617461,3922861,10617497,10617498,3232893,3922876,10617514,10617515,8905731,8905827,8905895,8632623,8632624,8632627,8632629,10615046,10425394,10425575,10425582,10615268,10615334,10615483,10615530,10615539,10425932,10425934,10425939,10615725,10615741,10615751,10615753,10615754,8633402,10426202,10426203,10615984,8610858,8610859,8540604,8540605,8904213,8904217,10426628,8904335,8904342,10616655,10616656,10616657,10851974,10851980,10852015,10852017,10852018,10852021,10616763,8904798,8904822,10616860,10616870,10616871,10852190,10852194,10852204,10852206,10852210,10852222,8853185,8853193,8853258,8853259,8853261,8853262,8853265,8853266,8853269,8853270,8853271,8853273,8853274,8853275,8853276,8853277,8853278,8853280,8853281,8853284,10611126,8853290,8853291,10611170,10614176,9165540,10614296,10614299,6669902,10614633,10614635,10614636,10611971,10611972,10611974,10611975,10611976,10611977,10611978,10611983,10611998,10612002,10612010,10612035,10612036,10612075,10612076,10612079,8851261,10612280,10609352,10609357,10609359,10609388,8851662,8851663,8851664,8851665,8851666,8851667,8851668,8851669,8851670,8851677,8851689,10609663,8566724,10612909,10612915,7017914,7017915,7017940,7017949,7017960,7017969,10612987,10612988,10612989,7017980,10612994,7017989,10610058,10613083,10613149,10613160,10613168,10613196,10613204,10613206,10613213,10613216,10613225,10613246,10613260,10610269,10613369,10610484,10610487,10610488,10610491,8852701,8852706,8852707,10610671,10610692,10610731,10610736,10610737,10610738,10610951,6673555,7055533,9911721,9911722,10117730,9911792,6673805,6673832,6673845,6673846,6673860,10117862,6673911,6673920,6673942,6673944,6673945,6673953,6673955,6673956,6673961,6673962,6674014,6674017,6674020,6674057,6674059,6674060,6674064,6674066,9912091,9912095,9169899,9169900,8849782,8849783,6674173,6674174,6674186,9912212,9912259,6674311,8849930,6674312,6674318,6674319,6674333,6674334,9912387,10118402,10118420,9912432,8850057,9912475,9912492,10118611,10118613,9178477,10118679,9912738,9912739,8850513,9912899,9912970,9912980,9913171,9913365,9913366,9168368,10416377,10416380,10417429,10417430,10417431,10417432,10417433,10417434,10417435,10417436,10417437,10417438,10417439,6672724,10417440,10417441,10417442,10116725,10418498,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10415544,10419598,6672886,10415612,9168763,10417712,10417713,9168844,10415785,9168863,10415786,9168869,8848743,6673131,6673135,6673136,8848768,10418963,10418964,9911271,10418048,10117472,10468902,10471069,10469150,8549784,6670851,6670852,10471257,10471258,10471270,10471271,10471272,10469280,8549971,10469515,8550096,10469518,10469575,10467892,10467893,8847278,9167502,9167641,8847479,8847486,8847497,8847505,8847538,976499,8847579,10468447,9167954,9167991,8848011,8848012,10468766,10468780,8848039,8848040,10427636,10468841,10468848,10154576,10888592,10888818,10888819,10888904,10889023,10884048,10889055,10889056,10884224,10884239,10628847,10889490,10884699,10884700,10884701,10879919,10889988,10875310,10885312,10887956,10883327,10883331,10883430,10883461,10888462,10885479,10885480,10885570,10885594,10162030,10949013,10162253,10162279,10881503,10876602,10897240,10602168,10602584,10602600,10608812,10608813,10608814,10647326,10647395,10647448,10647536,10606983,10606984,10606985,10606986,10606987,10606988,10606989,10607427,10607448,10607454,10607501,10604504,10604518,10601710,10601711,10601951,10522618,10498369,10498370,10421546,10508451,10508452,10508482,10508593,10508599,10507626,10508700,10508769,10508771,10508773,10507795,10508806,10508807,10508809,10508810,10508811,10411252,10407370,10409495,10409496,10409499,10411649,10411650,10411651,10494378,10494379,10411957,10412047,10414142,10414155,10414167,10412255,10412278,10496948,10496949,10496950,10496951,10496952,10496953,10496954,10410327,10414538,10408651,10408657,10410662,10408684,10408685,10408686,10408688,10414689,10410788,10408829,10412859,10410916,10410917,10410952,10406961,10407144,10407146,10415163) 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'