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(7067994,10873334,11014763,10448005,11001849,11001850,10939908,11015030,11015031,10848804,10848805,8839009,8621405,8583108,10963332,10963333,10849099,11041545,11015680,11015681,11015682,11015683,11015684,11015685,11015686,8631797,10849752,8622303,10849832,11016272,11016273,11016274,11016275,11029287,10951236,11016313,11016314,11016315,9216308,3230161,11013850,7075192,7075206,7075207,8561169,8561185,8561186,11027006,11040043,11027045,11027046,8837893,7067444,8838127,8838128,8838129,8838130,8838131,8838132,8838133,8620505,8620524,10447587,7067765,9214514,3238356,7064091,7064092,7201595,10999063,10931774,8911506,10973244,10843334,11012315,10986386,10986387,10986388,10986389,10843576,11038534,8836390,10999586,10999587,8572091,8572092,8572093,11038610,11038611,11038612,4967144,11038613,4967145,4967146,11038614,11038615,8065984,11038771,11038772,11038773,11012886,10867636,11039036,11039037,8619265,11039119,11039120,11039121,8836957,8619369,8619370,8837078,10961306,10961307,7073641,10844412,10844413,10844414,10961501,10961516,10100067,8619759,11036640,8064012,8834740,8834741,10857547,10857548,10857549,11024120,7071616,4430267,10857984,10857985,11024385,11024386,11024442,11037574,10839728,10863592,10863593,10863605,10863606,8615182,8615356,7069645,3656294,7069726,10941356,10996417,10864122,3236731,10841127,11048380,10101683,11036274,11036275,10101756,11036337,10997373,10997375,10997376,10997377,8909768,8909769,8909781,11048653,8557830,10918519,10918520,11019739,11019740,11019741,11006782,8612933,11006783,10918817,3233930,8613403,3924138,8554786,10618880,10618881,10618882,8070809,10994796,10994797,10919850,10920024,10920025,10920026,10839267,10839331,3235028,10624729,10624730,8614576,8614577,8614597,11005689,11005690,11005692,11018749,11018750,11005785,11005786,11005787,11005862,11005863,11005864,11005992,10927925,10927932,10927933,11006181,11006182,11006183,8542116,11032289,11032290,11032362,11006532,8579047,10915472,10915473,10915474,10915475,10915476,10460523,3230490,10615195,10615196,10615197,10615198,10615199,10615200,10615201,10615202,10951831,8570493,11043279,10926144,10926145,10926235,10952454,10616080,10921641,3231638,10921763,10952927,10952928,11005185,10616568,8552550,8552562,8611479,7155406,10917414,11018618,11018619,9189301,9189310,9189347,8853307,6677741,6677742,6677745,6677801,6677856,6677857,8864312,8864316,3655005,6670053,6670054,6670055,6670056,9916065,9173906,6678261,9916284,6666257,6666258,9211373,9187404,10119691,10119692,10119720,10119863,10119864,10119865,10119866,10609344,10609345,10119899,10119900,9211801,9187907,10120180,10120181,10120182,10120263,9220331,8566896,3653618,9172434,9172507,9914855,9172766,9172907,9205000,9205017,9189112,9915367,989910,4974422,4974425,10513398,10125881,10125882,10125924,10125925,8592980,8593082,7023671,9202206,9202229,10118525,10514152,10514153,10514154,10516621,10516622,10516623,9210922,7024666,9171150,9171151,10517029,10517030,10517031,10517032,8848290,6680733,10417479,9200725,9200739,9200740,9200741,6681016,6681026,10417117,9201195,6678577,8864969,8854289,6666463,8854303,6678696,9916718,6678718,6678747,8865169,10471279,4971693,4971694,4971695,8550106,9183005,4972022,9175239,8855093,8563200,6679521,6679563,10469966,6667442,10115689,10115690,10115691,10115692,9207583,6679795,9207648,8847633,9207855,9207856,9175861,9175863,9175884,9191912,9191929,10462673,8551271,10462741,10462742,10462743,10159744,10159745,10159746,10159747,10159748,10159749,10174816,10888905,10179961,10914014,10914015,10914016,10914017,10914018,10914019,10914020,10914062,10914063,10914064,10914065,10914066,10914067,10914068,10889262,10914423,10889449,10889484,10889485,10914611,10904707,10904708,10904709,10904729,10904730,10904731,10889751,10914953,10914954,10914968,10914969,10914970,10914971,10894979,10894980,10894981,10894982,10894983,10894984,10910050,10875281,10875282,10166294,10915452,10915471,10154013,10154014,10154015,10154016,10888043,10888044,10908395,10910546,10181667,10181668,10890868,10890869,10177545,10187565,10891623,10891624,10172746,10177760,10177784,10177785,10177786,10177787,10177788,10177789,10177790,10177791,10911894,10911895,10911896,10911897,10911898,10911899,10911909,10631681,10631682,10631699,10631700,10163248,10626826,10945229,10945230,10945231,10945232,10945233,10945234,10950266,10608602,10608603,10608609,10584197,10584198,10584199,10584200,10587449,10587450,10587451,10587452,10587453,10587454,10587455,10587456,10644597,10644598,10644599,10647787,10604030,10585893,10645966,10645967,10645968,10645969,10601798,10601805,10543324,10529342,10545477,10545478,10545479,10545480,10545481,10545482,10545483,10545484,10545485,10545486,10545487,10545488,10545489,10545595,10545629,10545630,10545631,10545632,10545633,10545634,10545635,10545636,10545637,10545638,10545639,10545640,10545641,10545642,10545698,10551996,10508281,10508282,10508283,10508284,10420393,10508285,10498507,10498508,10498509,10424020,10485918,8562245,10407287,10407325,10407341,10412570,10412571,10478400,10478401) 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'