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(8622186,10437546,8609585,8609586,10872225,10872250,10872251,11001217,8620483,8620486,10845439,10845440,10845441,6000218,6000219,6000220,6000221,6000222,6000223,6000224,6000225,6000226,6000227,6000228,6000229,6000230,6000231,11011644,11011645,11011646,11011647,11011685,11011686,11011687,11011688,6000287,6000288,6000289,8559040,8559042,8559043,10931543,10931544,10931545,8559164,8559165,8559166,8559167,8559168,8559169,8559170,8559211,8559212,8559213,8559214,8559215,8559221,8559222,8559223,8559224,8559225,8559226,8559227,8559246,8559267,8559268,8559269,8559270,8559318,10103595,10103767,10103772,10103773,10960389,10960390,10960391,10960392,10960393,10960394,10960395,10960396,10960397,10960398,10960399,8618789,8618790,3899462,8618927,8618961,8618962,8619009,8619010,8619011,8619012,8619013,8619014,8619019,8619020,8619021,8619022,8619023,8619028,8619029,8619030,8619042,8619095,8619096,8619097,8619098,8619099,8619100,8619101,8619102,8619103,8619104,8619105,8619106,8619107,8619108,8619109,5654799,11010740,8627227,8627228,8627235,11011278,8627244,8627246,11011299,8627267,8627280,11011409,11011410,11011411,11011412,11011413,11011414,11011415,11011416,11011417,11011418,11011419,6000115,6000116,6000120,6000140,6000141,6000142,6000143,6000144,6000145,6000146,6000147,6000148,6000164,6000165,6000166,6000167,6000168,6000169,6000214,6000215,6000216,6000217,10944790,10944791,11009747,11010495,11010496,11010497,11010498,11010499,11010500,11010501,11010502,11010503,11010504,8554287,10838754,8542113,8579020,10847886,10847887,10952215,10952219,8611270,10922073,10565128,10565129,10565130,10565131,10565132,10565133,10565134,10565135,10565136,10565138,10565139,10565140,10565141,10565142,10565143,9915607,9915608,9197807,9197808,9197809,9198046,9198047,9198048,9198049,8568719,10563228,10563229,10563230,10563231,10563232,10563233,10563234,10563235,10563236,10563237,10563238,10563239,10563240,10563241,10563242,10563243,10563244,10563245,10563246,10563247,10563248,10563249,10563250,10563251,10563252,10563253,10563254,10563255,10563256,10563257,10563258,10563259,10563260,10563261,10563262,10563263,10563264,10563265,10563266,10563267,10563268,10563269,10563270,10563271,10563272,10563273,10563274,10563275,10563276,10563277,10563278,10563279,10563280,10563281,10563282,10563283,10563284,10563285,10563286,10563287,10563288,10563289,10563290,10563291,10563292,10563293,10563294,10563295,10563296,10563297,10563298,10563299,10563300,10563301,10563302,10563303,10563304,10563305,10563306,10563307,10563308,10563309,10563310,10563311,10563312,10563324,10609346,9171757,7058437,7058518,7058529,9196434,9196435,9196436,10558436,10558437,4974660,4974661,4974662,4974663,9198907,9198908,9198911,8854846,9199079,9199080,9199081,9199082,9199083,10123506,10123507,6667363,9199375,6667543,6667544,6667545,6667546,6667547,6667548,10123781,10123782,6667590,10123791,10123792,10123793,10123794,9199600,10123838,10123839,10123840,9167653,9167654,9167655,9167656,10123881,10123882,10123883,10123885,10123886,10123887,10123888,10123889,10123890,10123891,10123892,10123893,10123894,10123895,10123896,10123897,10123898,10123899,10123900,10123901,10123902,10123903,10123905,10123906,10123907,10123908,10123909,10123910,10123912,10123913,10123914,10123915,10123916,10123917,10123918,10123919,10123920,10123921,10123922,10123923,8550887,10123937,10123938,8550899,10124010,10124011,10124012,10124013,10124014,10124015,10124016,10124017,10124018,10124019,10124020,10124021,10124022,10124023,10124024,10124025,10124026,10124027,10124028,8917713,10628542,10628543,10628816,10628841,10628842,10628843,10628856,10628939,10629368,10629369,10629370,10629371,10629372,10629373,10176568,10630149,10630150,10630151,10630152,10630153,10630154,10176697,10911938,10911939,10911940,10912067,10912068,10912069,10912070,10882391,10882392,10882393,10652271,10652272,10652273,10652274,10652275,10568316,10568317,10568318,10568319,10568320,10602171,10568321,10568322,10568323,10568324,10568325,10568326,10568327,10568328,10568329,10568330,10568331,10568332,10568333,10568334,10568335,10568336,10568337,10568338,10568339,10568340,10568341,10568342,10568343,10568344,10568345,10568346,10568347,10568348,10568349,10568350,10568351,10568352,10568353,10568354,10568355,10568356,10568357,10568358,10568359,10568360,10568361,10568362,10568363,10568364,10568365,10568366,10568367,10568368,10568369,10568370,10568371,10568372,10568373,10568374,10568375,10568376,10568377,10568378,10568379,10568380,10568381,10568382,10568383,10568384,10566171,10566172,10566173,10566174,10566175,10566176,10566177,10566178,10566179,10566180,10566181,10566182,10566183,10566184,10566185,10566186,10566187,10566188,10566189,10650367,10651416,10651417,10651418,10651419,10567362,10567483,10567484,10567485,10567486,10567487,10567488,10567489,10567490,10567491,10567492,10567493,10567494,10567495,10567501,10567502,10567503,10567504,10567505,10567506,10567507,10567508,10567598,10567599,10567600,10567601,10567602,10567603,10567604,10567605,10567606,10567607,10567608,10567609,10567610,10567611,10567612,10567613,10567614,10567615,10567616,10567617,10567618,10567619,10567620,10567773,10567774,10567775,10567776,10567777,10567778,10567779,10567780,10567781,10567782,10567783,10567784,10567785,10567786,10567787,10567788,10567789,10567790,10567791,10567792,10567793,10567794,10567795,10567796,10567797,10567798,10567799,10567800,10567801,10567802,10567803,10567804,10567805,10567806,10567807,10567808,10567809,10567810,10567811,10567812,10567813,10567814,10567815,10567816,10567817,10567818,10567819,10567820,10567821,10567822,10567823,10567824,10567825,10567826,10567827,10567828,10567829,10579829,10567830,10579830,10567831,10579831,10567832,10579832,10567833,10579833,10567834,10579834,10567835,10579835,10567836,10567837,10567838,10567839,10567840,10567841,10567842,10567843,10567844,10567845,10567846,10567847,10567848,10567849,10567850,10567851,10567852,10567853,10567854,10567855,10567856,10567857,10567858,10567859,10567860,10567861,10567862,10567863,10567864,10567865,10567866,10567867,10567868,10567869,10567870,10567871,10567872,10567873,10567874,10567875,10567876,10567877,10567878,10567879,10567880,10567881,10567882,10567883,10567884,10567885,10567886,10567887,10567888,10567889,10567890,10567891,10567892,10567893,10567894,10567895,10567896,10567897,10567898,10567899,10567900,10567901,10567913,10567914,10567915,10567916,10567917,10567918,10568005,10568006,10522892,10522893,10522894,10423416,10423417,10507549,10507550,10507551,10507552,10507553,10507554,10492791,10492792,10492793,10492794,10492795,10492796,10493048,10493049,10493050,10493051,10493052,10493053,10493054,10493055,10493056,10493057,10493064,10493065,10493066,10493067,10493068,10493069,10493070,10493071,10493072,10493077,10493078,10493079,10493080,10493081,10493082,10493083,10493084,10493085,10493086,10493087,10493088,10493089,10493090,10495110,10495111,10495112,10493122,10493123,10493124,10493125,10493126,10493127,10493128,10493129,10493130,10493131,10493157,10493158,10493159,10493160,10493161,10493162,10493163,10493164,10493165,10493166,10493167,10493168,10493169,10493170,10493171,10493172,10493173,10493174,10493175,10493176,10493177,10493178,10493179,10493180,10493181,10493182,10493183,10493184,10493185,10493186,10493248,10493249,10493250,10493303,10493304,10493305,10493306,10493307,10493308,10493309,10493310) 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'