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(10939624,10939625,7068264,7068268,7068271,7068274,7068279,10939907,10939908,7068286,7068299,7068303,7068309,7068320,7068336,8569438,8569441,8569452,8569512,8569513,8569635,8569647,8569648,8569652,8569689,8569694,8569718,8569907,7074374,7074375,7074378,7074380,7074382,7074383,7074384,7074385,7074386,7074387,7074388,7074390,7074393,7074394,7074395,7074396,7074399,7074400,7074402,7074405,7074409,7074411,7074412,7074413,7074414,7074415,7074416,7074417,7074418,7074419,7074420,7074421,7074422,7074423,7074424,7074425,7074426,7074427,7074428,7074429,7074431,7074432,7074433,4968650,7074434,7074435,7074436,7074438,8067416,4968655,7074439,7074441,7074443,7074444,7074446,7074447,7074448,7074449,7074450,7074451,7074452,7074453,7066456,7066459,7074463,7074464,7074465,7074466,7074468,7074469,7074470,7074471,7074472,7074473,7074474,7074476,7074477,7074478,7074479,7074480,7074481,7074482,7074483,7074484,7074485,7074486,7074487,7074488,7074489,7074491,7074492,7074494,7074495,7074496,7074498,7074501,7074503,7074505,7074507,7074509,7074511,7074513,7074514,7074515,7074516,7074517,7074519,7074521,7074522,7074523,7074524,7074529,7074530,7074531,7074532,7074535,7074539,7074540,7074541,7074542,7074543,7074549,7074610,7074644,7074645,7074646,10437591,10437592,10437593,7074762,7074763,7074764,7074765,7074766,7074767,7066786,7066806,7066809,7074811,7066834,7066835,10938837,10938839,7067309,7067368,7067369,7067473,7067654,7072445,7072446,7072470,7072477,10931852,10931855,10931856,10931860,10931861,7064588,7064593,7064594,7064644,7064645,7064717,7064733,7064735,7064760,7064761,7064771,7064822,7064823,7064856,7064863,7064878,7064892,7064911,7064912,7064926,7064947,10932295,10932305,7064977,7064983,7064984,7064985,7064986,7065004,7065056,7065058,7065067,7065078,10932663,10932664,10932665,10932696,10932697,10932701,7065355,7065356,10932709,10932714,10932721,10932722,10932726,10932727,7073600,7073604,7073606,7073608,7073609,7073610,10933034,10933191,10942603,10942618,10942619,11049109,11049152,11049223,11049224,11049225,11049226,11049234,11049235,11049236,11049237,11049238,11049247,11049248,11049250,7071399,7071402,8074349,8074480,7071820,7071829,10944371,10944372,10944373,3655681,3655682,3655683,3655727,3655729,3655730,10944638,3655838,3655839,3655840,3655850,3655860,3655874,3655875,3655876,3655879,3655880,3655881,3655882,3655883,3655884,3655886,3655887,3655888,3655889,3655893,3655894,3655898,3655900,3655901,3655902,3655904,3655905,3655906,3655907,10944759,10944764,10944780,10944781,10944782,10944783,3655950,7069468,7069469,7069473,7069477,10945101,8073099,8073107,8073114,8073124,8073139,8073151,8073158,8073168,8073182,8073190,8073197,8073206,8073219,8073229,8073237,8073247,8073266,8073274,8073280,7070552,8073289,8073300,8073311,8073318,8073331,8073341,8073344,8073348,8073353,8073360,8073363,8073366,8073371,8073375,8073378,8073381,8073385,8073390,8073395,8073398,8073403,8073407,8073410,8073413,8073417,8073422,8073425,8073428,8073434,10928497,10618310,10618311,10618313,10618314,10618315,10623694,10619366,10619416,10619490,10619495,10619496,10619497,10619498,10619499,10619510,10619545,10619546,10619547,10619710,10624850,10624851,10619928,10927992,10928004,8569923,8569924,8569925,8569926,8569927,8569928,8569929,10620073,10620074,8570109,8570137,8570138,8570194,8570195,8570196,8570197,8570373,10615683,10930906,10621089,10926735,10922281,7059599,7059750,7059751,7059752,7059855,7059867,6665734,10562651,10562652,10562653,6665841,6665932,10559834,10559835,10559836,10559837,10559838,10559839,10559840,10559841,10559842,10559843,10559844,10559845,10559846,10559847,10559848,10559849,10559850,10559868,10562871,10559874,10614732,10614733,10614734,10559889,10559934,10559935,10559936,10559937,10559938,10559939,10559940,6666269,6666270,6666271,6666272,6666273,10560092,10560093,10560094,6666280,10560096,10560097,10560098,10560099,10560100,10560101,10560102,10560103,10560104,10560105,10560106,10560107,10560108,10560115,10560247,10560248,10560249,10560250,10560251,10560252,10560267,10560280,10560281,10560282,10560283,10560284,10560315,10563316,10560316,10563317,10563318,10563319,10563320,10560321,10563321,10560322,10560323,10560324,10560325,10560326,10560327,10560328,10560329,7057684,10560342,10560343,10560344,10560345,10560346,10560347,10560348,10560349,10560350,10560351,10560368,7057741,10609272,10560447,10560448,10560449,10560450,10560451,10560452,10560453,10560454,7057821,7057822,10609325,10609388,7057906,7057926,7057927,7057931,7058237,10561007,7058465,10561113,10561114,10561115,10561116,10561117,10561118,10561119,10561120,10561121,10561122,10561123,10561124,10561125,10561126,10561127,10561128,10561129,10561130,10610002,10610003,10610004,10610005,10561177,10561178,10561179,10561180,10561181,10561182,10561183,10561184,10561185,10561186,10561187,10561188,10561189,10561190,10561191,10561192,10561193,10561194,10561195,10561196,10561197,10561198,10561199,10561200,10561201,10561202,10561203,10561204,10561205,10561206,10613077,10610094,10610161,10561354,10561355,10561356,10561357,10561358,10561359,10561360,10561361,10561362,10561363,10561364,10561365,10561366,10561367,10561368,10561369,10561370,10561371,10561372,10561373,10561374,10561375,10561376,10561377,10561378,10561379,10561380,10561381,10561382,10561383,10561384,7058748,10561396,10561397,10561398,7058779,7058780,10561427,10561428,10561429,7058792,7058793,7058794,7058795,7058822,7058823,10610323,10561480,10610331,10561481,10610332,10561482,10561483,10561484,10561485,10561486,10561487,10561488,10561489,10561490,10561491,10561492,10561493,10561494,10561495,10561496,10561497,10561498,10561499,10561500,10561501,10561502,10561503,10561504,10561505,10561506,10561507,10561508,10561509,7058887,7058889,7058893,7058898,10564833,10564838,10564839,10564843,10564845,10564847,10564856,10564858,10564866,10564867,10564868,10564872,10564874,10564875,10564876,10564878,10564879,10564880,10564885,10564886,10564887,10564888,10564889,10564890,10564891,10564892,10564893,10564894,10564895,10564903,10564904,10564905,10564906,10564907,10564911,10564912,10564913,10564914,10564916,10564919,10564921,10564927,10564928,10564929,10564930,10564931,7059287,10610791,10564946,10564948,10564949,10564950,10564951,10564952,10564953,10564954,10564960,7059313,10564961,10564962,10564963,10564967,10564973,10564975,10564976,10564977,10564978,10564979,7059334,7059341,10564997,10564998,10564999,7059353,10565001,10565002,10565007,10565008,10565009,10565010,10565011,7059365,10565012,7059366,10565013,7059367,10565014,7059368,7059369,7059370,7059371,10565020,10565021,7059376,10565023,7059377,10565024,10565025,10565026,10565027,7059381,10565028,10565029,10565030,10565031,10565032,7059386,10565033,7059387,10565034,7059388,10565035,10565036,7059393,7059394,7059395,10565042,7059396,7059397,7059398,7059401,7059402,7059403,7059406,10517143,10517144,10513246,7055695,7055696,7055784,7055800,10515452,7055840,7055850,7055862,7055865,7055882,7055883,10517535,10515683,10515684,10515685,10515686,10515687,10515688,10515689,10515690,10515691,10515692,10515693,10515694,10515695,10515696,10515697,10515698,10515699,10515700,10515701,10515702,10515703,10515704,10515705,10515706,10515707,10515708,10515709,10515710,10515711,10511734,10515787,10515788,10515789,4974988,4974996,10514015,10516057,10516058,10512562,10512563,10512564,10512565,10516679,10516680,7057115,7057116,10514794,7057169,7057208,7057349,7057439,7057461,7054945,10415791,10415793,10415794,10415796,7055057,7055155,7055186,7055246,7055287,7055443,4971248,4971249,4971250,4971251,4971252,4971280,4971281,4971282,8916476,8916477,8916795,8563199,8563201,8563202,8563240,8563241,8563250,8563251,8563252,8563299,8563309,8563319,8563354,8563357,8563448,8917664,8917671,10628450,10628451,10628453,10628471,10628742,10628743,10628745,10628762,10628763,10628768,10628773,10628774,10628784,10628810,10632212,10627216,10627217,10627321,10627782,10627783,10627784,10627785,10627786,10630281,10630283,10631368,10626759,10626760,10626766,10626767,10626774,10626775,10626777,10566959,10566960,10567203,10567204,10567660,10567661,10567662,10567663,10522293,10522294,10522295,10522296,10522297,10522298,10522299,10522300,10522301,10522302,10522303,10522304,10522305,10522306,10522307,10522308,10522309,10522310,10520755,10520756,10473656,10473657,10473658,10473659,10473660,10473661,10473662,10473663,10473664,10473665,10473666,10473667,10473668,10473669,10473670,10473671,10473672,10473673,10473674,10473675,10473676,10473677,10473678,10473679,10473680,10473681,10473682,10473683,10473684,10473685,10473686,10473687,10473688,10473689,10473690) 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'