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(7073940,7073943,7073951,7073952,7073953,7073954,7073955,7073956,7073957,7073958,7073964,7073965,7073966,7073967,7073968,8067436,8067443,8067451,8067457,8067462,8067463,10437550,10437553,11011628,6000239,6000252,6000253,6000254,6000255,6000256,6000257,11011661,11011662,6000264,6000265,6000266,6000267,6000268,6000269,11011672,6000270,6000271,6000272,6000273,6000274,6000275,6000276,6000277,6000278,11011682,11011691,11011697,11011699,11011704,11011705,11011706,11011707,11011708,11011709,11011710,11011711,11011712,11011714,11011726,11011735,11011759,11011778,11011784,11011785,11011786,11011787,11011788,11011789,11011790,11011791,11011792,11011793,11011794,11011795,11011796,11011797,11011798,11011799,11011800,11011801,11011802,11011803,11011804,11011805,11011806,11011807,11011808,11011809,11011810,11011811,11011812,11011813,11011814,11011815,11011816,11011821,11011837,11011840,11011859,11011863,11011864,11011868,11011870,11011871,11011880,11011881,11011888,11011889,11011890,11011891,11011892,11011893,11011894,11011895,11011896,11011897,11011898,11011899,11011900,11011901,11011902,11011903,11011904,11011905,11011906,11011907,11011908,11011909,11011911,11011912,11011919,11011957,11011967,11011971,11011974,11011984,11011990,11011995,11011997,11012003,11012005,11012007,11012008,11012032,11012033,11012036,11012041,11012042,11012043,11012044,11012045,11012046,11012047,11012048,11012049,11012050,11012051,11012052,11012053,11012054,11012055,11012056,11012057,11012058,11012059,11012060,11012061,11012062,11012063,11012064,11012065,11012066,11012067,11012068,11012069,11012070,11012071,11012072,11012073,11012074,11012075,11012076,11012077,11012078,11012079,11012080,11012081,11012082,11012083,11012084,11012085,11012086,11012087,11012088,11012089,11012090,11012091,11012092,11012093,11012094,11012095,11012096,11012097,11012098,11012099,11012100,11012101,11012102,11012103,11012104,11012105,11012106,11012107,11012108,11012120,11012121,11012122,11012123,11012124,11012125,11012126,11012134,7073708,7073712,7073716,7073718,7073738,7073747,7073749,7073759,7073770,7073789,7073808,7073809,7073810,7073811,7073812,7073813,7073824,7073830,7073838,7073841,7073847,7073851,7073853,7073857,7073860,7073862,7073867,7073868,7073869,7073870,7073871,7073872,7073873,7073874,7073880,7073883,7073889,7073895,7073897,7073913,7073921,7073922,7073926,10942683,10942684,10942691,10942692,10942693,10942694,10942695,10942715,10942716,10942717,10942720,10942727,10942729,11049286,11049292,11049293,11049294,11049295,11049296,11049297,11011482,11011511,6000121,6000122,6000123,6000124,6000125,11011534,11011540,11011549,11011550,11011554,6000154,11011561,11011562,11011569,6000171,6000172,11011575,6000173,6000174,6000175,6000176,6000177,6000178,6000179,6000180,6000181,6000182,6000183,6000189,11011595,11011608,6000211,11011614,10944796,10944803,10944821,10944826,3655994,3655999,10944854,3656022,3656026,3656036,3656042,3656049,3656065,3656079,3656082,3656096,3656097,3656098,3656099,3656100,3656101,3656111,3656121,3656122,3656123,3656125,3656132,3656147,3656157,3656158,3656159,3656160,3656161,3656162,3656163,3656164,3656165,3656166,3656167,3656168,3656169,3656170,3656171,3656172,3656173,3656174,3656175,3656176,3656177,3656178,3656179,3656180,3656181,3656182,3656183,3656184,3656185,3656186,3656187,3656188,3656189,3656190,3656191,3656192,3656193,3656194,3656195,3656196,3656197,3656198,3656199,3656200,3656201,3656202,3656203,3656204,3656205,8073480,8073492,8073493,8570210,8570212,8570224,8570228,8570235,8570236,8570242,8570249,8570255,8570267,8570268,8570271,8570272,8570273,8570274,8570275,8570276,8570277,8570278,10930921,10930922,10930927,10930929,10930931,8864573,8864576,8864582,8864583,8864585,8864601,8864606,8864609,8864610,8864617,8864618,8864619,8864624,8864625,8864630,8864632,8864635,8864642,8864643,8864644,8864645,8864646,8864647,8864648,8864649,8864650,8864651,8864652,8864663,8864670,8864678,8864679,8864680,8864682,8864685,8864689,8864693,8864697,8864704,8864708,8864710,8864711,8864712,8864713,8864714,8864715,8864716,8864717,8864718,8864719,8864720,8864721,8864722,8864723,8864724,8864725,7058549,7058550,7058551,7058555,7058561,7058570,7058575,7058578,7058585,7058587,7058589,7058590,7058591,7058592,7058593,7058594,7058598,7058599,7058600,7058601,7058602,7058603,7058611,7058627,7058635,7058640,7058641,7058642,7058643,7058644,7058646,7058648,7058649,7058652,7058653,7058654,7058655,7058656,4974004,4974007,4974011,4974020,4974040,4974041,4974042,4974043,4974044,4974045,4974046,4974051,4974061,4974075,4974082,4974101,4974110,4974115,4974118,4974119,6667579,6667589,6667590,6667593,6667594,6667596,6667598,8917709,8917710,8917716,8917717,8917721,8917725,8917732,8917735,8917736,8917740,8917742,8917743,8917744,8917745,8917749,8917750,8917762,8917764,8917767,8917768,8917769,8917776,8917777,8917779,8917780,8917781,8917782,8917783,8917784,8917785,8917786,8917787,8917788,8917789,8917790,10628950,10628956,10628964,10628968,10628972,10628979,10628982,10629012,10629034,10629035,10629036,10629037,10629041,10629042,10629047,10629055,10629069,10629083,10629094,10629105,10629111,10629114,10629125,10629150,10629166,10629167,10629168,10629169,10629170,10629171,10629172,10629173,10629174,10629175,10629176,10629177,10629178,10629179,10629180,10629181,10629182,10629183,10629184,10629185,10629186,10629187,10629188,10629189,10629190,10629191,10629192,10629193,10629194,10629195,10629196,10629197,10629198,10629199,10629200,10629212,10629222,10629230,10629238,10629244,10629262,10629266,10629278,10629281,10629283,10629284,10629287,10629290,10629294,10629295,10629300,10629301,10629303,10629314,10629321,10629327,10629328,10629329,10629341,10629348,10629358,10629368,10629371,10629379,10629380,10629381,10629382,10629386,10629401,10629402,10629407,10629409,10629410,10629411,10629412,10629413,10629414,10629418,10629430,10629431,10629434,10629442,10629443,10629444,10629445,10629446,10629447,10629448,10629449,10629455,10629456,10629457,10629458,10629459,10629460,10629461,10629462,10629463,10629464,10629465,10629466,10629467,10629468,10629469,10629470,10176725,10176736,10176744,10176762,10176790,10176818,10176895,10176938,10176939,10176940,10176941,10176942,10176943,10176944,10176945,10176946,10176947,10176948,10176949,10176950,10176951,10176952,10176953,10176954,10176955,10176956,10176957,10176958,10176959,10176960,10176961,10176962,10176963,10176964,10176965,10176966,10176967,10176968,10176969,10176970,10176980,10176986,10176997,10177007,10177015,10177016,10177017,10177018,10177019,10177025,10177029,10177034,10177039,10177040,10177041,10177042,10177043,10177054,10177064,10177065,10177074,10177082,10177084,10177085,10177094,10177108,10177109,10177110,10177111,10177112,10177113,10177129,10177134,10177142,10177143,10177144,10177145,10177146,10177147,10177148,10177149,10177150,10177151,10177152,10177153,10177154,10177155,10177156,10177157,10177158,10177159,10177160,10568115,10568126,10568127,10568140,10568163,10568171,10568174,10568180,10568190,10568210,10568221,10568255,10568257,10568313,10568321,10568340,10568351,10568356,10568387,10568407,10568411,10568413,10568418,10568426,10568435,10568439,10568440,10568450,10568457,10568458,10568459,10568460,10568461,10568462,10568463,10568464,10568465,10568466,10568467,10568468,10568469,10568470,10568471,10568472,10568477,10568484,10568488,10568489,10568491,10568492,10568493,10568494,10568495,10568496,10568497,10568498,10568499,10568500,10568501,10568502,10568503,10568504,10568505,10568506,10568507,10568508,10568509,10568510,10568511,10568512,10568513,10568514,10568515,10568516,10568517,10568518,10568519,10568520,10568521,10568522,10568523,10568524,10568525,10568526,10567709,10567710,10567711,10567712,10567713,10567714,10567715,10567716,10567717,10567718,10567743,10567744,10567773,10567774,10567789,10567806,10567818,10567824,10567830,10567849,10567877,10567961,10567965,10567971,10567980,10567984,10568007,10568008,10568009,10568010,10568011,10568012,10568013,10568014,10568015,10568016,10568017,10568018,10568019,10568020,10568021,10568022,10568023,10568024,10568025,10568037,10568040,10568042,10568052,10568075,10568079,10568082,10423463,10423467,10423470,10423472,10423476,10423477,10423480,10423482,10423485,10423489,10423491,10423494,10423495,10423507,10423508,10423509,10423510,10423511,10423517,10423519,10423520,10423521,10423522,10423526,10423529,10423532,10423533,10423534,10423535,10423539,10423540,10423544,10423545,10423546,10423547,10423549,10423550,10423552,10423554,10423557,10423561,10423562,10423564,10423565,10423568,10423569,10423570,10423572,10423573,10423574,10423575,10423576,10423577,10423578,10423579,10423580,10423581,10423582) 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'