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(8630767,8630768,8630769,8630770,8574321,10870457,8630909,8630910,8630913,8630914,9215035,9215036,8569448,8631119,8631120,8631121,10870764,10870765,8631123,10870766,8631124,8631194,8631195,8631196,8631197,8631198,8631199,8631200,8631201,8631202,8631203,8631204,8631211,8631212,8631213,8631214,8631215,8631216,8631217,8631218,8631219,8631220,8631221,8631222,8631223,8631224,8631225,8631226,8631227,8631228,8631229,8631230,8631231,8631232,8631233,8631234,8631235,8631236,8631237,8631238,8631239,8631240,8631241,8631242,8631243,8631244,8631245,8631246,8631247,8631248,8631566,8631732,8575746,8575747,8575748,10871866,7066646,8632391,8632463,8632464,8632465,8632466,8632467,8632468,8632469,8632470,8632471,8632472,8632473,8632474,8632475,8632476,8632477,8632478,8632479,8632480,8632481,8632482,8632483,8632484,8632485,8632486,8632487,8632488,8632489,8632521,8632533,8632534,8632535,8632536,8632537,8632538,8629581,8629582,8629583,8629584,7066981,7066985,10869286,7075043,8629742,8629835,8629836,8629839,8629900,8629901,8629916,8629917,8629960,8629961,8629965,8629966,8629967,8629968,8629969,8629970,8629971,8629972,8629973,8629974,8629975,8629976,8629977,8629978,8629979,8629980,8629981,8629982,8630130,8630131,8630132,8630133,8630134,8630135,8630136,8630137,8630138,8630139,8630140,8630141,8630142,8630143,8630144,8630145,8630146,8630147,8630148,8630149,8630150,8630151,8630152,8630153,8630154,8630155,8630156,8630157,8630158,8630159,8630160,8630161,8630162,8630163,8630164,8630165,8630166,8630167,8630168,8630169,8630170,8630171,8630177,8630188,8630189,8630190,8630191,8630192,8630193,8630194,8630195,8630196,8630197,8630198,8630199,8630200,8630201,8630202,8630203,8630204,8630205,8630206,8630207,8630208,8630209,8630210,8630211,8630212,8630213,8630214,8630215,8630216,8630217,8630224,8630225,8630226,8630227,8630228,8630229,8630247,8630248,8630265,8630301,9214406,8630429,7201200,7201201,7201211,7201624,8628267,8628268,8628340,10960475,8628584,8628597,8628607,10843867,7202364,7202365,8628804,8628805,8628812,8628813,8628814,8628815,8628816,8628817,8628875,8628878,8628881,8628884,8628887,8628903,10844228,10104610,8629250,8629251,8629252,8629354,8629434,8629435,8629578,8629579,8629580,3237607,7200460,3927619,7200632,8627051,7071413,8627071,8627076,8627077,8627078,8627079,8627113,11011438,11011439,8627404,8627411,10102897,8627415,8624602,10995679,8624691,10839824,3655659,3655664,3655666,3925510,10840138,8625086,8625087,8625088,7198690,8625155,8625210,8625211,8625212,8625213,11009285,8625276,8625305,10840556,8625467,8625468,8625469,8625470,8625473,8625480,8625481,8625482,8625627,8625695,10996790,8625774,8625775,8625776,8625780,8625783,8625784,8625786,8625787,8625788,8625789,7199414,8625866,8625868,8625877,8625878,8625889,8625893,8625897,8626028,8626029,8626030,8626031,8626032,8626036,8626071,8626072,8626073,8626074,8626075,8626076,8626096,8626198,8626228,10101713,10101714,10942322,8626355,8626356,8626357,8626528,7196282,7196283,7196317,7196344,7196345,7196346,7196347,7196348,7196349,7196355,8554065,7196520,7196527,7196542,7196543,8070064,8070080,8070116,11046525,3234574,3234575,3234576,3234577,3234578,10619193,8555316,8624254,8624255,7197900,7197908,8624379,3235154,3235155,8624496,8624497,8624503,8624504,8624505,8624507,8624509,8624512,10839624,8614761,8541538,8541539,8541604,8541605,8541647,8634923,3232716,3232756,3232762,3232764,3232778,3232779,3232780,8541936,8541939,8542018,8542019,8542020,8542021,10617740,8578989,8542377,8569917,8632703,8632704,8632730,8632731,10951716,8632775,8632781,8632845,8632933,8632950,8632983,8633001,8633055,8633056,8633057,8633062,8633063,8633064,8633065,8633067,8633068,10615477,8633137,8633157,8633160,8633161,8633163,10615552,10991312,3231137,8633414,8633415,8633416,8633417,9217428,9217429,9217430,9217431,3231329,3231395,8540694,8540756,8634093,8634094,8634095,8634170,8634312,8634316,8634317,8634318,8634319,8634336,8634344,8634345,8634346,8634347,8634348,8634349,8634350,8634351,8634352,8634353,8634422,8634426,8634571,8634572,9189409,10559294,8853429,6665842,8853686,6670232,6670233,7057569,7057727,7057738,7057913,10557702,10557703,10557704,10557705,10557706,10557712,10557713,10557714,6676463,10609973,3653630,10558317,10558318,10558319,10558320,10120788,6677017,10121043,10121045,10613547,10610838,10559007,10559008,10559009,10559010,6677405,10559012,6677406,3654477,3654479,3654481,3654486,10126092,8849917,8849942,8849943,6674568,6674731,8850610,7057167,10124629,10124635,10124647,10124662,10124671,7054861,6680970,6681378,9182422,6666844,6666845,6671159,10123244,9175083,9175114,9175115,9175116,9175117,9175118,9175119,10123577,6668091,10888970,10175036,10175038,10156050,7000889,10627775,10627803,10627816,10627817,10627818,10627819,10627820,10627851,10908362,10627852,10627853,10627854,10627855,10910531,10910532,10910536,10910537,10910538,10910542,10630117,10630118,10900668,10900671,10900672,10625560,10626059,10626060,10626297,10163025,10163028,10163077,10163306,10163318,10163321,10163322,10626954,10583131,10583145,10583146,10583147,10598202,10598203,10598204,10592281,10592282,10592283,10592284,10592285,10592286,10592287,10592288,10592338,10592339,10592340,10592341,10592342,10592343,10592344,10598445,10598446,10592453,10592474,10592475,10592476,10592477,10592478,10592479,10592480,10592481,10592482,10592483,10592499,10592500,10592501,10592502,10592503,10592504,10592536,10592537,10595544,10595545,10595546,10595547,10595548,10595549,10595550,10595551,10595552,10595553,10595554,10595555,10595556,10595557,10595558,10595559,10595560,10595561,10595562,10595563,10592594,10592595,10592596,10592597,10592598,10592605,10592628,10592629,10592673,10592771,10592772,10592773,10592817,10592818,10592819,10592907,10592908,10595956,10595957,10595958,10595959,10595960,10595967,10592988,10595994,10595995,10596021,10596022,10593151,10593152,10593224,10593225,10593226,10596286,10596297,10596298,10596325,10596326,10596335,10593461,10593462,10593463,10593522,10594025,10594026,10594027,10594028,10594029,10594030,10594066,10594067,10594094,10594095,10594111,10594112,10594113,10594114,10594115,10594116,10594117,10594118,10594135,10594136,10594137,10594138,10594139,10594140,10594141,10594142,10594224,10594225,10594226,10594227,10594403,10594404,10594405,10594406,10594407,10594408,10594409,10594542,10594543,10594544,10594545,10594590,10594599,10594600,10594605,10594606,10594607,10582608,10594608,10582609,10594609,10582610,10582611,10582612,10582613,10582615,10594626,10594627,10594628,10594629,10582630,10594630,10582631,10582632,10594633,10582633,10582634,10594646,10594647,10594718,10597877,10597878,10597883,10597887,10583031,10583044,10583045,10595046,10598087,10598088,10598089,10598090,10598091,10598094,10521402,10521403,10521404,10521405,10521406,10521407,10521408,10521409,10521410,10529410,10521411,10529411,10529424,10549689,10540084,10548410,10546601,10546602,10538714,10538715,10538716,10538717,10538718,10538719,10538720,10538721,10538722,10538723,10538760,10538761,10538762,10538763,10538764,10538765,10538766,10538770,10538771,10538772,10538773,10538774,10538775,10538776,10538777,10538778,10538779,10538780,10538781,10520827,10527028,10504225,10422403,10422404,10422405,10508353,10508354,10508366,10421491,10507732,10507733,10507734,10507735,10424875,10423150,10422167,10486558) 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'