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(8559344,8559372,8559399,8595109,10103854,10872302,10872330,10872353,10872371,10872393,10872427,8618977,8619004,10251141,10251142,7073956,8837038,8837039,10251301,10251509,10251510,10251666,10251667,10251668,10251669,10857894,10857895,10857896,10857897,8594636,8594637,8594638,8594639,8594640,8594641,8594642,8594643,8594644,8594645,8594646,8594647,8594648,8594649,8594650,8594651,8559127,8559204,8559230,8559263,6000108,6000124,6000134,6000205,6000267,3926896,3926980,7073712,7073733,10942653,10942676,8861290,10207857,10218478,10283815,10283816,10283817,10283818,10283819,10283820,10283821,10283822,7157494,7157495,7157496,7157497,7157498,7157499,7157500,7157501,7157502,7157503,7157504,7157505,7157506,7157507,7157508,7157509,7157510,7157511,7157512,7157513,7157514,7157515,7157516,7157517,7157518,7157519,7157520,7157521,8570225,8570276,10845646,10930220,10930257,10845782,10845783,10845837,10848702,10848703,10848704,10848705,10848706,10848707,10848708,10848709,10848710,10848711,10848712,10848713,10848714,10848715,10848716,10848717,10848718,10848719,10848720,10848721,10848722,10848723,10848724,10848725,10848726,10848727,10848728,10848729,10848730,10848731,10848732,10848733,10848734,10848735,10848736,10848737,10848738,10848739,10848740,10848741,10848742,10848743,10848744,10848745,10848746,10848747,10848748,10848749,10848750,10848751,10848752,10848753,10848754,10848755,10848756,10848757,10848758,10848759,10848760,10848761,10848762,10848763,10848764,10848765,10848766,10848767,10848768,10848769,10848770,10848771,10848772,10848773,10848774,10848775,10848776,10848777,10848778,10848779,10848780,10848781,10848782,10848783,10848784,10848785,10848786,10848787,10848788,10848789,10848790,10848791,10848792,10848793,6669784,6669785,6669786,6669787,6669788,6669789,6669790,6669791,6669792,6669793,6669794,6669795,6669796,6669797,6669798,6669799,6669800,6669801,6669802,6669803,6669804,6669805,6669806,6669807,6669808,6669809,6669810,6669811,6669812,6669813,6669814,6669815,6669816,6669817,8864593,8864612,8864658,8067455,6673821,6673831,6673835,6673839,6673842,6673845,6673847,6673848,6673855,6674172,9910563,9910564,9910565,9910566,9910567,9910568,9910569,6672735,6672736,6672737,6672738,6672739,6672740,6672741,6672742,6672743,6672744,6672824,6672829,10428383,4974106,3655981,3656045,3656046,3656047,3656114,3656168,3656169,3656170,3656171,3656172,8847266,8847267,8847268,8847269,8847270,8847271,8847272,8847273,8847274,8847275,8847276,8847277,8847278,8847279,8847280,8847281,8847282,8847283,8847284,8847285,8847286,8847287,8847288,8847289,8847290,8847291,8847292,8847293,8847294,8847295,8847296,8847297,8847298,8847299,8847300,8847301,8847302,8847303,8847304,8847305,8847306,8847307,8847308,8847309,8847310,8847311,8847312,8847313,8847314,8847315,8847316,8847317,8847318,8847319,8847320,8847321,8847322,8847323,8847324,8847325,8847326,8847327,8847328,8847329,8847330,8847331,8847332,8847333,8847334,8847335,8847336,8847337,8847338,8847339,8847340,8847341,8847342,8847343,8847344,8847345,8847346,8847347,8847348,8847349,8847350,8847351,8847352,8847353,8847354,8847355,8847356,8847357,8847358,8847359,8847360,8847361,8847362,8847363,8847364,8847365,8847366,8847367,8847368,8847369,8847370,8847371,8847372,8847373,8847374,8847375,8847376,8847377,8847378,8847379,8847380,8847381,8847382,8847383,8847384,8847385,8847386,8847387,8847388,8847389,8847390,8847391,8847392,8847393,8847394,8847395,8847396,8847397,8847398,8847399,8847400,8847401,8847402,8847403,8847404,8847405,8847406,8847407,8847408,8847409,8847410,8847411,8847412,8847413,8847414,8847415,8847416,8847417,8847418,8847419,8847420,8847421,8847422,8847423,8847424,8847425,8847426,8847427,8847428,8847429,8847430,8847431,8847432,8847433,8847434,8847435,8847436,8847437,8847438,8847439,8847440,8847441,8847442,8847443,8847444,8847445,8847446,8847447,8847448,8847449,8847450,8847451,8847452,8847453,8847454,8847455,8847456,8847457,8847458,8847459,8847460,8847461,8847462,8847463,8847464,8847465,8847466,8847467,9199658,9199659,10123873,10123882,10123883,9199705,9199792,10124036,10124037,10883554,10883555,10883556,10883557,10883558,10883559,10883560,10883561,10883562,8594436,10629013,10629194,10875133,10912541,10912542,10912597,10912598,10912599,10912600,10912822,10888023,10888024,10888025,10888026,10888027,10888028,10888029,10888030,10888031,10888032,10888033,10177208,10177209,10177210,10912094,10912095,10912155,10912156,10568396,10568484,10568506,10601414,10601415,10601416,10601417,10601418,10601419,10601420,10601421,10601422,10601423,10601424,10601425,10601426,10601427,10601428,10601429,10601430,10601431,10601432,10601433,10601434,10601435,10601436,10601437,10610691,10568066,10423456,10423476,10423497,10423509,10423529,8563170,10496911,10493069,10493123,10412477,10412478,10412479,10412480,10412481,10493235,10493259,10715143,10715146) 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'