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(8574476,8574479,8574490,8574491,8574510,8574516,8574519,8574520,8630993,8630996,8574530,8631001,8631003,8631013,3229108,8631509,10963550,10963551,10963552,10963559,10862253,10862254,10862255,9215622,10862256,9215623,10862257,10862258,9215624,9215625,9215626,10862260,11041660,10933336,8583479,10933357,8583481,8583482,10950685,10849390,10849391,10849393,10849462,10849465,10849468,10849469,10849478,9215864,8631862,8631984,8632007,8632011,8632014,8632015,8632017,8632018,8575581,8632281,8632346,8632347,8632348,8632349,8609570,8609571,8609572,8609573,8632466,10869181,10869183,10869189,10869190,7066917,8629705,10872751,8630453,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,8559028,8559029,7201386,7201605,8559575,8559577,7201898,10104055,8618762,8618763,8618764,7202371,10932809,10932973,10932976,10932979,10933000,7065694,10868088,11036627,11036628,11036629,11036630,11036631,11036632,11036633,11036634,11036635,11036641,11036643,3237393,3237396,11036702,11036714,11010740,10997846,10997848,7200599,7200606,11037205,11037207,11037208,11037209,11037226,11037228,11037229,11037234,11037235,11037239,11037240,11037241,11037242,11037249,10102901,10839726,7198682,8615274,8625105,3236073,8908741,10840466,8625386,8625388,8625389,8625393,8625395,10856099,10856100,10856102,3656396,8625625,8625626,10996784,10941767,8625794,8625796,8625798,8625800,8625801,8625804,8625806,8625808,8625809,8625813,8625814,8625817,8625824,8625826,8625828,8625831,8625833,8565233,8565245,8626184,8565255,8565256,11010438,11010507,11010508,3923930,3923950,8613644,8554790,8554791,8554795,8554797,8554799,3924401,10838816,10619131,10619132,10619135,10619136,10619137,10619138,10619139,10619141,10619142,10619143,10619146,10619147,10619148,10838922,10838924,7197622,7197677,7197700,7197701,7197743,7197744,7197746,7197747,7197795,7197798,7197799,7197812,7197813,7197814,7197815,8624322,8624323,8624505,8563610,10855215,10922515,10922518,10922520,8905086,8905258,8905259,8905261,8905262,8905263,10852508,10852509,10852574,10852576,8634964,10617378,10617442,3232901,3923092,11045449,8632594,8632598,8632599,8632600,8632601,10425356,10951651,10951652,8632690,8632691,3230545,3230546,8632774,8632775,10850653,9217046,8633205,9217222,9217223,9217224,9217228,10952320,10952321,10952323,10952324,10952325,3582216,10930951,3231504,10616243,8611086,8611087,8611088,8611089,10616298,8634237,10922208,10922209,10851972,8577886,10922260,10922270,10922271,10922282,8578018,8578023,10565127,10610988,9205379,9205389,10611375,10611376,10611428,10611479,10611509,10611519,10611551,10611597,10611615,10714438,10714444,8851145,8851260,8851295,8851296,8851445,8851446,9211926,8862865,10613057,10613058,10613063,9172930,9172938,9172939,9172945,10610947,10610958,10517205,10125856,10514399,8850628,8850839,8850840,8850848,8850849,8850907,8850908,8850935,8850936,9913413,8851108,8851109,8851113,8851114,10427731,10415372,10124750,10124801,6673125,9169232,8568856,8568859,8568860,8568861,8568917,8568925,8568927,8568928,9916955,9916961,9916962,9916965,8549918,8854721,8916698,8563362,8550921,8550922,8550924,8550993,8550994,8550995,8550996,9168100,10884075,10884077,10884080,10884081,10884653,10890149,10890155,10184047,10184048,10184049,10184381,10184382,10184383,10184384,10184386,10184396,10184400,10184401,10184402,10184403,10184404,10184405,10184406,10184407,10184408,10184409,10184410,10184411,10630045,10905687,10885709,10891729,10891730,10626258,10911836,10882061,10950082,10950147,10950148,10950149,10950152,10950154,10580168,10580183,10580184,10580185,10580186,10580187,10580477,10580478,10579479,10579836,10579849,10579850,10579851,10579852,10579853,10579854,10579858,10579859,10579860,10579861,10579862,10579863,10579864,10579865,10579866,10547889,10550445,10528636,10421398,10421400,10421406,10421407,10423661,10423662,10423667,10423668,10423669,10423672,10423673,10423674,10423675,10423676,10423677,10423678,10423680,10423681,10423682,10423683,10423689,10420708,10507682,10411226,10483158,10490316,10490356,10490357,10490358,10490359,10490360,10490361,10490362,10490363,10490364,10490365,10490366,10490367,10407922,10407996,10490721,10490723,10490725,10490726,10490727,10490728,10490729,10486795,10410399,10410403,10474090,10474091,10474092,10474093,10474094,10474095,10474096,10474097,10474098,10474099,10474100,10474101,10474102,10474103,10474104,10474105,10474106,10408974,10408976,10409029,10409033,10407052,10407058,10407059,10407065) 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'