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(10939711,10939712,10939737,10939738,10939739,10939740,10939741,10939742,10939874,7076287,7068300,10940343,10940345,7068782,7068783,7068784,7068785,7068786,7068787,7068788,7068789,10963487,8066960,8066961,10933334,10963633,7074262,7066567,8067639,8067640,8067641,8067642,8067643,8067644,8067651,8067652,8067653,10977418,10977419,10977420,10977421,10977422,10977423,10977424,10977425,8068035,8068180,8068188,10961953,7067278,7067279,8068266,7075289,7075290,10962094,10962095,10962096,8068413,8068415,7075482,7075483,10975350,10975351,10975352,10975353,10975354,10959562,10972582,10972620,10972623,10972629,10972630,10972670,10972673,7072300,10973059,10973060,10973061,10973062,10973073,10973180,4967028,10932190,10932192,10932193,10932194,10960513,8065917,10960761,8066429,8066430,10932845,8066512,10971560,7071054,10971762,10942928,10942929,10942930,10942937,10942938,10942939,10942940,10942941,10971996,10959087,8861319,8861320,8861321,8861322,10943147,10943148,10943149,8861337,8861338,8861339,10943184,10972280,10972294,7071645,7071688,7071701,7071702,10940724,10940725,7069012,3656451,3656452,3656453,3656454,3656455,3656456,3656470,3656632,3656661,3656669,3656720,3656721,3656736,7070105,3656888,10971175,8860565,7070756,10923638,10923639,10923640,10923641,10923642,10923643,10923644,10923645,10923646,10923647,10923648,10923649,10923650,10923651,10923652,10923653,10923654,10923655,10923656,10918657,10923657,10918658,10923658,10923659,10923660,10923661,10923662,10923663,10923664,10923665,10923666,10923667,10923668,10923669,10923670,10923671,10923672,10923673,10923674,10923675,10923676,10923677,10923678,10923679,10923680,10923681,10923682,10923683,10923684,10923685,10923686,10923687,10923688,10923689,10923690,10923691,10923692,10923693,10923694,10923695,10923696,10923697,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,10954781,10918838,10918839,10918840,10918841,10918842,10918843,10918844,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923885,10923886,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10923896,10923897,10923898,10923899,10923900,10923901,10923902,10923903,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10923923,10923924,10923925,10923926,10923927,10923928,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10923939,10923940,10924107,10924108,10924109,10924110,10924111,10924112,10924113,10924114,10924115,10924116,10924117,10924118,10924119,10924120,10924121,10924122,10924123,10924124,10924125,10924126,10924127,10924128,10924129,10924130,10924131,10924132,10924133,10924134,10924135,10924136,10924137,10924138,10924139,10924140,10924141,10924142,10924143,10924144,10924145,10924146,10924147,10924148,10924149,10924150,10924151,10924152,10924153,10924154,10924155,10924156,10924157,10924158,10924159,10924160,10924161,10924162,10924163,10924164,10924165,10924166,10924167,10924168,10924169,10924170,10924171,10924172,10924173,10924174,10924175,10924176,10924177,10924178,10924179,10924180,10924181,10924182,10924183,10924184,10924185,10924186,10924187,10924188,10924189,10924190,10924191,10924192,10924193,10924194,10924195,10924196,10924197,10924198,10924199,10924200,10924201,10924202,10924203,10924204,10924205,10924206,10924207,10924208,10924209,10924210,10924211,10924212,10924213,10924214,10924215,10924216,10924217,10924218,10924221,10924222,10924223,10924224,10924225,10924226,10924227,10924228,10924229,10924230,10924231,10924232,10924233,10924234,10924235,10924236,10924237,10924238,10924239,10924240,10924241,10924242,10924243,10924244,10919244,10924245,10919245,10924246,10919246,10924247,10919247,10924248,10919248,10924249,10919249,10919250,10618772,10619016,10619017,10619358,10920084,10920085,10920086,10920087,10920088,10920089,10920090,10920091,10920092,10920093,10920094,10920095,10920096,10619894,10917474,10917475,10927480,10917483,10917484,10621979,10927491,10927492,10927493,10927494,10922700,10922701,10922702,10922703,10922704,10922705,10922706,10922707,10922708,10922709,10922710,10922711,10922712,10922713,10922714,10922715,10922716,10922717,10922718,10922719,10922720,10922721,10922722,10922723,10922724,10917858,10917870,10917871,10622364,10918021,10918022,10918023,10617573,10918151,10918152,10918153,10918154,10954255,10915629,10915630,10915631,10915632,10915633,10915634,10915635,10915636,10915637,10915638,10915639,10915640,10915641,10915642,10915643,10915644,10915645,10915646,10915647,10915648,10915649,10915650,10915651,10915652,10915653,10915654,10915655,10915656,10915657,10915658,10915659,10915660,10915661,10915662,10915663,10915664,10915665,10915666,10915667,10915668,10915669,10620385,10615445,10921036,10921042,10921043,10921046,10921049,10921065,10921075,10921076,10921077,10921084,10926085,10926086,10926087,10921091,10926097,10921104,10921120,10921127,10921128,10921140,10921145,10926170,10926171,10921171,10926184,10926185,10921190,10926281,10926282,10926283,10926358,10965552,10952892,10952893,10621390,10621396,10917001,10616544,10917057,10917058,10917059,10917060,10917061,10917062,10917063,10917064,10917065,10621573,10621574,10621719,10922308,10922309,10922310,10953448,10922465,10922469,10559296,10559339,10614271,10614317,10611405,10611444,10614451,10611452,10611478,10611486,10614495,10611513,10611566,10611567,10614744,8864732,8864808,10557476,10557477,10557478,10557479,10557480,10557481,10557482,10557483,10557484,10557549,10609715,10609716,10609841,8862767,10612917,10612918,10612919,10612920,8862823,8862855,8862856,8862857,8862858,8862859,8862860,8862861,8862862,10613042,10613066,10613099,10613106,10613108,10613110,10613111,10613115,10613116,10613176,7058694,10610193,10610271,7058854,7058855,7058856,7058857,7058858,7058859,7058860,7058864,7058865,7058866,10558669,10558682,10613745,10613772,10610791,10515113,10515114,4974180,7055530,10513249,4974291,4974293,4974294,4974295,4974296,4974297,10513287,10513294,10513299,10513300,10513301,10513302,10513303,10515336,4974440,4974441,4974442,4974443,4974444,4974445,7055963,10517682,10517683,10517684,4974832,4974833,4974834,4974835,4974836,4974837,4974838,4974839,4974840,4974841,4974842,4974843,4974844,4974845,4974846,4974847,4974859,4974860,4974861,4974865,4974866,4974867,4974868,4974869,4974870,4974871,4974872,4974873,4974874,4974875,4974876,4974877,4974878,4974879,4974880,10516142,10514489,10514490,10514491,10514508,10514509,10514510,10514533,10514534,10514535,10514536,10514537,10514538,10514539,10514540,10514547,10514548,10512559,10514560,2809382,7056927,7056953,7057027,7057028,7057029,7057030,7057031,7057032,7057033,7057034,10512768,10512769,10512770,10513109,10513110,10513111,10418233,10418236,10418264,10416271,10417342,10415484,10415485,10415486,10417554,10417556,10417742,10415882,10420110,10417156,10468884,8864868,8864913,8864923,8864924,8864925,8864926,8864927,8864928,8864952,8864974,10463031,10467108,10467110,10467132,10467145,8865170,10463396,10463398,10463432,10467435,10467438,10469573,4971948,10465689,10465697,10469731,10463732,10463752,10463757,10463758,10463769,10465781,10465783,10465799,10469808,10463823,10465823,10465826,10465827,10465887,10465895,10465896,10465911,10463919,10463920,8916991,10464007,10464042,8917197,10464209,10466321,10466322,10466325,10466345,10466355,10466356,10466370,10466375,10462432,10466432,10462433,10466433,10462434,10462435,10462437,10466439,10466440,10466444,10462458,10462462,10462463,10462501,10462502,10462503,10462504,10462505,10462510,10462544,10464581,10462598,10462599,10464763,8917912,8917913,10628254,10628400,10156057,10632301,10627680,10627724,10627725,10154381,10630256,10630297,10630298,10630299,10630300,10630301,10630302,10630303,10630304,10630305,10630306,10630310,10630311,10630312,10630313,10630314,10630866,10626442,10571412,10571413,10571414,10568621,10568622,10568623,10568624,10568625,10568626,10568627,10568628,10568629,10568630,10571805,10571806,10571807,10571808,10571809,10571810,10571811,10571812,10571813,10571814,10571815,10568898,10568937,10569034,10569035,10569036,10569037,10569294,10569295,10569296,10569297,10569298,10570099,10570100,10570101,10570102,10570551,10570552,10570553,10570554,10570555,10521852,10522618,10520777,10520863,10520864,10520865,10520866,10520867,10520868,10520869,10520870,10520871,10520872,10520873,10520874,10520875,10520876,10520877,10520878,10520879,10520880,10520881,10520882,10520883,10520884,10520885,10520886,10520887,10520888,10520889,10520890,10520891,10520892,10520893,10520894,10520895,10420427,10420569,10420571,10420583,10420590,10420591,10420592,10473760,10473761) 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'