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(10939570,10939578,10939579,4970270,10939811,10939877,10939878,10939985,10940100,10940168,10940183,10940399,10940400,10940401,10940403,10940404,10940405,10940406,10940407,10940408,10940409,10940410,10940411,10940412,10940413,10940414,10940415,10940416,10940417,10940418,10940419,10940420,10940421,10940422,10940423,10940424,10940425,10940426,10940427,10940428,10940429,10940430,10940437,10940438,10940440,10940441,10940442,10940443,10940444,10940446,10940447,10940468,10940494,10940495,10940496,10940497,10940498,10940505,4968635,8067372,4968668,4968669,8067543,8067778,8067779,8067780,8067781,8067782,8067783,8067784,8067785,8067831,10939381,10939397,10939432,8075321,4967030,4967031,8065966,8066074,8066180,8066181,8066189,8066190,8066191,8066192,8066193,8066194,8066195,8066196,8066197,8066198,8066199,8066200,8066202,8066203,8066204,8066205,8066206,8066207,8066208,8066209,8066210,8066211,8066212,8066213,8066214,8066215,8066216,8066217,8066249,8066250,8066251,8066252,8066253,8066280,8066281,8066282,8066296,8066297,8066298,8066299,8066300,8066301,8066302,8066303,8066318,8066319,8066320,8066321,8066343,8066344,8066345,8066346,8066347,8066348,8066363,8066364,8066365,8066366,8066367,8066400,8066401,8066402,8066403,8066404,8066405,8066406,8066433,8066434,8066435,8066436,8066437,8066438,8066447,8066448,8066449,8066450,8066455,8066456,8066457,8066469,8066470,8066471,8066496,8066497,8066520,8066521,8066522,8066523,8066524,8066525,8066526,8066527,8066528,8066529,8066530,8066531,8066532,8066533,8066534,8066535,4967985,4968121,8970185,8970186,3655610,3655611,3656634,3656699,3656700,3656868,3656869,3656870,3656871,3656872,3656873,3656874,3656875,3656876,3656877,3656878,3656879,3656880,3657268,8073512,8073513,8073521,8073522,8073523,8073524,8073525,8073526,8073545,10623064,10623209,10623210,10623211,10623212,10623213,10623214,10623236,10623237,10623238,10623239,10623240,10623241,10623242,10623243,10623356,10623450,10623491,10623492,10623493,10920345,10622034,10622035,10622036,10622101,10622102,10622113,10622114,10622115,10622363,10622427,10622460,10622461,10917973,10917978,10917979,10917980,10622537,10622538,10622728,10622747,10622748,10622749,10622897,10622901,10619977,10619978,10619988,10619989,10620017,10620034,10620035,10620083,10620108,10620129,10620302,10620325,10620326,10620328,10620329,10620390,10620391,10620392,10620393,10620394,10620395,10620396,10620397,10620398,10620399,10620400,10620401,10620402,10620403,10620404,10620405,10620406,10620407,10620415,10620416,10620417,10620418,10916487,10916488,10916489,10916490,10916491,10916492,10916493,10916494,10916495,10916496,10916497,10916498,10916499,10916500,10916501,10916502,10916503,10916504,10621109,10621110,10621111,10621112,10621113,10621114,10621115,10621116,10621117,10621118,10621119,10621120,10621121,10621122,10621123,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10621131,10621132,10621133,10621134,10621135,10621136,10621137,10621138,10621139,10621140,10621141,10621142,10621143,10621144,10621145,10621146,10621147,10621148,10621149,10621150,10621151,10621152,10621153,10621154,10621155,10621156,10621157,10621158,10621159,10621160,10621161,10621162,10621163,10621164,10621165,10621166,10621252,10621253,10621254,10621255,10621256,10621257,10621270,10621271,10621272,10621277,10621280,10621281,10621282,10621285,10621287,10621322,10621345,10621346,10621347,10621348,10621349,10621350,10621351,10621360,10621361,10621362,10621368,10621369,10621370,10621400,10621401,10621402,10621403,10621404,10621405,10621406,10621407,10621408,10621409,10621410,10621629,10621630,10621643,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621731,10621732,10621733,10621734,10565112,10565113,10565114,10565115,10610965,10565116,10565117,10565118,10565119,10565120,10565121,10565122,10565123,10565124,10565125,10565126,10565127,10565160,10565161,10565162,10565163,10565164,10565165,10565166,10565167,10565168,10565169,10565192,10565193,10565194,10565195,10565196,10565223,10565271,10565272,10565273,10565274,10565275,10565276,10565277,10565297,10565298,10565299,10565300,10611151,10611152,10611153,10611156,10611158,10611159,10611161,10611162,10611163,10565343,10565344,10565345,10611234,10611352,10611764,10565939,10611820,10611826,10611827,10611828,10611829,10611836,10611850,10611851,10611852,10611853,10611859,10611860,10566051,10611912,10611919,10566071,10566072,10566073,10566074,10566075,10566076,10566077,10566078,10611929,10566079,10611930,10566080,10566081,10566082,10563187,10563188,10563189,10563190,10563191,10563192,10563193,10563194,10609104,10609307,10609344,10609345,10563541,10563542,10563543,10563553,10563554,10563555,10563564,10563565,10563566,10563570,10609991,10610006,10610017,10610032,10610189,10610233,10610235,10610237,10610273,10610283,10610285,10610471,10564645,10564646,10564647,10564648,10564649,10564650,10564651,10564652,10564653,10564654,10564655,10564656,10564657,10564658,10564659,10564660,10564661,10564662,10564663,10564664,10564665,10564666,10564667,10564668,10564669,10564670,10564671,10564672,10564673,10564674,10564675,10564676,10564677,10564678,10564679,10564735,10564736,10564737,10564738,10564739,10564740,10564741,10564742,10564743,10564744,10564745,10564746,10564747,10564748,10564749,10564750,10564751,10564752,10564753,10564754,10564755,10564756,10564757,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10564766,10564767,10564768,10564769,10564770,10564771,10564772,10564773,10564774,10564775,10564776,10564777,10564778,10564779,10564780,10564781,10564782,10564783,10564784,10564785,10564786,10564787,10564788,10564789,10564790,10564791,10564792,10564793,10564794,10564795,10564796,10564797,10564798,10564799,10564800,10564801,10564802,10564803,10564804,10564805,10564806,10564807,10564808,10564809,10564810,10564811,10564812,10564813,10564814,10564815,10564816,10564817,10564818,10564819,10564820,10564821,10564822,10564823,10564824,10564825,10564826,10564827,10564828,10564829,10564830,10564831,10610703,10610723,10564991,10564992,10610842,10564993,10565061,10610911,10565062,10610912,10565063,10565064,10565065,10565066,10565067,10565068,10565069,10565070,10565071,10565072,10565073,10565074,10565075,10565076,10565077,10565078,10565079,10565080,10565081,10565082,10565083,10565084,10565085,10565086,10565087,10565088,10565089,10565090,10610947,10610948,10610952,10565109,10565110,10565111,10555112,10555113,10555114,10555115,10555116,10555117,10555118,10555119,10555120,10555121,10555122,10555123,10555124,10555125,10555126,10555127,10555128,10555129,10555130,10555131,10555132,10555133,10555134,10555135,10555136,10555137,10555138,10555139,10555140,10555141,10555142,10555143,10555144,10555145,10555146,10555147,10555148,10555149,10555150,10555151,10555152,10555153,10555154,10555155,10555156,10555157,10555158,10555159,10555160,10555161,10555162,10555163,10555164,10555165,10555166,10555167,10555168,10555169,10555170,10555171,10555172,10555173,10555174,10555175,10555176,10555177,10555178,10555179,10555180,10555181,10555182,10555183,10555184,10555185,10555186,10555187,10555188,10555189,10555190,10555191,10555192,10555193,10555194,10555195,10555196,10555197,10555198,10555199,10555200,10555201,10555202,10555203,10555204,10555205,10555206,10555207,10555208,10555209,10555210,10555211,10555212,10555213,10555214,10555215,10555216,10555217,10555218,10555219,10555220,10555221,10555222,10555223,10555224,10555225,10555226,10555227,10555228,10555229,10555230,10555231,10555232,10555233,10555234,10555235,10555236,10555237,10517238,10555238,10517239,10555239,10517240,10555240,10555241,10555242,10555243,10555244,10555245,10555246,10555247,10555248,10555249,10555250,10555251,10555252,10555253,10555254,10555255,10555256,10555257,10555258,10555259,10555260,10555261,10517564,10517565,10517566,10517567,10517568,10517755,10517756,10518645,10518646,10518647,10556990,10556991,10556992,10556993,10556994,10556995,10556996,10556997,10556998,10556999,10557000,10557001,10557002,10557003,10557004,10557005,10557006,10557007,10557008,10557009,10557010,10557011,10557012,10557013,10557014,10557015,10557016,10557017,10557018,10557019,10557020,10557021,10557022,10557023,10557024,10557025,10557026,10557027,10557028,10557029,10557030,10557031,10557032,10557033,10557034,10557035,10557036,10557037,10557038,10557039,10557040,10557041,10557042,10557043,10557044,10557045,10557046,10557047,10557048,10557049,10557050,10557051,10557052,10557053,10557054,10557055,10557056,10557057,10557058,10557059,10557060,10557061,10557062,10419449,10419681,10419682,10419834,10419835,10419836,10419888,10419889,10419893,10419897,10419898,10419900,10419903,10419906,10419942,10419943,10419994,10419998,10420000,10420002,10420003,10420004,10420006,10420007,10420008,10420011,10420013,10420146,10420166,10420184,10420191,10420198,10420209,10420215,10471538,10471539,10469908,10470536) 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'