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(10198116,10198220,10198256,7068044,10237367,7076139,10237391,10237463,10198532,7076337,7076339,4970826,10237742,10198750,10198751,10198766,10198767,10198768,10198769,10198770,10198771,10198775,10198784,10198798,10198801,10198802,8569558,8569612,7065867,7066179,7074223,7074224,7074235,7074321,7074322,7074323,7074324,10199609,10238708,10199851,10238909,10200005,7066821,10197141,10197142,10197143,10197144,10197145,10197146,10197147,10197148,10197149,10197150,10197151,10197152,8067906,7066959,10223258,10223259,7067080,7075131,7075457,10236711,7067563,7067713,7067724,7067743,7067744,7067776,7067783,10195098,10195099,10195120,7064024,10234262,7064025,7064026,7064027,7064028,7064029,7064030,10234269,10234270,10234289,10234290,10234291,7072083,10234373,10234374,10234375,10234376,10234377,10234378,10234482,10234490,10234491,7064373,7064531,10234839,10234840,10234841,10234895,10235009,10196092,10196120,10196292,10222304,7065457,10222708,10222709,10209730,10209731,10197023,10197060,7070865,7070866,8860942,8860960,7071133,10942911,10194461,10194462,10233707,10233712,10233713,10943253,10943254,10943255,10943256,10943271,10194852,10943400,10231143,10231144,10944495,10193096,10193097,7070060,7070318,10942096,10942097,10942098,10942185,8860620,7070730,7070756,7070819,10229076,10190117,10229161,10229163,10229165,10229166,10229167,10229171,10190188,10203219,10618234,10618258,10928792,10618287,10618289,10618290,10618298,10618300,10618301,10618316,10618321,10230052,10230053,10230054,10230055,10230056,10230111,10204176,10204227,10619146,8070879,10204300,10204301,10204302,10204303,10204304,10204305,10204306,10204307,10204308,10204309,10204310,10204311,10204312,10230347,10230348,10230349,10230362,10230462,10204574,10204575,10230634,10230640,10230641,8071259,8071260,10204678,10624692,10624705,10204885,10624833,10205001,10616995,10622017,10622049,10622050,10622053,10617182,10228408,10617325,10617332,10228447,10617356,10927957,10927964,10927965,10927966,10927967,10927968,10927969,10927970,10927971,10927972,10927973,10927974,10927975,10927976,10927977,10617539,10928062,10228714,10617627,10617630,10622706,10622708,10189828,10189829,10189830,10189831,10189832,10617847,10617848,10617849,10617850,10617851,10617852,10190004,10920483,10920484,10920485,10920501,10920503,10920505,10615102,10615103,10615104,10615105,10615106,10615107,10615108,10615109,10615110,10615111,10615112,10615113,10615114,10615115,10615116,10615127,10615128,10615129,10615130,10615131,10615132,10615133,10615134,10615135,10615152,10615153,10620201,10615202,10615229,10620303,10615352,10200511,8570315,10615552,10620564,10620565,10620566,10620567,10620568,10620569,10620570,10620571,10620572,10615723,10615752,10615755,10616004,10616059,10616064,10621084,10926633,10616156,10930985,10188332,10188455,10201584,10922064,10922079,10201739,10616653,10616654,10616667,10201776,10616836,10616837,10614013,10565186,7059728,8864124,10559477,10559478,9173709,6665759,6665760,6665761,10559571,10559572,10559573,10559585,10559735,10559736,10559737,8864573,8864580,8864606,8864643,8864679,8864685,8864690,9166236,8864760,7057494,10612013,9163452,8862041,7057699,10612190,10612297,10563452,10563457,10563459,10563460,10563461,10563462,10563463,10563464,10563465,9163667,10563489,10612346,10612352,7057883,9171734,7057910,9171913,9171955,10612619,8862643,8862703,10612895,10612896,7058472,7058473,7058474,7058475,7058476,7058477,10613036,10613085,9172459,7058631,9172471,9172493,9172516,10558442,10558443,10558444,10558445,10558446,9164641,10558447,10558448,10558449,10558459,10558460,10558461,10558462,10558463,10558464,10558465,10558478,10558479,10558480,10558481,10558482,10558483,10558484,10558485,10558486,10558487,10558488,10558489,10558490,10558491,10558492,10558493,10558494,10558495,10558496,7058857,7058858,7058864,10613363,10561523,10561524,9164727,10558540,10558580,10558581,10558582,10558592,10564611,8863339,10613703,10613753,10613761,10564923,10564989,10564991,10564995,8863765,9173252,10613920,10613952,10517117,10517118,10517119,10517120,10517121,10517122,10515123,10517123,10515124,10517124,10517125,4974172,10517126,10517127,10517128,10517129,10517130,10517131,10517132,10517133,10517134,10517135,10517136,10517137,10517138,4974185,10517139,10517140,10517141,4974193,10517170,10517171,10517172,10517173,4974221,10517174,10517175,10517176,10517177,10517178,4974233,4974235,4974247,9161399,4974288,4974311,4974331,10515317,10515318,10515319,9161520,9169553,10513359,10513360,10513361,10513362,10513363,10513364,7055725,10513365,10513366,10513367,10513368,10513369,10513370,10513371,10513372,4974427,7055765,7055791,9161709,10515524,10515525,9169820,10517651,10517652,10517653,7056038,7056064,7056072,10515724,9169919,10515726,10513726,7056101,7056103,7056106,10515765,10515766,10515767,10515776,10515777,10515778,10515779,10515780,9169982,10515823,10515838,10515839,10515840,10513866,10513867,10513868,10515869,10513869,10515870,10513870,10515871,10513871,10515872,10513872,10515873,10515874,10515875,10515876,10515877,10515878,10515879,10515880,9170074,10515881,10515882,10515883,10515884,10515885,10515886,10515887,10515888,10515889,10515890,10515891,10515892,10515893,10515894,10515895,10515896,10513900,10513901,10513902,10515903,10515904,10515905,10515906,10515909,10515913,10515914,10515915,10515916,10515917,7056311,9170177,10513994,10513997,10513998,10513999,10514028,10514031,10514032,10514033,10514041,10516057,10516069,10512144,10512176,10512177,9170450,9170456,9170460,9170468,9162487,9162488,9162489,9162490,9162491,9162492,9162493,9162494,2809298,2809334,10512577,10512604,10512605,10512606,10512607,10512608,10512609,10512610,10512611,10512612,10512613,10512614,10512615,10512616,10512617,10518617,10512618,9170905,10514800,9171038,10513028,10513029,10513030,10513031,10513032,10513033,10513034,10513035,10513036,7057420,7057468,9160358,9160359,10417285,10417286,10417287,10417288,10417289,10416290,10417290,10416291,10417291,10417292,9168402,10418369,10417396,10417397,10416446,10416468,8918212,10417502,10417503,10419539,10419540,10419541,10419542,10419564,10419565,10419566,10419567,10418578,10418579,10418580,10419592,10419594,10419614,10419615,10419616,10419617,10419622,10419623,10419624,10419625,10419626,10419627,10419628,10419630,10419631,10419632,10419633,10419634,9168720,10419635,10419636,10419637,10419641,10419642,10419643,10419644,10419645,10419646,9168759,4973664,4973665,9168815,10418739,10417805,9160963,9168992,10418915,10420023,10420024,10420061,10419073,9169173,10419092,7055370,10420131,9161229,10417161,4974140,4974149,10468913,10471066,6666525,6666534,6666614,8865192,8865193,8865194,10469290,9166743,10471386,10471387,10471460,10469516,10469517,10469518,10465654,10465713,6667149,6667150,6667151,10465724,6667153,10465728,6667242,10469904,10469905,10469906,10463979,10468121,9167645,6667646,6667647,4972509,10466252,10468257,9167768,9167890,10468520,10464527,9167987,10464588,9168072,10464671,9168141,8917802,10464747,10468843,10468844,10468845,10468846,10468847,10468848,10159604,10628178,10628311,10628375,10628376,10628377,10164918,10164919,10164926,10628442,10628636,10628799,10628801,10628802,10628803,10628805,10628845,10628846,10628847,10628848,10628849,10629027,10629028,10629029,10629227,10629256,10155815,10629403,10629404,10629405,10629413,10165947,10165948,10156012,10156016,10166019,10166020,10166021,10166022,10166026,10166027,10166028,10631991,10627019,10632064,10158643,10153837,10627326,10627327,10153852,10627543,10627548,10627728,10627753,10154299,10154300,10154301,10154302,10625175,10630299,10161822,10630300,10630302,10630303,10630304,10630305,10630306,10630310,10630311,10630312,10630313,10630314,10161950,10162012,10162013,10162018,10162077,10630854,10630855,10630858,10162408,10162409,10162410,10162411,10626170,10626178,10631306,10626442,10626487,10626507,10163246,10163254,10163273,10631847,10631848,10631849,10631850,10631851,10631852,10631853,10631854,10631855,10631856,10568392,10568395,10568492,10568501,10568504,10568505,10568516,10568540,10568558,10566123,10572424,10575791,10575862,10575938,10575964,10575965,10575966,10575967,10575968,10575969,10575970,10575971,10575972,10575973,10575974,10576229,10573443,10576453,10576454,10567496,10567504,10567507,10567687,10567688,10567689,10567690,10567713,10567856,10567857,10568044,10568063,10521282,10521283,10521284,10525603,10521843,10521875,10521914,10521915,10522214,10522256,10522257,10522268,10522269,10522501,10522502,10522503,10522504,10522512,10522518,10522519,10522520,10522521,10522526,10522527,10522528,10522529,10522550,10522551,10522552,10522553,10522554,10522555,10522562,10522563,10522564,10524659,10522939,10422270,10422271,10422283,10420286,10422700,10420952,10421215,10472994,10473370,10477458,10473532,10473599,10475664,10476154,10476155,10476156,10476425,10472664,10472780,10476833,10476851) 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'