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(11001542,11001543,11001544,11001545,11001546,11001547,11001548,11001549,7075877,11001681,11014697,11001812,7076145,11014829,11014830,11014831,7076158,7076159,11014869,10939967,11001986,11002089,11002090,11002091,11002092,11002093,11002094,11002095,11002096,11002097,4970749,4970750,11002098,11002099,11002100,4970752,11002101,11002102,11002103,4970890,4970911,11015291,11015292,11015293,11002337,11002338,11002339,11002340,11002349,11002350,11002351,11015518,11002525,11002526,11002527,11002528,11002529,11002530,11002533,7073968,11002669,11002670,11002675,11002676,11002677,11002678,11002679,11002680,11002681,11002682,11002683,11002684,7074006,7074141,11002844,11002848,11002849,7074177,7074260,11002956,7074276,11002983,11002984,11002985,11002986,11002987,11002988,11002989,11002990,11002991,7074321,7074322,11003057,11003059,11003060,11003238,11003239,11003240,11003243,11003244,11003245,11003246,11003247,11003248,11003249,11003250,11003251,11003252,11003253,11003254,11003255,11003256,11003257,11003258,11003259,11003260,11003261,11003262,7066599,11003300,11003301,11003302,10990313,10990338,10990339,10990351,10990352,11003404,11003405,11003406,11003409,11003410,10961551,10961552,10961553,10961554,10961555,10961556,10961563,7066918,7074923,7074965,7074968,11013683,10961696,7075016,7075017,11013805,11013807,7075146,10961848,10961849,10961880,10987915,10987916,10987917,10987919,10987971,10987972,10987998,10988074,10988075,11014096,11014097,11014107,11014108,11014109,11014110,11014289,11014290,11014294,11014295,11014296,11014297,11014298,11014299,11014362,11014363,11001464,11001465,10985520,10985521,10985522,10985523,10972748,7072191,10972962,10931775,7072512,7072514,7072530,11012226,7072549,7072551,7072585,7072643,10999364,10999365,10999366,7072683,10999367,10999368,7072684,10999388,10999389,10999390,10999391,10999410,10999411,10999412,7072778,10932253,7072836,7072837,7072841,8065922,10999590,10999591,10999592,10999593,10999594,10999595,10999596,10999597,10999598,10999599,10999600,7072928,7072930,7072931,8066003,11012713,11012714,11012715,10960813,10960814,10960815,10960816,11013167,11013174,11013175,11013176,11013177,11013178,10961344,10961345,10961346,10961347,10961348,10961349,10961350,11013402,10961411,8860931,7071081,8861094,7071203,8861107,8861121,10972171,10972172,10972173,10972174,10972175,10972176,10972177,10972178,10972179,10972183,10972186,10959233,10985338,10985339,10972413,7071731,6000085,6000086,6000087,6000088,10969520,10969521,10969522,10969523,10969524,10969525,10969526,10969527,10969528,10969529,10969530,10995562,10995563,3655572,3655573,3655574,3655582,3655583,3655584,10970059,10970200,7069696,11009530,10970594,10970595,10996618,10996619,8072901,8072902,8072903,8072904,8072905,8072906,8072907,8072908,10996766,10970808,10970809,10970818,10970819,10970976,10997027,10997028,10997029,10997030,10997135,10997136,10997137,10997138,10997139,10971178,10971220,10971221,10971222,10971223,10971224,10971225,10971226,10997258,10997259,10997260,10942291,10997261,10997266,10997267,7070628,7070630,10997337,10997338,10997339,10997340,10997341,10997342,10997343,10997345,10997387,10997388,10942422,10997391,11006568,10618030,10618031,10618032,10618033,10967578,10618053,10618054,10918621,10918622,11006678,11006679,10618164,10618165,10918682,10918683,11006714,11006715,10918725,11006765,11006766,10623357,10919077,11007185,10919384,10919385,10919386,10994616,10994617,10994621,10994622,10994623,10994624,10994732,10994733,10994734,10919735,10994776,10994854,10994857,10995039,10995159,10995162,10995163,10995203,10920346,10920347,10969489,10969490,10969491,10624954,10624958,11005619,11005621,11005622,10917595,10917596,11005625,11005626,11005627,11005732,11005771,10917824,10917825,10917826,10617517,10918082,10918083,11006130,10967154,10967155,10928140,11006343,11006344,11006345,11006346,10918427,10918428,10617958,11003534,11003537,11003538,11003539,11003540,11003541,11003621,11003622,11003623,11003624,11003625,10620130,10620131,11003737,11003738,11003739,11003740,11003741,10920715,10620306,11003895,11003896,11003987,11003988,11003989,11003990,10926001,10926002,10926003,10926004,10991038,10991039,10991040,11004073,10620654,10620655,10620656,10620657,10620658,10620659,10620660,11004234,11004235,10926265,10926266,11004409,11004410,11004411,11004422,10921441,10921442,10921443,11004493,10916508,10916509,10916510,10916511,10916512,10916513,10916514,10916515,10916516,11004586,11004587,11004591,11004592,11004593,10921568,10991658,10991659,10921636,10921637,10921638,10921639,10921640,10921641,10921642,10921643,10921644,10921645,10921646,10921647,10921648,10921649,10921650,10921651,10921652,10921653,10921654,10921655,10921656,10921657,10991686,10921658,10921659,10921660,10921661,10921662,10921663,10921664,10921665,10921672,10921673,10921815,10921816,11004970,11004971,11004972,11004973,11004974,11004975,11004983,11004984,10921960,11004995,11004997,11004998,11004999,11005000,11005001,11005002,10917005,10616546,10927060,10927256,10966321,10966322,10966323,10616790,11005395,11005396,11005397,11005398,11005399,11005400,11005401,11005409,11005410,11005411,11005417,11005418,11005423,11005424,11005425,11005426,9173785,10611649,10562969,10562970,10562971,10562972,10562973,10562974,10562975,10562976,10562977,10614829,9166184,8864730,9171375,8861926,7057639,10557616,9171869,9172023,7058284,7058299,9172140,10609937,10609938,9172382,9172390,7058708,10613343,8863239,10613773,10610816,10610958,10517234,10517235,10517236,10517237,4974376,4974377,4974548,9170025,9170026,9170027,9170028,10555877,10555878,10555879,10555880,10555881,10555882,10555883,10555884,10555885,10555886,10555887,10555888,7056250,7056251,7056252,7056253,7056254,7056255,4975118,7056480,10556148,10556149,10556150,10556151,9171053,10516993,9171215,10517038,9176553,10418583,10418584,9176683,9176688,4973553,4973554,9176789,9176790,10418771,9176893,9176903,9176904,9176905,9176906,9169008,9177158,9177159,9177160,9177161,9177162,9177163,9177164,9177165,9177166,9177167,9177168,9177169,9177170,9177171,9177172,9177173,9177174,9177175,9177176,9177177,9177178,9177179,9177180,9177181,9169272,10463003,10463030,10463032,10463033,10467113,10467142,9174598,4971476,9174753,9174754,10463400,10463401,10467443,6666928,10463728,10463730,8916802,10463738,10463740,10463760,10463761,10465767,10465768,10465780,10465784,9175262,10470114,9175660,6667666,8917397,10462401,10462402,10462408,6667856,10462452,10462453,9168071,10462726,10462727,10466847,10466848,10466852,10466853,10628063,10628087,10164688,10164689,10164690,10164693,10164694,10164695,10164696,10164697,10164828,10164829,10628331,10628332,10165105,10165289,10165292,10165293,10165294,10165794,10165795,10165886,10165896,10171048,10629544,10166134,10166204,10166363,10629852,10629853,10629854,10629855,10629856,10629857,10629858,10629859,10629860,10629861,10629862,10629863,10629864,10629865,10629866,10629867,10629886,10629887,10153852,10163876,10163877,10154012,10627917,10166492,10166493,10629981,10630011,10630090,10630105,10161773,10166957,10166958,10166959,10166960,10166961,10166990,10167113,10162550,10162574,10162575,10162576,10631251,10574157,10574158,10571159,10571160,10577251,10577252,10577253,10571335,10571336,10571570,10571571,10571572,10571576,10568796,10574828,10568915,10568959,10575027,10575028,10575029,10575030,10572058,10572059,10572060,10572061,10572062,10575293,10575294,10575295,10575296,10575297,10575298,10575299,10575300,10575301,10575302,10572340,10572341,10572385,10572386,10569448,10569449,10569450,10569451,10569452,10569453,10569454,10575497,10575498,10575499,10575500,10575501,10575502,10575503,10578561,10578562,10575608,10572778,10578822,10578823,10578824,10578825,10578826,10578827,10578828,10578829,10578830,10578831,10578832,10578833,10578834,10578835,10578836,10578837,10578838,10578839,10578840,10578841,10578842,10578843,10578844,10578845,10578846,10578847,10578848,10578849,10578850,10578851,10578852,10578853,10578854,10578855,10578856,10578857,10578858,10578859,10578860,10578971,10578980,10578981,10578982,10578983,10578984,10570002,10570003,10570004,10570005,10570006,10576024,10576025,10576026,10576027,10570199,10570200,10570201,10570202,10570203,10570204,10570370,10570371,10570372,10570373,10570857,10570858,10570859,10576859,10570860,10576860,10570861,10576861,10570862,10576862,10570863,10576863,10570864,10576864,10570865,10576865,10570866,10576866,10570867,10576867,10570868,10570869,10570870,10570871,10570872,10570873,10570874,10570875,10570876,10570877,10570878,10570879,10570880,10570881,10570882,10570883,10570884,10570885,10570886,10570887,10570888,10577028,10523710,10523711,10523712,10523713,10523714,10523715,10523716,10523717,10523718,10523719,10523720,10523721,10523722,10523723,10523724,10523725,10521925,10520145,10520146,10524861,10526942,10526943,10423706,10472985,10472986,10472988,10477449,10476836) 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'