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(10962679,10962680,10962681,10962684,10962685,7076041,7076123,10939746,7076128,7076129,10939906,7076286,7076353,4970732,10963390,10976432,10976433,10976434,10976435,10976436,10976437,4968319,4968320,4968330,4968331,10963826,10963827,10963831,10963832,10963833,10963837,10963838,10963841,10963842,10963847,10963848,4968410,4968411,4968412,4968413,7066266,7066276,8067527,10964580,10987631,7067299,7067300,7067301,7075460,10962146,10962363,10962449,10962455,10962460,10939439,10962565,10962566,7075912,10985861,10973056,10960065,10960068,10960069,10986174,10960213,10960308,10960403,10960417,10986447,10986454,10986455,10986456,10986457,10986458,10986459,10986460,10986461,10986462,10986463,10986464,10986465,10986466,10986467,10960474,10960858,10932957,10932959,7065830,10958628,10958629,10943141,10959558,10959562,10959568,6000194,6000195,6000196,6000197,10941389,10957566,10957648,10957649,10941690,10941694,10941696,10941699,10941713,10941724,10941725,10941727,10941734,10941738,3656698,10941751,10941752,10941753,10941769,10941783,10941809,10941838,11048438,11048460,11048461,11048462,11048595,7070749,7070757,7070760,10984534,10984535,10984536,10984544,10984545,10984546,10984547,10984548,10984549,10984550,10984551,10984552,10984553,10984554,10984555,10984592,10984593,10984594,10984595,10984596,10623064,10954779,10967800,10967801,10967802,10967808,10967809,10967810,10967830,10967831,10967838,10967839,10954925,10618282,10618283,10618284,10618286,10618288,10955053,10623495,10955218,10968401,10968402,10968403,10968404,10968405,10968406,10968407,10968408,10968409,10968410,10968411,10968412,10968413,10968414,10968415,10968416,10968417,10968418,10968419,10619328,10619335,10619376,10619377,10619378,10619379,10619380,10619381,10619382,10619383,10619457,10619864,10619866,10619895,10927504,10927505,10927506,10966658,10966670,10966671,10966672,10953890,10953891,10953892,10953893,10622258,10617322,10617323,10617324,10617340,10617345,10617347,10617348,10927863,10927864,10617356,10617357,10617358,10617359,10617360,10617361,10927872,10617363,10617364,10617365,10617369,10617373,10617375,10617376,10617378,10617380,10617382,10617385,10617386,10617387,10617388,10617389,10617390,10617391,10617392,10617393,10617394,10617395,10617396,10617397,10617398,10617399,10617400,10617401,10617403,10617404,10617405,10617408,10617409,10617417,10617418,10617419,10617420,10617421,10617422,10617423,10617427,10617428,10617429,10617430,10617431,10617434,10617435,10617438,10617439,10617454,10954113,10954114,10622460,10620084,10620090,10620091,10620183,10620186,10620195,10620196,10620197,10620201,10615229,10620301,10620302,10620303,10615339,10615352,10615363,10615437,10930631,10620764,10930733,10930737,10615822,10615896,10930834,10930835,10616006,10616045,10616103,10616105,10616254,10616332,10616417,10616426,10616544,10922133,10922134,10616649,10922217,10953442,10922304,10922305,10610982,10562134,10562135,10562136,10562137,10562138,10562139,10562140,10562141,10562142,10562143,10562144,10562145,10562146,10610996,10562147,10562148,10610999,10565211,9165414,10565285,10565286,10565287,10565288,10565289,7059717,7059732,7059855,7059859,10611365,10611396,10611406,10611407,10611408,10611416,10611417,10611422,10611426,10611428,10611432,10611434,10611442,10611443,10611444,10611445,10611449,10559609,10611472,10611496,10614498,10614501,10614502,10614547,10559715,10559716,10559717,10559718,10559719,10611570,10559720,10559721,10559722,10559723,10559724,10559725,10559726,10559744,10559745,10611659,10611666,10611676,10562851,10611782,10611804,6666210,6666211,6666212,6666213,6666214,9166217,6666215,10611909,10611912,10611914,10611919,10611920,10611921,10611922,10611926,10611929,10611930,10611936,10611937,10611939,10611941,7057465,10611969,10612022,10612062,10612063,10612064,10612086,10612104,10612105,10612106,10612107,10612380,10612381,7058247,7058248,7058249,7058250,10557971,10557972,10557973,10557975,10557976,7058373,10612916,10612939,10612942,10612959,10612961,8862829,8862850,8862872,10610061,10613089,10613093,10613098,10613108,7058620,10613127,10613137,10610312,7058836,10610352,10610353,10613435,10613737,10613738,10613811,10613859,9161492,10515328,10515329,10515343,10515423,7055852,10513553,10513554,10513555,10513556,10513557,10513558,10517670,7056038,7056039,9162124,9162157,10513975,10516142,10512530,10516597,10516599,10516600,10516601,10516602,10516603,10516604,10516605,10516703,10516776,10514833,10514834,10516912,7057450,9160319,10416255,9160334,10416256,9160335,4973239,4973240,10416356,10416357,10416362,10416367,10416368,10416383,10416384,10416385,10416387,4973319,4973423,10419499,10415597,10415598,10418676,10419681,10419682,10419685,10419688,10418689,10419694,10419707,10419726,10415726,10419739,10415791,10415792,10418795,10418796,10418807,10418809,10418810,10418811,10418812,10419813,10419814,10419815,10415815,10419816,10419817,10419818,10418824,10415830,10418830,10418833,10418835,10418837,10419839,10418839,10418841,10418843,10419844,10419845,10418845,10418847,10419848,10418849,10418851,10418853,10418859,10415880,10419895,10419896,10420014,10420015,10420016,10420017,10420046,10420052,10420053,10417053,10417054,10417055,10417056,10417067,10417079,10417080,10417081,10417082,10417083,10420084,10417084,10417085,10417086,10417087,10417088,10420088,10417089,10417094,10417095,10420095,10417096,10417097,10417098,10417099,10417100,10417103,10417106,10419108,10419109,10419110,10417110,10419111,10419113,10417113,10417116,10417118,10417123,10417126,10417146,10418147,10417148,10417149,10418150,10417150,10420150,10417151,10420151,10417152,10420152,10417153,10420153,10420154,10420155,10420156,10420157,10417157,10420158,10420159,10420160,10420161,10420162,10420163,10420164,10420165,10420166,10419166,10420167,10419167,10420168,10419168,10420169,10419169,10420170,10419170,10419171,10419172,10419173,10419174,10419175,10419176,10419177,10419191,10419192,10463004,10463024,10463027,10463028,10467127,10467132,10467134,10467135,10471175,4971471,10463392,10463393,10463396,10463399,10463402,10467433,10467437,10467438,10467440,10463661,10465689,10465691,10465692,10465694,10465696,6667130,10463745,10463746,10463749,10463750,10463751,6667176,10463762,10463765,10463766,10465766,10465769,10463772,10465772,10463782,10463783,10465792,10465793,10463796,10465822,10465824,10463825,10463826,10465829,10465830,10465831,10463832,8916911,8916912,10465845,10465846,10465854,10465865,10465866,10465877,10463881,10463882,10463895,10465897,10465898,6667323,10465906,10465909,10465912,10463921,10463922,8917096,10464040,10464043,10464044,10464079,10464080,10466220,10466229,10468235,10466308,10468324,10468327,10468328,10466336,10466357,10466360,10466369,10466371,10466372,10466374,10466376,10466392,10462398,10466402,10466403,10462403,10466404,10462407,10466412,10466424,10462426,10462429,10462438,10462444,10462445,10462448,10466456,10462459,10462473,10462474,10462485,10462506,10462507,10462511,10462535,10462538,10462545,10462598,10462606,10462607,10462608,10462612,10462613,10462614,10464800,10466848,9160272,10466860,10159551,10159958,10628512,10628515,10628516,10628521,10628522,10628523,10628530,10628531,10628943,10155853,10629485,10156107,10156108,10156205,10156210,10632012,10632040,10632047,10632050,10632310,10627707,10627708,10627713,10627714,10627715,10627716,10627717,10627718,10627719,10627720,10627721,10627722,10627723,10627771,10626124,10626127,10626128,10626141,10626142,10626231,10626232,10626233,10626234,10626237,10631238,10626240,10626243,10631244,10626245,10626246,10626259,10626297,10626343,10631412,10631413,10631414,10631415,10631416,10631419,10631420,10631423,10631425,10631428,10631431,10631433,10631435,10631438,10631439,10631441,10631443,10631444,10631446,10626446,10631448,10631451,10631455,10631456,10626710,10626711,10631794,10568112,10568113,10568114,10568115,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10568128,10568129,10568130,10568297,10568298,10568299,10568300,10568301,10568306,10568307,10568308,10568309,10568310,10568311,10568312,10568315,10566668,10568110,10568111,10521679,10521871,10521872,10522290,10522291,10522299,10522300,10522301,10522302,10522346,10522356,10522387,10524418,10524419,10524420,10524422,10522612,10522613,10524777,10520784,10520785,10520791,10520792,10522818,10520901,10520904,10520905,10520909,10522946,10420255,10420260,10420263,10420267,10422315,10422330,10421356,10422374,10422378,10422380,10421401,10421403,10421406,10421408,10420424,10420439,10420440,10420445,10422526,10422527,10422529,10422536,10422537,10422543,10420566,10420567,10422595,10422596,10422599,10420611,10421757,10421758,10421759,10421760,10421761,10421762,10420768,10420769,10422817,10422820,10420849,10420863,10421951,10421952,10421953,10421954,10421955,10421956,10421959,10421960,10421961,10421964,10421984,10422993,10422994,10421996,10421997,10422000,10423001,10423006,10423007,10423058,10423151,10422218,10473265,10473270) 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'