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(9214607,10848800,10848801,10848802,10848803,10848804,10848805,10848806,10848807,10848808,10848809,10848810,10848811,10848812,10848813,10848814,10848815,10848816,10848817,10848818,10848819,10848820,10848821,10848822,10848823,10848824,10848825,10848826,10848827,10848828,10848829,10848830,10848831,10848832,10848833,10848834,10848835,10848836,10848837,10848838,10848839,10848840,10848841,10848842,10848843,10848844,10848845,10848846,10848847,10848848,10848849,10848850,10848851,10848852,10848853,10848854,10848855,10848856,10848857,10848858,10848859,10848860,10848861,10848862,10848863,10848864,10848865,10848866,10848867,10848868,10848869,10848870,10848871,10848872,10848873,10848874,10848875,10848876,10848877,10848878,10848879,10848880,10848881,10848882,10848883,10848884,10848885,10848886,10848887,10848888,10848889,10848890,10848891,10848892,10848893,10848894,10848895,10848896,10848897,10848898,10848899,10848900,10848901,10848902,10848903,10848904,10848905,10848906,10848907,10848908,10848909,10848910,10848911,10848912,10848913,10848914,10848915,10848916,10848917,10848918,10848919,10848920,10848921,10848922,10848923,10848924,10848925,10848926,10848927,10848928,10848929,10848930,10848931,10848932,10848933,10848934,10848935,10848936,10848937,10848938,10848939,10848940,10848941,10848942,10848943,10848944,10848945,10848946,10848947,10848948,10848949,10848950,10848951,10848952,10848953,10848954,10848955,10848956,10848957,10848958,10842795,8595110,8595111,8595112,8595113,7198167,8624842,8624845,8624846,8624847,8624848,8624849,8624850,8624853,8624854,8624855,8624858,8624860,8624862,8624865,8624867,8624868,8624869,8624875,8624879,8906103,8906104,8906105,8906106,8906107,8906108,8906109,10967772,10837928,10838077,7197163,7157631,7157632,7157633,7157634,7157635,7157636,7157637,7157638,7157639,7157640,7157641,7157642,7157643,7157644,7157645,10954198,10847932,7154408,8540558,8540559,8904210,8904211,8904212,8904213,8904214,8904215,8904216,8904217,8904218,8904219,8904220,8904221,8904222,8904223,8904224,8904225,8904226,8904227,8904228,8904229,8904230,8904231,8904232,8904233,8904234,8904235,8904236,8904237,8904238,8904239,8904240,8904242,8904243,8904244,8904245,8904246,8904247,8904248,8904249,8904250,8904251,8904252,8904253,8904254,8904255,8904256,8904257,8904258,8904259,8904260,8904261,8904262,8904263,8904264,10613972,9189418,6669818,6669819,6669820,6669821,6669822,6669823,6669824,6669825,6669826,6669827,6669829,6669832,6669833,6669834,6669835,6669836,6669837,6669838,6669839,6669840,6669841,6669842,6669843,6669844,6669845,6669846,6669847,6669848,6669849,6669850,6669851,6669852,6669853,6669854,6669855,6669856,6669857,6669858,6669859,6669860,6669861,6669862,6669863,6669864,6669865,6669866,6669867,6669868,6669869,6669870,6669871,6669872,6669873,6669874,6669875,6669876,6669877,6669878,6669879,6669880,6669881,6669882,6669883,6669884,6669885,6669886,6669887,6669888,6669889,6669890,6669891,6669892,6669893,6669894,6669895,6669896,6669897,6669898,6669899,6669900,6669901,10609787,10610039,10613056,10558558,10558561,6673531,6673613,6673970,7023553,6674135,7015600,7015601,6674309,6674312,9162382,9162383,7016146,7016147,10512619,10512620,10512621,10512622,10512623,10512624,10512625,10512629,10512630,10512631,10512632,10512633,8850895,9192472,6672761,6672860,6672864,6672865,6672866,6672867,10417743,9209001,9209003,6673233,4974091,8549512,9182496,9175040,8847468,8847470,8847471,8847472,8847473,8847474,8847475,8847476,8847477,8847478,8847479,8847480,8847481,8847482,8847483,8847484,8847485,8847486,8847487,8847488,8847489,8847490,8847492,8847493,8847494,8847496,8847497,8847500,8847501,8847502,8847503,8847504,8847505,8847506,8847507,8847508,8847509,8847510,8847512,8847513,8847514,8847515,8847516,8847517,8847518,8847519,8847520,8847521,8847522,8847523,8847524,8847525,8847526,8847527,8847528,8847529,8847530,8847531,8847532,8847533,8847534,8847535,8847536,8847537,8847538,8847539,8847540,8847541,8847542,8847543,8847544,8847545,8847546,8847547,8847548,8847549,8847550,8847551,8847552,8847553,8847554,8847555,8847556,8847557,8847558,8847559,8847560,8847561,8847562,8847563,8847564,8847565,8847566,8847567,8847568,8847569,8847570,8847571,8847572,8847573,8847574,8847575,8847576,8847577,8847578,8847579,8847580,8847581,8847582,8847583,8847584,8847585,8847586,8847587,8847588,8847589,8847590,8847591,8847592,8847593,8847594,8847595,8847596,8847597,8847598,8847599,8847600,8847601,8847602,8847603,8847604,8847605,8847606,8847607,8847608,8847609,8847610,8847611,8847612,8847613,8847614,8847615,8847616,8847617,8847618,8847619,8847623,8847625,8847626,8847628,8847629,8847632,8847634,8847635,8847637,8847638,8847639,8847641,8847642,8847643,8847644,8847645,8847646,8847648,8847649,8847650,8847651,8847652,8847653,8847659,8847660,8847663,8847664,8847666,8847667,8847669,8847671,8847672,8847674,8847675,8847677,8847680,8847681,8847684,8847687,8847689,8847690,8847694,8847698,8847699,8847700,8847701,8847702,8847703,8847704,8847705,8847706,8847707,8847708,8847709,8847711,8847712,8847718,8847720,8847721,8847723,8847728,8847729,8847732,8847734,8847735,8847736,8847737,8847738,8847739,8847740,8847741,8847742,8847744,8847745,8847746,8847747,8847748,8847749,8847750,8847753,8847756,8847760,8847761,8847765,8847773,8847776,8847777,8847779,8847780,8847781,8847788,8847790,8847791,8847794,8847796,8847797,8847800,8847802,8847803,8847804,8847806,8847807,8847808,8847810,8847811,8847812,8847815,8847818,8847819,8847821,8847826,8847829,8847830,8847832,8847837,8847838,8847840,8847841,8847842,8847843,8847848,8847850,8847851,8847853,8847854,8847855,8847858,8847859,8847860,8847861,8847864,8847865,8847866,8847869,8847871,8847872,8847875,8847878,8847881,8847882,8847883,8847884,8847888,8847889,8847890,8847891,8847892,8847893,8847894,8847895,8847896,8847897,8847898,8847899,8847900,8847901,8847902,8847903,8847904,8847905,8847906,8847907,8847908,8847909,8847910,8847911,8847912,8847913,8847914,8847917,8847918,8847919,8847921,8847922,8847923,8847926,8847928,8847929,8847930,8847931,8847932,8847933,8847935,8847936,8847937,8847941,8847942,8847943,8847944,8847946,8847947,8847949,8847950,8847951,8847952,8847953,8847954,8847960,8847961,8847962,8847963,8847966,8847967,8847969,8847970,8847971,8847972,8847973,8847974,8847980,8847981,8847982,8847987,8847988,8847989,8847990,10883566,10883567,10888036,10888037,10888038,10888049,10888051,10888055,10888056,10888058,10888063,10888064,10888065,10888066,10630114,10182490,10182493,10182494,10182495,10187798,10568281,10577285,10577286,10643469,10602705,10644218,10601475,10601476,10601477,10601478,10601479,10601482,10601483,10601484,10601485,10601486,10601488,10601489,10601490,10601491,10601494,10601495,10601496,10601499,10601500,10601501,10601502,10601503,10601504,10601505,10601506,10601507,10601509,10601510,10601511,10601517,10601518,10601522,10601524,10601527,10601528,10601529,10601530,10601531,10601532,10601533,10601534,10601535,10601536,10601537,10601538,10601541,10601542,10601543,10601544,10601547,10601548,10601549,10601550,10601551,10601552,10601553,10601554,10601556,10601557,10601559,10601560,10601561,10601562,10601563,10601564,10601567,10601568,10601569,10601570,10601572,10601574,10601576,10601577,10601578,10601579,10601580,10601581,10601582,10601583,10601584,10601585,10601586,10601587,10601588,10601590,10601591,10601592,10601594,10601595,10601596,10601598,10601599,10601600,10601602,10601603,10601604,10601607,10601608,10601609,10601610,10601611,10601612,10601613,10601614,10601617,10601618,10601619,10601621,10601623,10601626,10601627,10601628,10601629,10601630,10601632,10601633,10601634,10601635,10601636,10601637,10601639,10601640,10601641,10601642,10601643,10601644,10601645,10601646,10601647,10601648,10601649,10601650,10601651,10601652,10601653,10601655,10601656,10601658,10601659,10601661,10601662,10601664,10601665,10601666,10601668,10601669,10601670,10601671,10601672,10601673,10601675,10601676,10601677,10601678,10601679,10601680,10601681,10601682,10601683,10601684,10601685,10601686,10601688,10601689,10601690,10601691,10601692,10601693,10601694,10601695,10601696,10601697,10601698,10601699,10601700,10601701,10601702,10601703,10601704,10601705,10601706,10601707,10601708,10601709,10601710,10601711,10601712,10601715,10601716,10601717,10601718,10601719,10601721,10601722,10586031,10521294,10538960,10538961,10538962,10538963,10538964,10538965,10538966,10538967,10496928,10496948,10496949,10496950,10496951,10496952,10496953,10496954,10410632) 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'