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(8068839,8068840,8068841,10939593,10943429,10943430,10939645,10939650,10943450,10943451,10943452,10943453,10943454,10943455,10943456,10943489,10939711,10943509,10939714,10939718,10939725,10939736,10939737,10939738,10939739,10939740,10939741,10939742,10939751,10939752,10939753,10939754,10939755,10939874,10943672,10939882,10939904,10939912,10943723,10943724,10940010,10940011,10940025,10940032,10940037,10940038,10940064,10943873,10943874,10943878,10943879,10943880,10943881,10940098,4970714,4970718,4970738,10940150,10940160,10940167,10940168,10940169,10940170,10940171,10940172,4970767,10940193,10940233,10940234,10944069,4970872,4970917,10940324,10940325,4970946,4970947,4970948,4970957,10940369,4970971,4970980,4971026,4971027,4971028,4971060,10944271,10944285,4971137,4971138,4971139,4971140,4971141,4971142,4971143,10944353,8066954,8066976,4968315,4968316,4968317,4968318,4968319,4968320,4968321,10933452,4968322,10933453,10933454,4968323,4968324,10933455,10933456,4968325,10933457,4968326,4968327,10933458,10933459,4968328,10933460,4968329,4968330,4968331,4968332,4968333,4968334,4968335,10933466,10933467,4968336,4968337,10933468,10933469,4968338,4968339,8067160,8067161,4968410,4968411,4968412,4968413,8067230,8067282,8067283,8067294,8067295,8067296,8067297,10437187,8067340,4968607,10437265,10437297,10437309,10437310,10437311,10437312,10437313,10437314,10437317,10437322,10437323,10437324,10437325,10437326,10437327,10437328,10437331,10437344,8067556,4968846,4968847,4968848,4968849,8067631,8067649,8067652,8067653,8067666,8067723,8067724,8067725,8067749,8067756,10938491,10938492,10938493,10437750,10938524,10437762,10437763,10437764,10437765,10437766,10437767,10437768,10437770,10938592,10938637,10938644,4969252,10938687,4969302,4969312,10938897,10938930,10938931,4969589,4969590,10939005,10939015,10939018,10939071,10939104,10939105,10939151,10939271,10939382,10939424,10939446,8064915,8064917,8064918,8065188,8065189,8065210,8065219,8065363,8065393,8075226,8065665,8065711,8075474,8075475,8075476,8075477,8075478,8075479,8075480,8075481,8075482,8075483,8075484,8075486,8075487,4967031,4967042,4967043,4967044,4967045,4967105,8065942,8065960,8065981,8065982,8065983,8065984,8065991,8065993,4967242,4967243,4967244,8066069,8066091,8066146,8066262,8066281,8066290,8066297,8066362,4967626,4967627,4967628,4967629,8066394,8066410,8066502,8066524,8066538,8066545,8066637,8066677,8066722,8066826,8066842,8063949,8073708,8073709,8073710,8063954,8073711,8073712,8063999,8073762,8073763,8073764,8073765,8073766,8073811,8073812,8073813,8073814,8073815,8064062,8073860,8073861,8073862,8073863,8073864,8073905,8073906,8073907,8073908,8073909,8073952,8073953,8073954,8073955,8073956,8073997,8073998,8073999,8074000,8074001,8064260,8064300,8064323,8064359,8064395,8064396,8064397,8064403,8064423,8064486,8064488,8064495,8064499,8064530,8064586,8064677,8064678,8064856,3655538,3655663,3656055,3656083,8072357,8072358,8072362,8072363,8072364,8072386,8072390,8072391,8072392,8072407,8072417,8072438,8072448,8072449,3656376,3656425,3656437,3656442,3656451,3656452,3656453,3656454,3656455,3656456,3656470,3656493,3656494,3656624,3656625,3656626,3656627,3656628,3656645,3656646,3656647,3656661,3656667,3656668,3656669,3656670,3656671,3656673,3656674,3656678,3656761,3656858,3656867,3657120,3657121,3657122,3657136,3657137,3657138,3657139,3657140,3657141,3657142,3657143,3657144,3657145,3657146,3657147,11049565,8073533,8073534,8073535,8073536,8073537,8073538,8073539,8073540,8073541,8073543,8073558,8073559,8073560,8073561,8073562,8073605,8073606,8073607,8073608,8073609,8073610,8073611,11049719,8073654,8073655,8073656,8073657,8073658,8073659,10918481,10918482,10623041,10918815,10918816,10918818,10623658,10623695,10623732,10623783,10623788,10623789,10623841,10623860,10623872,10623873,10919432,10623962,10623963,10623964,10623965,10919539,10624045,10624046,10919821,10919827,10919828,10919837,10919853,10624347,10919881,10920023,10624566,10624663,10624861,10624862,10621985,10622000,10622001,10622002,10622003,10622014,10622016,10622017,10622034,10622038,10622048,10622086,10622126,10622159,10917696,10917697,10917698,10622200,10622201,10622221,10622222,10622223,10622224,10622225,10622226,10622227,10622280,10622281,10622282,10622329,10622330,10622409,10918008,10918009,10622915,10622927,10619999,10620000,10620001,10620067,10620074,10620237,10620303,10620307,10620328,10620353,10620354,10620355,10620356,10620367,10620389,10620393,10620402,10620405,10620419,10620480,10620481,10620482,10620483,10620486,10620499,10620559,10620638,10620640,10620653,10620835,10620836,10620837,10620838,10620839,10620991,10620992,10620993,10621060,10621152,10621273,10621313,10621321,10621492,10917040,10917041,10621551,10621581,10621596,10621633,10621654,10621705,10621863,10621864,10621865,10621866,10621867,10610995,10565150,10611007,10565158,10611052,10611053,10611054,10611120,10611121,10611123,10611147,10611165,10611166,10565328,10611184,10565335,10565336,10611187,10565337,10611188,10565338,10565339,10565340,10611191,10565341,10565342,10611259,10611260,10611267,10565444,10611297,10611311,10565463,10565464,10565465,10565466,10565467,10611350,10565503,10611380,10565548,10611399,10611400,10611411,10611414,10611415,10611417,10611419,10611421,10611426,10611427,10611428,10611429,10611430,10611437,10611446,10611452,10565607,10611462,10565613,10565648,10611503,10611521,10611542,10565700,10611551,10611603,10611608,10611609,10611610,10611620,10611621,10611625,10611626,10611665,10611666,10611677,10611680,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565877,10565878,10565879,10565880,10565881,10565882,10565883,10565884,10565885,10565886,10565887,10565888,10565889,10565890,10565891,10565892,10611775,10611776,10611777,10565927,10565928,10565929,10565930,10565933,10565934,10565935,10565936,10565937,10565938,10611791,10611792,10611797,10611802,10565957,10565958,10565959,10565960,10565961,10565962,10565963,10565964,10565965,10565966,10565967,10565968,10565969,10565970,10565971,10565972,10565973,10565974,10565975,10565976,10565977,10565978,10611831,10611850,10611851,10611853,10566003,10566006,10566013,10566052,10566053,10566064,10566065,10566088,10566089,10566090,10566091,10566092,10566093,10609047,10609078,10609141,10609187,10609188,10609260,10563427,10609282,10609284,10609285,10609339,10609344,10609345,10609347,10609348,10609349,10609354,10563584,10563587,10563590,10563591,10563605,10563666,10563683,10563684,10609544,10563700,10609590,10609592,10609707,10609715,10609716,10609745,10563934,10563935,10609799,10609814,10609841,10609843,10609876,10609898,10609974,10609989,10610021,10610030,10610046,10610047,10610052,10610055,10610073,10610074,10610106,10610120,10610242,10610243,10610244,10610263,10610264,10564414,10610265,10610271,10610311,10610324,10610328,10564510,10564511,10564512,10564513,10564514,10564515,10564516,10564517,10564518,10610390,10564566,10610425,10564613,10610466,10610493,10610513,10564686,10564808,10564809,10610668,10610671,10610681,10610687,10610688,10610693,10610704,10610705,10610775,10610777,10610780,10610807,10610825,10610833,10610834,10610856,10610860,10610878,10565045,10610930,10610931,10610941,10610959,10517253,10517309,10517310,10517328,10517950,10517951,10517952,10517953,10517954,10517955,10517956,10517957,10556265,10556266,10556267,10556268,10556269,10556270,10556271,10556272,10556432,10556433,10556434,10556435,10556436,10556437,10556438,10518911,10518912,10518913,10518991,10557039,10415285,10415286,10415287,10419302,10419316,10419384,10419457,10419568,10419576,10415595,10415617,10415646,10415650,10415656,10415657,10415661,10419669,10419670,10415674,10419683,10415684,10419686,10415692,10419708,10419709,10419710,10419717,10415782,10415783,10419786,10419790,10415811,10419817,10419819,10419820,10415869,10415881,10415899,10415900,10419952,10419953,10419954,10419966,10415999,10416000,10420014,10416046,10420063,10420064,10420068,10420069,10420071,10420102,10420139,10420172,10416196,10416197,10462885,10462907,10462975,10470980,10463001,10463002,10471022,10463029,10471083,10471111,10463126,10463156,10463169,10463219,10463220,10471249,10463262,10463266,10471277,10471278,10463315,10463345,10463361,10471474,10471475,10471478,10471480,10471487,10471499,10471500,10463632,10463633,10463728,8563211,10469936,10469965,10469972,10469973,10469974,10469975,10469976,10469977,10470089,10470091,8563431,10470137,10470146,8563487,8563493,10470217,8563544,10470230,10470231,10470232,8563555,10470236,8563576,10470276,10470277,10470278,10470284,10462474,10462570,10462669,10462673,10470711,10470723,10462740,10462744,10462750,10462755,10462756,10462812) 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'