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(8574347,8574432,8574433,8574434,8574435,8574436,8574437,8574529,8574542,8574564,8574565,8574566,8574648,8574649,8574650,8574651,8574652,8574756,8574757,8574783,9215269,9215270,8574805,8574806,8574807,8574822,10940422,10940438,8569792,10940487,10940489,8583542,8583721,8583722,10868562,8583831,10951256,10977342,10951296,8609570,8591179,8067964,8067965,8067966,8067967,8591327,8591328,8591329,10497943,10497944,8591387,10497945,10497946,10497947,10497948,10498020,8591469,8591470,8591471,8591472,10929538,10929539,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068265,8068301,10498215,10498216,8068329,8068330,8068331,8068332,8068333,8068334,8068406,8591798,8591823,8068631,8068703,8068766,8835663,8835708,8911776,8911784,8911785,8066228,8066229,8066230,8066231,8066232,8066377,8066378,8066379,10497559,8066830,8066831,10497725,10497726,10497727,8066910,10102394,10102402,7068961,7068970,8908051,8555962,8556067,10980822,10980823,10980824,10980825,10980986,10980987,10980988,10980989,10980990,10981087,10981353,8613545,8613585,8613637,8613641,8613642,3924400,3924401,3924432,3924512,8907788,8907789,10621977,7155616,7155617,10980108,10980109,10980110,10980111,10980112,10980113,10980114,10980115,10980116,10977773,10977774,10977775,10977776,10977777,10977778,10978096,10978097,10978098,10978099,10978100,10978101,10978102,10978103,10978104,10978105,10978106,10978107,10978108,10978109,10978110,10978111,10978112,10978113,10978114,10978115,10978116,10978117,10978118,10978119,10978120,10978121,10978122,10978123,10978124,10978125,10978126,10978127,10978128,10978129,10978130,10978131,10978132,10978133,3581968,3581998,3581999,3582022,10978487,10978488,10978489,10978643,10426438,10621149,10621152,8611004,10621244,10621245,10621246,10978937,10978938,10978939,10978940,10978941,10978942,10978943,10978944,10426673,10426674,10621337,10621338,10621339,10426692,10426693,10621386,10621387,10621388,10426736,10426760,10426797,10426798,10426799,10426800,10426801,10426802,10426803,10426816,10426817,10426818,10426835,10426836,10426837,10426838,10426988,10621664,10621665,10427003,10979595,10979596,10979597,10979598,10979599,10979600,10979601,10979602,8853391,8853392,8853397,8853399,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,9178743,9178774,9178775,9178897,9178966,9178967,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,10949203,10949204,10896545,10896546,10896547,10896584,10896585,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'