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(8911776,8911784,8911785,8569792,10497559,10497725,10497726,10497727,8591179,8591327,8591328,8591329,10497943,10497944,10497945,8591387,10497946,10497947,10497948,10498020,8591469,8591470,8591471,8591472,10929538,10929539,8067964,8067965,8067966,8067967,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068265,8068301,8068329,8068330,8068331,8068332,8068333,8068334,8068406,8068631,8835663,8835708,8068703,8068766,10102394,10102402,8907788,8907789,8908051,8555962,8556067,10868562,7068961,7068970,8613545,8613585,8613637,8613641,8613642,3924400,3924401,3924432,3924512,10216193,10216194,10216195,10216196,10216197,10216198,10216199,10216200,10216201,3581968,3581998,3581999,3582022,10216686,10216687,10216688,10216689,10216690,10216691,10216692,10216693,10216694,10216695,10426438,8611004,10426673,10426674,10426692,10426693,10426736,10426760,10426797,10426798,10426799,10426800,10426801,10426802,10426803,10426816,10426817,10426818,10426835,10426836,10426837,10426838,10426988,10427003,10217356,10217357,10217358,10217359,10217514,10217515,10217516,10217517,10217606,7155616,7155617,10217873,8583831,10215073,10215074,10215075,10621977,10215253,10432195,10432235,8609570,10215515,10215516,10215517,10215518,10215519,10215520,10215521,10215522,10215882,10498215,10498216,8591798,8591823,8574347,10213930,8574432,8574433,8574434,8574435,8574436,8574437,8574529,8574542,8574564,8574565,8574566,8574648,8574649,8574650,8574651,8574652,10621149,10621152,8574756,8574757,8574783,9215269,9215270,8574805,8574806,8574807,10621244,10621245,10621246,8574822,10214378,10214379,10214380,10214381,10214382,10621337,10621338,10621339,10621386,10621387,10621388,10214695,10214696,10214697,10214698,10214699,10214700,10214701,10214702,10214703,10214704,10214705,10214706,10214707,10214708,10214709,10214710,10214711,10214712,10214713,10214714,10214715,10214716,10214717,10214718,10214719,10214720,10214721,10214722,10214723,10214724,10214725,10214726,10214727,10214728,10214729,10214730,10214731,10621664,10621665,8583542,8583721,8583722,8853391,8853392,8853397,8853399,10940422,10940438,10940487,10940489,8066910,9179384,9179385,9179386,9179516,9179517,9179518,9179519,8851445,9179673,9179674,9179774,9179792,9179840,6676411,6676412,9914415,9914426,9914427,9914473,10120514,6676547,6676564,6676577,9914596,9914597,9914598,9914659,9914660,9914661,8567171,8567185,8567186,8567214,8567222,8863312,8863313,8863346,8863383,8863405,8863431,8863432,3654189,8863539,8863540,8863541,9169570,8592794,10126071,10126072,9178220,9178221,7056433,7056460,9178303,9178304,9178305,9178306,9178307,9178351,9178373,9178417,9178418,9178419,9178420,9178421,9178422,9178423,9178424,9178590,7056786,7056787,7056788,8066228,8066229,8066230,8066231,8066232,9178743,9178774,9178775,8066377,8066378,8066379,9178897,9178966,9178967,8066830,8066831,6673150,9911258,9911259,9911260,9911261,3963392,4971962,4971976,4972020,4972055,4972056,4972057,4972134,4972257,10466413,10466414,10466415,10466416,10466417,10466418,10466419,10466420,10466421,10466422,10466423,9168096,10898661,10898679,8593704,8593705,8593706,10898730,8593763,8593764,10898760,10898761,10898762,10898763,10898764,10898765,10898766,10898767,10898768,10898769,10898770,10898771,10898772,8593868,8593869,8594017,8594039,8594093,10889176,10889199,10889200,10889201,10889202,10889203,10889204,10897564,10897565,10897566,10897567,10897568,10897636,10897668,10897669,10897670,10897671,10897672,10897673,10897715,7000948,10897828,10897829,10898408,10658720,10658721,10896545,10896546,10896547,10896584,10896585,10658946,10896645,10896646,10896647,10896731,10896843,10896911,10896931,10897071,10897072,10897073,10646209,10646210,10649540,10649541,10649556,10649557,10649569,10649625,10649642,10649643,10649644,10649645,10649646,10649652,10649653,10649822,10649856,10649864,10523687,10523688,10479437,10479438,10479439,10479440,10479441,10479513,10479514,10479515,10479711,10479712,10479713,10479714,10479715,10479716,10479717,10479718,10479719,10479720,10479721,10479722,10479857,10479858,10479859,10479860,10479861,10479862,10479863,10497185,10497186,10480491,10480567) 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'