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(7065938,10950683,10939388,10939389,10939390,7201337,7201338,7202049,8628775,7202584,10855632,10855633,10855634,10855635,10855636,10855637,10855638,10855639,10855640,10855641,10855642,10855643,10855644,10855645,10855646,10855647,10855648,10855649,10855650,10855651,10855652,10855653,10855654,10855655,10855656,10855657,10855658,10855659,10855660,10855661,10855662,10855663,10855664,10855665,10855666,10855667,10855668,10855669,10855670,10855671,10855672,10855673,10855674,10855675,10855676,10855677,10855678,10855679,10855680,10855681,10855682,10855683,10855684,10855685,10855686,10855687,10855688,10855689,10855690,10855691,10855692,10855693,10855694,10855695,10855696,10855697,10855698,10855699,10855700,10855701,10855702,10855703,10855704,10855705,10855706,10855707,10855708,10855709,10855710,10855711,10855712,10855713,10855714,10855715,10855716,10855717,10855718,10855719,10855720,10855721,10855722,10855723,10855724,10855725,10855726,10855727,10855728,10855729,10855730,10855731,10855732,10855733,10855734,10855735,10855736,10855737,10855738,10855739,10855740,10855741,10855742,10855743,7198702,10855744,10855745,7198704,10855746,10855747,7197461,7197462,7197463,7197464,7197465,7197466,7197467,7197468,7197469,7197470,7197471,7197472,7197473,7197474,7197475,7197476,7197477,7197478,7197479,7197480,7197481,7197482,7197483,7197484,7197485,7197486,7197487,7197488,7197489,7197490,7197491,7197492,7197493,7197494,7197495,7197496,7197497,7197498,7197499,7197500,7197501,7197502,7197503,7197504,7197505,7197506,7197507,7197508,7197509,7197510,7197511,7197512,7197513,7197514,7197515,7197516,7197517,7197518,7197519,7197520,7197521,7197522,7197523,7197524,7197525,7197526,7197527,7197528,7197529,7197530,7197531,7197532,7197533,7197534,7197535,7197536,7197537,7197538,7197539,7197540,7197541,7197542,7197543,7197544,8905128,8905129,8905130,8905131,8905132,8905133,8905134,8905135,8905136,8905137,8905138,8905139,8905140,8905141,8905142,8905143,8905144,8905145,8905146,8905147,8905148,8905149,10617461,10617462,10616173,8611315,8611316,8862495,8862496,8566538,10610377,10610378,10610379,10610380,10610381,10610382,10610383,10610384,10610385,10610386,10610387,10610388,10610389,10610390,10610391,10610392,10610393,10610394,10610395,10610396,10610397,10610398,10610399,10610400,10610401,10610402,10610403,10610404,10610405,10610406,10610407,10610408,10610409,10610410,10610411,10610412,10610413,10610414,10610415,10610416,10610417,10610418,10610419,10610420,10610421,10610422,10610423,10610424,10610425,10610426,10610427,10117569,10117570,10117571,10117572,10117573,989983,989984,989985,9911978,9911979,9911980,8850184,8850185,8850186,8850187,8850188,8850189,8850190,8850191,8850192,8850193,8850194,8850195,8850196,8850197,8850198,8850199,8850200,8850201,8850202,8850203,8850204,8850205,8850206,8850207,8850208,8850209,8850210,8850211,8850212,8850213,8850214,8850215,8850216,9912669,7014095,7014096,7014097,7014098,7014099,7014100,7014101,7014102,7014103,7014104,7014105,7014106,7014107,7014108,7014109,7014110,7014111,7014112,7014113,7014114,7014115,7014116,7014117,7014118,7014119,7014120,7014121,7014122,7014123,7014124,7014125,7014126,7014127,7014128,7014129,7014130,7014131,7014132,7014133,7014134,7014135,7014136,7014137,7014138,7014139,7014140,7014141,7014142,7014143,7014144,7014145,7014146,7014147,7014148,7014149,7014150,7014151,7014152,7014153,7014154,7014155,7014156,7014157,7014158,7014159,7014160,7014161,7014162,7014163,7014164,7014165,7014166,7014167,7014168,7014169,7014170,7014171,7014172,7014173,7014174,7014175,7014176,7014177,7014178,6673071,9169288,8549967,8549968,8549969,10467822,10467823,10467824,10467825,10467826,10467827,10467828,10467829,10467830,10467831,10467832,10467833,10467834,10467835,10467836,10467837,10467838,10467839,10467840,10467841,10467842,10467843,10467844,10467845,10467846,10467847,10467848,10467849,10467850,10467851,10467852,10467853,10467854,10467855,10467856,10467857,10467858,10467859,10467860,10467861,10467862,10467863,9167913,9167979,9167980,9167981,10883472,10883462,10883463,10883464,10883465,10883466,10883467,10883468,10883469,10883470,10883471,10161849,10507618,10507619,10507620,10507621,10410795,10410796,10410797,10410798,10410799,10410800,10410801,10410802,10410803,10410804,10410805,10410806,10410807,10410808,10410809,10410810,10410811,10410812,10410813,10410814,10410815,10410816,10410817,10410818,10410819,10410820,10410821,10410822,10410823,10410824,10410825,10410826,10410827,10410828,10410829,10410830,10410831,10410832,10410833,10410834,10410835,10410836,10410837,10410838,10410839,10410840,10410841,10410842,10410843,10410844,10410845,10410846,10410847,10410848,10410849,10410850,10410851,10410852,10410853,10410854,10410855,10410856,10410857,10410858,10410859,10410860,10410861,10410862,10410863,10410864,10410865,10410866,10410867,10410868,10410869,10410870,10410871,10410872,10410873,10410874,10410875,10410876,10410877,10410878,10410879,10410880,10410881,10410882,10410883,10410884,10410885,10410886,10410887,10410888,10410889,10410890,10410891,10410892,10410893,10410894,10410895,10410896,10410897,10410898,10410899,10410900,10410901,10410902,10410903,10410904,10410905,10410906,10410907,10410908) 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'