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(11014508,11014513,11014514,8068814,11014515,8068815,8068820,11014531,11014534,11014551,11014553,8068865,11014568,11014575,11014587,11014588,11014589,11014590,11014593,11014594,11014615,11014674,11014675,11014684,11014694,11014696,11014697,11014714,7076036,7076037,11014743,11014744,11014745,11014746,11014752,11014770,11014772,11014779,10943624,11015251,11015261,11015265,11015266,11015317,10950293,8569660,7068685,11041460,11041461,11041462,8066937,11015568,11015569,11015570,11015593,11015594,11015687,7074163,7066165,7074166,11015862,7074326,11016056,11016079,11016121,11016122,11016123,11016124,11016125,11016126,11016127,11016137,11016138,11016146,11016149,11016162,11016163,11016164,11016186,11016187,7066520,11016219,11016222,11016223,11016279,11016320,11016366,11016387,11016388,11016401,11016421,7066752,11016480,11016481,8067859,10962020,8838253,8838254,8838255,8838265,8838272,11014467,11014488,11011604,11011605,11011606,11011607,11011608,7072201,7072233,8835852,11012139,11012140,11012152,7073426,7073427,7073437,11036511,11036512,11036513,11010597,11010598,11010599,10942643,11010650,7071022,7071023,7071024,7071025,7071026,7071061,7071065,7071067,10984938,7071383,7071395,8861302,7071590,7071592,7071593,7071594,5999970,5999974,5999977,11011448,3655526,7069201,7069297,7069368,7069370,10996176,10996203,10996204,10996205,10996206,3656327,3656328,3656329,3656330,11035334,11035336,3656360,11035444,11035445,11035446,11035449,11035456,10996556,11035576,11035699,11035700,11035701,11035702,11035705,11035706,11035707,11035723,11035724,11035725,11035726,11035733,11035761,11035802,11035803,11035804,11035805,11035845,11035881,11035882,11035883,11035884,11035885,11035886,11035887,11035888,11035889,11035890,11035891,11035892,11035893,11035894,11035895,11035896,11035897,11035898,7070811,11019568,10967807,10924219,10924220,11007803,10981923,10981924,10981925,11018503,11018515,11018536,10917528,11018558,11018559,11018560,10622106,10617179,10617180,10617181,11018720,11018721,11018784,11018810,11018821,11018831,11018835,11018893,11018894,10922895,10922899,10922900,11019014,11019030,11006037,11006038,11019049,10923078,10923079,10923080,10923081,10923082,10923083,10923085,10923086,10923087,11019128,11019151,11019164,10928192,10928201,11019233,11019238,10993336,11019348,11016501,11016502,11016503,10915496,10915497,10915507,10915516,11016554,11016555,10915541,10915542,10915543,10915544,10915545,10915562,10915563,11016591,10915564,11016607,11016608,11016614,11016641,10915648,10915649,10915650,10915651,10915670,10915677,10615186,10915711,10915718,10915719,10915720,10915747,10915755,10915803,10915825,10915858,10915859,10915870,10915871,10915872,11016907,11016908,11016909,10915884,10915885,10915886,10915887,10915917,10915918,10915939,10915960,11016992,11016993,10915971,10915972,10915979,10916015,10916016,11017051,10916023,10916036,10916037,10916038,10991068,10991069,11017092,11017093,11017094,10916072,10916084,10916100,10916101,11017135,11017136,11017137,11017138,11017139,11017140,11017141,11017142,11017143,11017144,10916151,11017200,11043202,11043203,10916186,10916219,10916220,10916221,10916271,11017315,11017325,11017326,10916298,11017327,11017328,11017335,10991343,10991344,10991345,10916317,10916330,10916331,11017378,11017379,10965390,10965391,10916367,10916400,10916401,10916402,10916413,10615925,11017489,10916469,10916470,10916484,10916487,10991520,11017540,11017549,11017550,10991553,10916538,11017580,11017585,10916563,10916564,10916575,10916576,10916577,11017608,10916590,10916591,10916592,10991621,11017621,11017622,10991622,10991623,10916608,10916609,10916610,10916611,10916612,10916613,10916640,10921666,10921672,10916690,10921695,10916710,10921725,10916769,10921780,10921784,11017831,10916803,10916804,10916805,11017833,11017834,10916813,10916814,10916815,10921815,11017846,10916836,10916850,10916860,10916861,10921874,11017905,10921878,11017906,10921893,11017926,10916930,11017959,11017960,11017961,10916934,11017962,10916949,10921956,10921957,10921958,10921959,11017987,10921960,11017988,11017997,11017998,10916979,11018018,10916993,10916994,10916995,10917013,11018047,11018054,11018055,10917067,11018119,10917093,10917098,11018139,10917143,10917144,10917145,10917146,10917157,10922159,10917164,11018202,11018205,11018206,10565324,10565325,10565326,10565327,10565328,10565329,10565330,9189555,9197652,9197761,8864386,10614548,9174008,8864556,9206185,9195364,9195892,9171965,9195990,9195991,10557974,10558203,10558204,10558205,9172420,9204505,9204526,9204550,9204573,9204603,9204613,9204651,9204652,9204653,9204658,9204673,9204691,9204721,10613547,9188951,9188952,9188953,9188956,9172964,10564990,4974168,4974173,4974174,4974175,4974204,4974210,4974211,4974223,4974241,4974256,4974257,9185416,4974270,9185417,4974316,4974380,4974383,9185586,9185587,10513430,10513431,10513432,10513433,10513434,9185645,9161753,4974607,4974881,4974882,4974883,4974884,4974885,4974886,4974887,4974888,4974889,4974890,4974891,4974892,4974893,4974894,4974895,4974896,4974897,4974898,4974899,4974900,4974901,4974902,4974903,4974904,4974905,4974906,4974907,4974908,4974909,4974910,4974911,4974912,4974913,4974914,4974915,9170377,9170388,9170389,10419310,9184491,10417443,8918227,10415606,10415607,9177197,9177198,10420139,4974135,6667696,10468500,8917841,8917842,8917843,8917851,9176294,10179485,10179501,10179503,10179547,10179564,10179569,10179572,10179590,10179672,10170164,10628842,10628843,10628969,10175625,10175626,10175627,10175628,10175629,10175630,10170633,10170634,10629871,10629886,10629934,10629935,10178511,10178517,10178534,10178543,10178545,10178563,10178573,10178576,10178583,10178594,10178598,10178600,10178609,10178610,10178611,10178613,10178619,10178633,10178634,10178637,10178659,10178674,10178727,10178732,10178736,10178756,10178761,10178768,10178773,10178775,10178801,10178802,10163826,10178838,10178840,10163845,10163847,10163884,10178895,10178913,10178914,10178915,10178916,10178917,10178919,10178922,10178923,10178925,10163925,10163926,10178926,10178928,10178932,10178937,10178949,10163957,10178959,10178963,10178966,10178967,10163968,10163971,10178973,10178979,10179002,10179006,10179022,10179037,10179048,10179061,10174074,10174080,10174081,10174084,10179085,10179100,10179104,10179109,10179115,10179116,10179126,10179127,10179128,10179129,10179135,10179141,10179148,10179149,10179159,10179161,10179185,10179200,10179201,10179210,10179219,10179234,10179240,10179241,10179244,10179246,10179253,10179264,10627752,10179278,10179279,10179290,10179302,10179311,10179314,10179330,10179343,10179345,10179385,10179386,10179403,10179414,10179420,10179428,10179435,10179445,10179476,10629979,10629992,10629993,10629997,10629998,10629999,10630000,10630001,10630002,10630003,10630004,10630005,10630006,10630007,10630008,10630009,10630010,10630011,10630012,10630013,10630014,10630015,10630016,10630017,10630018,10630019,10176579,10176580,10176581,10176582,10176583,10176584,10177477,10177484,10177485,10177501,10177502,10177511,10177512,10177520,10177524,10177542,10177551,10177554,10177562,10177566,10177599,10177600,10177615,10177616,10177619,10177620,10177622,10177630,10177644,10177690,10626168,10177692,10177707,10177715,10177716,10177721,10177737,10177739,10177741,10177771,10177779,10177800,10177801,10177816,10177847,10177851,10177902,10177908,10177957,10178021,10178028,10178046,10178048,10178079,10178085,10178086,10178090,10178133,10178143,10178150,10178163,10178189,10178194,10178229,10178233,10178240,10178246,10178269,10178277,10178282,10178292,10178295,10178300,10178324,10178337,10178338,10178353,10178358,10178375,10178376,10178378,10178379,10178391,10178409,10178413,10178434,10178435,10178437,10178451,10574157,10574158,10574165,10574166,10574167,10574264,10574265,10574304,10574312,10574313,10574314,10574416,10574417,10574426,10574609,10574610,10574611,10574612,10574613,10574614,10574619,10574620,10574621,10574622,10574623,10581011,10581017,10581029,10581030,10566120,10566121,10584218,10581284,10581285,10572471,10572652,10572653,10572654,10572655,10572656,10572657,10572683,10572684,10572770,10578827,10578829,10578830,10578831,10578832,10578833,10578967,10578972,10578981,10575982,10575983,10575984,10575985,10575986,10575987,10578987,10575988,10579010,10579011,10579052,10579053,10579097,10579138,10579140,10579160,10579239,10573353,10573354,10573389,10573395,10579425,10579426,10579427,10579428,10579429,10579430,10579431,10579432,10579443,10573451,10573452,10573453,10573455,10573459,10573517,10573518,10573663,10573664,10567686,10585758,10585759,10585760,10573781,10573782,10573804,10573811,10573812,10573813,10573814,10573894,10573907,10574002,10574003,10574004,10574005,10574006,10525142,10529941,10529942,10529943,10529944,10524066,10524482,10524483,10522514,10524744,10524745,10524746,10524755,10524756,10524757,10524758,10423408,10423703,10422190,10481769,10481770,10480865) 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'