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(10848640,10848641,10848642,10848643,10848644,10848647,10848648,10848649,10848650,10848651,10848652,10848655,10848656,10848657,10848658,10848659,3228918,8631617,8631680,8631681,8631682,8631683,8631684,8631687,8631688,8631689,8631690,8631822,8631823,8631860,8630457,8630459,8630460,8630461,8630462,8630464,8630466,8630468,8630514,8630515,8630516,8630517,8630518,8630519,8630520,8630535,8630536,8630537,8630538,8630539,8630540,8630541,8630542,8630543,8630544,8630545,8630546,8630547,8630548,8630549,8630550,8630551,8630552,8630553,8630554,8630555,8630556,8630557,8630558,8630559,8630560,8630561,8630562,8630563,8630564,8630565,8630566,8630567,8630568,8630569,8630570,8630571,8630572,8630573,8630574,8630575,8630576,8630577,8630578,8594724,8594725,8594726,8594935,10858771,8628751,7202614,7202615,7202616,8629434,8629436,8629437,8627223,8627224,8627225,8627226,8627227,8627228,8627229,8627230,8627231,8627232,8627233,8627234,8627235,8627236,8627237,8627238,8627239,8627240,8627241,8627242,8627243,8627255,8627256,8627257,8627262,8627263,8627264,8627265,8627266,8627267,8627268,8627269,8627270,8627271,8627272,8627273,8627274,8627275,8627276,8627277,8627278,8627279,8627280,8627281,8627282,8627283,8627284,8627285,8627286,8627287,8627288,8627289,8627295,8627296,8627299,8627300,8627301,8627303,8627304,8627305,8627306,8627307,8627308,8627309,8627310,8627312,8627313,10856768,10856769,8624451,8624453,8624454,8624456,8624458,8634738,8634739,8634740,8634741,8634742,8634748,8634749,8634750,8634751,8634752,8634753,8634754,8634755,8634756,8634757,8634758,8634759,8634760,8634761,8634762,8634763,8905384,10853070,10853071,10853072,10853073,10850225,10850226,10850227,10850228,10850229,10850230,10850231,10850232,10850233,10850234,10850235,10850236,10850237,10850238,10850239,10850240,10850241,10850242,10850243,10850244,10850245,10850246,10850247,10850248,10850249,10850250,10850251,10850252,10850253,10850254,10850255,10850256,10850257,10850258,10850259,10850260,10850261,10850262,10850263,10850264,10850265,10850266,10850267,10850268,10850269,10850270,10850271,10850272,10850273,10850274,10850275,10850276,10850277,10850278,10850279,10850280,10850281,10850282,10850283,10850284,10850285,10850286,10850287,10850288,10850289,10850290,10850291,10850292,10850293,10850294,10850295,10850296,10850297,10850298,10850299,10850300,10850301,10850302,10850303,10850304,10850305,10850306,10850307,10850308,10850309,10850310,10850311,10850312,10850313,10850314,10850315,10850316,10850317,10850318,10850319,10850320,10850321,10850322,10850323,10850324,10850325,10850326,10850327,10850328,10850329,10850330,10850331,10850332,10850333,10850334,10850335,10850336,10850337,10850338,10850339,10850340,10850341,10850342,10850343,10850344,10850345,10850346,10850347,10850348,10850349,10850350,10850351,10850352,10850353,10850354,10850355,10850356,10850357,10850358,10850359,10850360,10850361,10850362,10850363,10850364,10850365,10614450,8849365,6674268,8849944,8849945,8849946,8849947,8849948,8849949,8849950,8849951,8849952,9913190,9910791,9910792,9161147,6670687,10471176,10471177,10471178,10471179,10471180,10471181,10471182,10471183,10471184,10471185,10471186,10471187,10471188,10471189,9166804,10115982,10115983,10115984,10115985,10115986,10115987,10115988,10115989,10115990,10115991,10115992,10115993,6672490,6672491,10170918,10170919,10874990,10876480,10876481,10608488,10608489,10608490,10409307,10409308,10409309,10409310,8562380,10407586,10407587,10407588,10407589,10407590,10407591,10407592,10407593,10407594,10407595,10407596,10407597,10407598,10407599,10407600,10407601,10407602,10407603,10407604,10407605,10407606,10407607,10407608,10407609,10407610,10407611,10407612,10407613,10407614,10407615,10407616,10407617,10407618,10407619,10407620,10407621,10407622,10407623,10407624,10407625,10407626,10407627,10407628,10407629,10407630,10407631,10407632,10407633,10407634,10407635,10407636,10407637,10407638,10407639,10407640,10407641,10407642,10407643,10407644,10407645,10407646,10407647,10407648,10407649,10407650,10407651,10407652,10407653,10407654,10407655,10407656,10407657,10407658,10407659,10407660,10407661,10407662,10407663,10407664,10407665,10407666,10407667,10407668,10407669,10407670,10407671,10407672,10407673,10407674,10407675,10407676,10407677,10407678,10407679,10407680,10407681,10407682,10407683,10407684,10407685,10411686,10407686,10411687,10407687,10407688,10407689,10407690,10407691,10407692,10407693,10407694,10407695,10407696,10407697,10407698,10407699,10407700,10407701,10407702,10407703,10407704,10407705,10407706,10407707,10407708,10407709,10407710,10407711,10407712,10407713,10407714,10407715,10407716,10407717,10407718,10407719,10407720,10407721,10407722,10407723,10407724,10407725,10407726,10407727,10407728,10407729,10407730,10407731,10407732,10407733,10406901,10406902,10406903,10406904,10406905,10406908,10406909,10406910,10406911,10406912,10406913,10406914,10406917,10406919,10406920,10406921,10406922,10482602,10482603) 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'