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(10939593,10943454,10943455,10943456,10939711,7068243,7068244,10940160,10940324,10940325,4971026,4971027,4971028,4971137,4971138,4971139,4971140,4971141,4971142,4971143,7073971,10976753,10976754,7066689,7066690,7066691,10964546,10964547,10964548,10964549,10964550,10964551,10964552,7074939,7075038,10961730,7075185,7067219,7067220,7067221,7067222,7067223,7067224,7075242,7075265,7075288,11001079,10962123,7075755,10962504,10962505,6000224,7072192,7072193,7072293,8075226,10931907,10931910,10932155,8065981,8065982,8065983,8065984,10932675,11000085,10932856,10932857,10932858,10932859,10961306,10961307,10961308,10961309,10961310,10961316,10961317,10961318,10961319,10961320,10961321,10961456,10961457,10961458,10933207,10933208,10933209,7073885,11049136,7071359,11049353,11049384,11049385,10943111,10943134,10943135,10943136,7069228,10996188,10996261,10996262,10996284,10996285,10996291,10996292,10996293,10996294,3656493,3656494,3656624,3656625,3656626,11048593,11048594,11048595,11048596,11048597,11048598,11048599,10918481,10918482,10617988,10617989,10617990,10617996,10617997,10618068,10618115,10955114,10919827,10919828,10919837,10619330,10619331,10619332,10619333,10619334,10619335,10619336,11005620,11005621,11005622,11005623,11005624,11005625,11005626,11005627,11005628,11005629,11005630,11005631,11005632,11005633,11005634,11005635,11005636,11005637,11005638,11005639,11005640,11005641,11005642,11005643,11005644,11005645,11005646,11005647,11005648,11005649,11005650,11005651,11005652,11005653,11005654,11005655,11005656,11005657,11005658,11005659,11005660,11005661,11005662,11005663,11005664,11005665,11005666,11005667,11005668,11005669,11005670,11005671,11005672,11005673,11005674,11005675,11005676,11005677,11005678,11005679,11005680,11005681,11005682,11005683,11005684,11005685,11005686,11005687,11005688,11005689,11005690,11005691,11005692,11005693,11005694,11005695,11005696,11005697,11005698,11005699,11005700,11005701,11005702,11005703,11005704,11005705,11005706,11005707,11005708,11005709,11005710,11005711,11005712,11005713,11005714,11005715,11005716,11005717,11005718,11005719,11005720,11005721,11005722,11005723,11005724,11005725,11005726,11005727,11005728,11005729,11005730,11005731,11005732,11005733,11005734,11005735,11005736,11005737,11005738,11005739,11005740,11005741,11005742,11005743,11005744,11005745,11005746,11005747,11005748,11005749,11005750,11005751,11005752,11005753,11005754,11005755,11005756,11005757,11005758,11005759,11005760,11005761,11005762,11005763,11005764,11005765,11005766,11005767,11005768,11005769,11005770,11005771,11005772,11005773,11005774,11005775,11005776,11005777,11005778,11005779,11005780,11005781,11005782,11005783,11005784,10617198,10925556,10925557,10925558,10925559,10925560,10925561,10925562,10925563,10925564,10925565,10925566,10925567,10925568,10925569,10925570,10925571,10925572,8570316,11004080,11004130,11004131,11004132,11004133,11004134,11004135,11004136,11004137,11004138,11004139,11004140,11004141,10620483,11004142,11004143,11004144,11004145,11004146,11004147,11004148,11004149,11004150,11004151,11004152,11004153,11004154,11004155,11004156,10926009,11004157,11004158,11004159,11004160,11004161,11004162,11004163,11004164,11004165,11004166,11004167,11004168,11004169,11004170,11004171,11004172,11004173,11004174,11004175,11004176,11004177,11004178,11004179,11004180,11004181,11004182,11004183,11004184,11004185,11004186,11004187,11004188,11004189,11004190,11004191,11004192,11004193,11004194,11004195,11004196,11004197,11004198,11004199,11004200,11004201,11004202,11004203,11004204,11004205,11004206,11004207,10926060,11004208,11004209,10926061,11004210,10926062,10926063,11004211,10926064,11004212,10926065,11004213,11004214,11004215,11004216,11004217,11004218,11004219,11004220,11004221,11004222,11004223,11004224,11004225,11004226,11004227,11004228,11004229,11004230,11004231,11004232,11004233,11004234,11004235,11004236,11004237,11004238,11004239,11004240,11004241,11004242,11004243,11004244,11004245,11004246,11004247,11004248,11004249,11004250,11004251,11004252,11004253,11004254,11004255,11004256,11004257,11004258,11004259,11004260,11004261,11004262,11004263,11004264,11004265,11004266,11004267,11004268,11004269,11004270,11004271,11004272,11004273,11004274,11004275,11004276,11004277,11004278,11004279,11004280,11004281,11004282,11004283,11004284,11004285,11004286,11004287,11004288,11004289,11004290,11004291,11004292,11004293,11004294,11004295,11004296,11004297,11004298,11004299,11004300,11004301,11004302,11004303,11004304,11004305,11004306,11004307,11004308,11004309,11004310,11004311,11004312,11004313,11004314,11004315,11004316,11004317,11004318,11004319,11004320,11004321,11004322,11004323,11004324,11004325,11004326,11004327,11004328,11004329,11004330,11004331,11004332,11004333,11004334,11004335,11004336,11004337,11004338,11004339,11004340,11004341,11004342,11004343,11004344,11004345,11004346,11004347,11004348,11004349,11004350,11004351,11004352,11004353,11004354,11004355,11004356,11004357,11004358,11004359,11004360,11004361,11004362,11004363,11004364,11004365,11004366,11004367,11004368,11004369,11004370,11004371,11004372,11004373,11004374,11004375,11004376,11004377,11004378,11004379,11004380,11004381,11004382,11004383,11004384,11004385,11004386,11004387,11004388,11004389,11004390,11004391,11004392,11004393,11004394,11004395,11004396,11004397,11004398,11004399,11004400,11004401,11004402,11004403,11004404,11004405,11004406,11004407,11004408,11004409,11004410,11004411,11004412,11004413,11004414,11004415,11004416,11004417,11004418,11004419,11004420,11004421,11004422,11004423,11004424,11004425,11004426,11004427,11004428,11004429,11004430,11004431,11004432,11004433,11004434,11004435,11004436,11004437,11004438,11004439,11004440,11004441,11004442,11004443,11004444,11004445,11004446,11004447,11004448,11004449,11004450,11004451,11004452,11004453,11004454,11004455,11004456,11004457,11004458,11004459,11004460,11004461,11004462,11004463,11004464,11004465,11004466,11004467,11004468,11004469,10926322,11004470,11004471,11004472,11004473,11004474,11004475,11004476,11004477,11004478,11004479,11004480,11004481,11004482,11004483,11004484,11004485,10926338,11004486,11004487,11004488,11004489,11004490,11004491,11004492,11004493,11004494,11004495,11004496,11004497,11004498,11004499,11004500,11004501,11004502,11004503,11004504,11004505,11004506,11004507,11004508,11004509,11004510,11004511,11004512,11004513,11004514,11004515,11004516,11004517,11004518,11004519,11004520,11004521,11004522,11004523,11004524,11004525,11004526,11004527,11004528,11004529,11004530,11004531,11004532,11004533,11004534,11004535,11004536,11004537,11004538,11004539,11004540,11004541,11004542,11004543,11004544,11004545,11004546,11004547,11004548,11004549,11004550,10965599,10965600,10991601,10991602,10991603,10616013,10930965,10921747,10926856,10926857,10922315,10922316,10922317,10922318,10922319,10922320,10922321,10616905,10927448,7059470,9173856,9173857,9173864,9173865,9173866,9173867,9173868,9173869,9173870,9173871,9173872,9173873,9173874,9173875,8864453,8864454,8864455,8864456,8864457,10614760,8864675,9171302,9171319,9171320,10612043,9171955,8862820,8862821,8862822,8862823,8862824,10558472,10564808,10564809,10515243,10515244,10515245,10515246,9161490,10513325,10513326,10513327,10517328,9169926,4974963,4974964,4974965,4975072,9170885,9171144,9171148,9171150,9171151,9171152,9171154,9171155,9171156,9171157,9171248,4973423,4973424,10416537,10416538,10415899,10415900,10415999,10416000,10417089,10417090,10418156,10418157,8864860,8864861,8864862,8864863,8864864,8864865,6666465,6666502,6666503,8865143,8916912,10469965,10469972,10469973,10469974,10470091,10470137,6667818,8917791,10470723,8917929,8917930,10628086,10628087,10628088,10628089,10628090,10628091,10628092,10628093,10628094,10628095,10628096,10628097,10628098,10628099,10628100,10628101,10628102,10628103,10628104,10155832,10155833,10155834,10155835,10155836,10629352,10629485,10629569,10629570,10629571,10156207,10156208,10156209,10156210,10163484,10163485,10163486,10163487,10163488,10163489,10163490,10163491,10163492,10158703,10158704,10158705,10627673,10162544,10162545,10631076,10631077,10631078,10631079,10631080,10631081,10631082,10631261,10631680,10631693,10631694,10631796,10626954,10163481,10163482,10163483,10525366,10525374,10525375,10522713,10522714,10520757,10520758,10520759,10520760,10520761,10520762,10520763,10520764,10520765,10520766,10520767,10520768,10520769,10520770,10520771,10520772,10520773,10520774,10520775,10520776,10520777,10420566,10420567,10420568,10420569,10420570,10420571,10423834,10423835,10423836,10421929,10421934,10423958,10423959,10423019,10423101,10473345,10473426,10473427,10473486,10473502,10473503,10473504,10473505,10473506,10473507,10473830,10473831,10473832,10476528,10476529,10476530,10476531,10476532,10476533,10476534,10476535,10476536,10476537,10476538,10476539,10476540,10476541,10476542) 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'