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(7201622,7201683,8595130,8595131,7201750,7201751,7201752,7201753,7201754,7201755,7201756,7201757,7201758,8595204,10858947,5654582,5654637,5654638,9794574,9794575,9794576,9794577,9794587,9794588,7066143,10860537,10860538,10860539,10860540,10860541,10860542,7200591,7200592,7200593,7200594,7200595,7200596,7200597,10857684,10857685,10857686,10857687,10857688,10857689,10857690,10857691,10857692,10857693,10857694,7200661,7201250,7201257,7201258,7201259,7201260,7201261,7201262,7201263,7201264,7201265,7201585,7201586,7201587,7201588,10195135,8625103,8909073,8909074,7199300,7199301,7199302,7199303,7199304,7199305,7199306,7199307,7199308,7199309,7199310,7199311,7199312,7199313,10856361,10856362,7199529,7199535,7199538,10101489,10101548,10101549,10856984,10856985,10857244,10857245,10857246,10857247,10857248,10857249,10857251,10857252,10857253,10857254,10857255,10857256,10857257,7200282,10857380,10857381,10857382,10857383,10857384,8910162,7200386,7200387,7200388,7200441,7200442,7200443,7200444,7200445,7200446,7200447,7200448,7200449,7200450,7200451,7200452,7200453,8834755,7198421,10855515,10865668,10865693,10865694,10865695,8905714,8905899,8905900,8905901,8905902,8905903,8905904,8905905,3923593,10866506,10866507,10866508,10866509,10866510,10866511,7196480,8554330,7197020,8906840,8906841,8906842,8906843,8906844,8906845,8906846,8906847,8906848,8906910,8860400,10854349,10838885,10850789,3581911,10426009,10426446,10426461,10426462,10426463,8611420,8634290,7155288,8634410,8905332,10616987,10616988,10616989,10616990,10617072,10862801,10862802,10862803,10862806,10862821,10862822,10862823,10862824,10862825,10862834,10862837,10862847,10862865,10862866,10862877,10862895,10622268,10862981,10622360,10617379,10863217,10863234,10863235,10863236,10863237,10860692,10615327,8630430,8630431,8630432,8630433,10278851,10861470,10861471,10861472,3228954,3228960,3228961,10861934,10861937,10861939,10861941,10861943,10861946,10861988,10862000,10862227,10862228,10862229,10862230,10862231,10862232,10862233,10862234,10862235,10862236,10862237,10862238,10862239,10862240,10862241,10862242,10862243,10862244,10862245,10862246,10616576,10862247,10862248,10862249,10862250,10862251,10862252,10862253,10862254,10862255,10862256,10862257,10862258,10862259,10862260,10862261,10862262,10862263,10862264,10862265,10862266,10862267,10862268,10862269,10862270,10862271,10862272,10862273,10862274,10862275,10862276,10862277,10862278,10862279,10862280,10862281,10862282,10862283,10862284,10862285,10862286,10862287,10862288,10862289,10862290,10862291,10862292,10862293,10862294,10862295,10862296,10862297,10862298,10862299,10862300,10862301,10862302,10862303,10862304,10862305,10862306,10862307,10862308,10862309,10862310,10862311,10862312,10862313,10862314,10862315,10862316,10862317,10862318,10862319,10862320,10862321,10862322,10862323,10862324,10862325,10862326,10862327,10862328,10862329,10862330,10862331,10862332,10862333,10862334,10862335,10862336,10862337,10862338,10862339,10862340,10862341,10862342,10862343,10862344,10862345,10862346,10862347,10862348,10862349,10862350,10862351,10862352,10862353,10862354,10862355,10862356,10862357,10862358,10862359,10862360,10862361,10862362,10862363,10862364,10616789,10614408,10614409,10614572,10614592,10614747,10614748,10614749,10614750,10614751,10614752,10614753,10614754,10614755,10614756,10614757,10614758,10614759,10614760,10614761,10614762,10614763,10614764,10614765,10614766,10614767,10614768,10614769,10614770,10614771,10614772,10614773,10614774,10614775,10614776,10614777,10614778,10614779,10614780,10614781,10614782,10614783,10614784,10614785,10614786,10614787,10614788,10614789,10614790,10614791,10614792,10614793,10614794,10614795,10614796,10614797,9166135,10614798,10614799,10614800,10614801,10614802,10614803,10614804,10614805,10614806,10614807,10614808,10614809,10614810,10614811,10614812,10614813,10614814,10614815,10614816,10614817,10614818,10612381,10612501,10612505,10612528,10612530,10612532,10612568,10612575,10612577,10612578,10612619,10612652,10612675,10612677,10612713,10612714,10612715,10612850,10612852,10612856,8566718,8566719,10612943,10612958,10613036,10613065,8852256,8852257,8852258,8852259,8852260,8852261,8852262,8852263,8852264,8852265,8852266,8852267,10613570,10613571,10613572,7015009,7015010,9169357,7015011,9169358,7015012,9169359,7015013,9169360,7015014,9169361,7015015,9169362,7015016,9169363,7015017,7015018,9169364,7015019,9169365,7015020,9169366,7015021,7055533,9169367,7015022,9169368,7015023,7015024,6673576,7015025,7015026,7015027,7015028,7015029,7015030,7015031,7015032,7015033,7015034,7015035,7015036,7015037,7015038,7015039,7015040,7015041,7015042,7015043,7015044,7015045,7015046,7015047,7015048,7015049,7015050,7015051,7015052,7015053,7015054,7015055,7015056,7015057,7055665,7055666,6673767,6673768,10118050,9169878,10118124,10118125,9912167,9912168,9912169,9912170,10118278,10118279,10118280,10118495,10118500,9912574,9912575,9912576,9912866,9912867,9912868,9912869,9912870,9912871,9912872,9912873,9912874,9912875,9912876,9912877,9912878,9912879,9912880,9912881,9913051,9913052,9913053,9913054,9913055,9913056,8552180,8552190,9913154,9168310,10416364,10416365,10416366,10416369,10416383,10416384,10416385,10416386,10416387,10416397,10416400,10416405,10416411,10416429,10416431,10416432,10416435,10416443,10419450,10419451,10419452,10419453,10419454,10419455,10419456,10419457,10416463,10416536,10416546,10416772,9168928,10418888,10418914,10418915,10418916,10418917,10418918,10418919,8549935,8550115,8550116,8550117,8550118,8550119,10469678,10469679,10469680,10469681,10469682,10469683,10469684,10469685,10469686,10469687,10469688,10469689,10469690,10469691,10469692,10469693,10469694,10469695,10469696,10469697,10469698,10469699,10469700,10469701,10469702,10469703,10469704,10469705,10469706,10469707,10469708,10469709,10469710,10469711,10469712,10469713,10469714,10469715,10469716,10469717,10469718,10469719,10469720,10469721,10469722,10469723,10469724,10469725,10469726,10469727,10469728,10469729,10469730,10469731,10469732,10469733,10469734,10469735,10469736,10469737,10469738,10469739,10469740,10469741,10469742,10469743,10469744,10469745,10469746,10469747,10469748,10469749,10469750,10469751,10469752,10469753,10469754,10469755,10469756,10469757,10469758,10469759,10469760,10469761,10469762,10469763,10469764,10469765,10469766,10469767,10469768,10469769,10469770,10469771,10469772,10469773,10469774,10469775,10469776,10469777,10469778,10469779,10469780,10469781,10469782,10469783,10469784,10469785,10469786,10469787,10469788,10469789,10469790,10469791,10469792,10469793,10469794,10469795,10469796,10469797,10469798,10469799,10469800,10469801,10469802,10469803,10469804,10469805,10469806,10469807,10469808,10469809,10469810,10469811,10469812,10469813,10469814,10469815,10469816,10469817,10469818,10469819,10469820,10469821,10469822,10469823,10469824,10469825,10469826,10469827,10469828,10469829,10469830,10469831,10469832,10469833,10469834,10469835,10469836,10469837,10469838,10469839,10469840,10469841,10469842,10469843,10469844,10469845,10469846,10469847,10469848,10469849,10469850,10469851,10469852,10468232,976442,976476,976552,10468518,9168087,10888829,10883982,10883983,10628745,10628746,10628768,10628769,10628770,10628771,10628784,10628785,10884543,10884544,10889648,10889882,10889883,10889884,10889885,10889886,10889887,10889888,10889889,10889890,10889891,10887508,7000847,10887712,10887713,10887714,10887715,10887716,10887717,10887718,10887719,10887720,10887721,10887722,10887723,10887724,10887725,10887726,10887727,10887728,10887729,10887730,10887731,10887732,10887733,10887734,10887735,10887736,10887737,10887738,10887739,10887740,10887741,10887742,10887743,10887744,10887745,10887746,10887747,10887748,10887749,10887750,10887751,10632254,10632255,10887957,10883249,10883250,10883251,10885519,10885520,10885521,10885522,10885874,10885875,10885876,10885877,10161950,10162131,10162132,10162133,10162238,10911696,10911697,10911742,10911743,10911777,10887190,10887198,10608383,10602445,10608549,10608550,10611736,10611864,10611878,10647622,10609821,10609822,10610372,10604645,10610902,10610903,10610941,10415739,10415741,10415742,10415744,10415923,10415924,10415925,10415926,10415927,10415928,10415929,10415930,10415931,10415932,10415933,10415934,10415935,10415936,10415937,10415938,10415939,10415940,10415941,10415942,10415943,10415944,10415945,10415946,10415947,10415948,10415949,10415950,10415951,10415952,10415953,10415954,10415955,10415956,10415957,10415958,10411407,10411408,10413462,10483195,10483196,10483197,10483198,10483199,10408025,10412035,10412036,10412037,10412038,10412039,10412040,10412041,10412042,10412043,10412044,10412045,10410086,10412136,10412137,10412138,10412139,10410681,10414818,10414819,10414820,10414821,10414822,10414823) 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'