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(8068854,8068855,8068856,7075977,7076165,11001853,4970661,4970662,4970663,4970664,4970665,10940092,8839046,11015261,11015262,11015263,11015264,11015265,11015266,11015267,10989336,11028375,11028376,10950362,10950363,10950364,10950365,10950366,10950367,10950368,10950550,10950551,7074016,7066222,7074356,7074357,7074366,7074367,7074368,10437234,11042510,11042511,11042512,8837550,8837551,7075323,4969563,4969564,4969565,4969566,4969567,10939181,10939182,10939183,8838261,11014472,8838292,10962555,10962556,10962557,10962558,10962559,10962560,10962577,8065182,8065183,10931739,10931898,10931899,10931904,10999576,10999577,10932275,11012688,11012689,11012690,11012691,11012692,11012693,11012694,11012695,11012696,11012697,8066127,11025897,11025898,11025899,11025900,7065434,7065435,7065436,10932813,10932969,10932970,10932984,10932985,10932986,10932987,10932988,10932989,11013388,11013389,11013434,11036768,7071131,7071139,7071141,10942778,10942779,11049183,11036969,11036970,11037008,10959024,10959025,10959026,10959027,10959028,10959029,10959030,10959031,10959032,10959033,10959034,10959035,10959036,10959037,10959038,10959039,10959040,10959041,10959042,10959043,10959044,10959045,10959046,10959047,10959048,10959049,10959050,10959051,10959052,10959053,10959054,10959055,10959056,10959057,10959058,10959059,10959060,10959061,10959062,10959063,10959064,10959065,10959066,10959067,10959068,10959069,10959070,10959071,10959072,10959073,10959074,10959075,10959076,10959077,10959078,10959079,10959080,10959081,10959082,10959083,10959084,10959085,10959086,10959112,11037234,11037235,11037236,11037237,11037238,5999965,5999969,8970208,10959567,6000171,6000172,6000173,6000174,6000175,6000176,6000177,6000178,6000179,6000180,6000181,6000182,6000183,3655596,3655597,3655598,3655599,3655600,3655601,3655678,3655679,3655680,11008972,11008973,11008974,11008975,11008976,11008977,11008978,11008979,11008980,11009236,8564310,3656338,3656339,3656340,3656341,11009539,11009767,11009768,11009769,11035871,11035872,3656931,3656932,11036176,11010321,10971433,10971434,7070773,10997528,11032832,11032833,11032834,11006969,11006970,11006971,11006972,11006973,11006974,10618327,10623353,10623447,11007227,10994405,10994406,10994960,11008182,11008209,11008210,11008211,11008212,11008213,10922506,10922507,10922508,10922509,10922510,10922511,10922512,10922513,10922514,10922517,11005822,11005823,11005948,11005949,11006014,10928002,10928003,10928004,10928078,11006328,11032616,11032617,11032618,10990810,10990811,10990812,10620172,10615327,10615329,10615330,10991028,10991029,10991030,10991031,10991032,10615491,10615524,11030338,11030339,11030340,11043356,11043357,11043358,11043359,11043360,11043361,11004407,10615820,10615910,10916428,11017751,11017752,11017753,11017754,11017755,11017756,11017757,11017758,11017759,11004967,11004968,10926915,10926916,10992165,10992166,10992167,10992168,10992169,10992170,10992171,10992172,10953187,10922078,10927235,10927236,10927237,10927238,11005392,10922272,10922273,10922274,10922275,10922276,10922282,10922301,10922345,10562174,9205376,9205377,9205378,9205397,9205398,9205399,9205400,9205401,9205402,9205403,9205404,9205405,9205406,9197436,9197437,9197438,9197439,10565324,10565325,10565326,10565327,9173551,9173552,9173553,9173554,7059732,10559439,9197674,9197677,9197678,9197697,8864330,10559628,10559668,10559669,10559670,10559671,9197862,8864489,6665994,6665995,9198055,9198062,9166086,9166087,9166088,9166089,9166090,9166091,9166092,9166093,9166094,9166095,9166096,9166097,9166098,9166119,9166120,9166121,9166122,9166123,9166124,9198211,9190243,9198248,9190254,9174260,10611979,10612203,10563357,10563358,10563359,10563360,10563361,10563362,10563363,10563364,10563365,9171611,10609304,10609331,10612344,9171732,10612543,10563697,10563701,10563702,10563703,10563704,10563705,10563706,10563707,10563708,10563710,10563711,10563712,10563713,9172068,10612782,9172128,10563962,10609840,8862703,10561004,10561005,10561006,7058390,7058391,7058392,10558064,7058418,10558065,10558066,10558067,10558068,10558069,10558070,10558071,10558072,10558073,10558074,10558075,10558076,10558077,10558078,10558079,10558080,10558081,10558082,10558083,10558084,10558085,10558086,10558087,10558088,10558089,10558090,10558091,10558092,10558093,10558094,10558095,10558096,10558097,10558098,10558099,10558100,10558101,9196288,9196289,10558102,9196290,10558103,9196291,10558104,9196292,10558105,9196293,10558106,9196294,10558107,9196295,10558108,9196296,10558109,10558110,10558111,10558112,10558113,10558114,10558115,10558116,10558117,10558118,10558119,10558120,10558121,10558122,10558123,10558124,10558125,10558126,10558127,10558128,10558129,10558130,10558131,10558132,10558133,10558134,10558135,10558136,10558137,10564137,10558138,10564138,10558139,10558140,10558142,10564162,10564163,10564186,10564187,9172384,10564198,9196454,10613154,8863084,10613299,7058836,10613368,10561535,10561587,10561596,10558601,10610479,10610480,10610481,9196821,10561697,9204939,10561909,10561910,10561911,9197112,10562062,10562063,10562064,10562065,10562066,10562067,10562068,10562069,9205272,9205273,10610955,4974233,4974535,4974536,9193689,9161695,9161696,9161697,9193748,7055946,4974685,4974745,4974746,4974747,9185958,9193974,9185983,10515820,10515821,10515822,10513834,10513835,10513836,10513837,10513838,10513839,10513840,10513841,10513842,10513843,10513844,10513845,10513846,10513847,10513848,10513849,10513850,10513854,10513855,10513856,10513857,10513858,10513859,10513860,10513861,10513862,10513863,10513864,4975054,4975055,4975056,4975057,4975058,4975059,10518601,10518602,10518603,10518604,7056964,9203118,9168309,9168395,10418532,10416563,10416564,10416630,10416631,10415633,10416877,9168967,10416899,9169007,4973925,4973926,7055297,10419189,9174737,9174738,10467464,10467465,9191242,9175259,8916985,10463953,10463954,10463955,9183473,9183474,9183475,9183486,10470066,10470072,9167545,10466282,10466283,10466284,10466285,10466286,10466287,10466288,10466289,10466290,10466291,10466292,10466293,10466294,10466295,10466296,10466297,9167783,9167784,9167785,9167786,8917506,10468519,9167945,9175956,9175957,9167988,9175995,10628203,10628204,10628205,10628206,10174901,10174914,10159914,10174915,10159915,10628423,10628472,10628473,10628474,10628475,10628476,10628477,10628478,10628524,10175162,10175168,10178735,10178736,10178737,10178738,10178739,10178740,10178741,10627665,10166489,10166490,10630087,10630104,10630244,10630245,10630287,10176821,10176822,10176823,10176824,10176825,10176826,10176827,10176828,10176829,10176830,10176831,10176832,10176833,10176834,10176835,10176836,10176837,10176838,10176839,10176840,10176841,10176842,10176843,10176844,10176845,10176846,10176847,10176848,10176849,10176850,10176851,10176852,10176853,10176854,10176855,10176856,10176857,10176858,10176859,10176860,10176861,10176862,10176863,10176864,10176865,10176866,10176867,10176868,10176869,10176870,10176871,10176872,10176873,10176874,10176875,10176876,10176877,10176878,10176879,10176880,10176881,10176882,10176883,10176884,10176885,10176886,10176887,10176888,10176889,10176890,10176891,10176892,10176893,10176894,10176895,10176896,10176897,10176898,10176899,10176900,10176901,10176902,10176903,10176904,10176905,10176906,10176907,10176908,10176909,10176910,10176911,10176912,10176913,10176914,10176915,10176916,10176917,10176918,10176919,10176920,10176921,10176922,10176923,10176924,10176925,10166925,10176926,10176927,10176928,10176929,10176930,10176931,10176932,10176933,10176934,10176935,10172085,10172290,10172291,10172292,10172293,10172294,10626143,10626144,10172793,10172794,10172795,10172894,10580208,10580271,10580272,10580273,10580274,10580275,10580276,10580277,10580278,10580279,10580280,10580281,10580290,10580291,10580393,10580394,10580395,10580396,10580397,10580398,10580399,10580400,10580401,10580402,10580403,10580404,10580405,10580441,10580442,10580443,10580444,10580445,10580446,10580447,10580448,10580449,10580450,10580451,10580452,10580453,10580454,10580455,10580456,10580457,10580458,10580459,10580460,10580461,10580462,10580515,10586942,10586943,10586944,10586945,10586946,10586947,10572056,10569429,10569430,10569431,10569432,10569433,10569624,10581908,10581909,10575920,10570189,10570190,10570191,10585191,10570192,10568007,10568008,10568009,10568010,10568011,10568012,10568013,10568014,10568015,10568016,10568017,10568018,10568019,10568020,10568021,10568022,10568023,10568024,10568025,10527129,10527130,10527131,10527132,10527133,10527134,10527135,10527136,10520137,10528356,10522524,10522660,10527021,10423241,10423244,10423266,10423277,10423281,10423284,10421431,10424452,10424720,10424721,10424722,10424723,10424724,10424725,10424726,10424727,10423746,10423747,10423206,10423207,10423211,10474083,10474084,10474085,10474086,10474087,10474088,10474095,10474096,10474097,10474098,10472488,10472764) 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'