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(10939613,10939614,10939734,10939749,10939751,10939752,10939753,10939754,10939755,10939790,10939792,10939793,4970478,4970479,4970480,10939937,4970719,10940195,10940196,10940304,4970948,4970961,10940385,10940404,10940405,10940406,10940407,10940408,10940409,10940410,4968342,8067208,8067211,8067216,8067217,8067218,8067219,8067289,8067290,4968619,4968620,4968621,4968622,4968623,4968624,4968625,4968626,4968627,4968636,4968637,4968642,4968643,4968651,8067489,8067506,8067530,10938478,10938861,10938878,10938880,10939174,10939368,10939380,10939383,10939384,10939403,10939416,10939425,10939435,10939451,10939467,8065953,8065988,8066033,4967985,4968080,4968087,4968104,4968109,4968113,4968115,4968119,8074037,8074038,8074039,8074040,8074041,8074042,8074043,8074044,8074045,8074046,8074047,8074048,8074049,8074050,8074051,8074052,8074053,8074054,8074055,8074056,8074057,8074058,8074059,8074060,8074061,8074062,8074063,8074064,8074065,8074066,8074067,8074068,8074069,8074070,8074071,8074072,8074073,8074074,8074075,8074076,8074077,8074078,8074079,8074080,8074081,8074082,8074083,8074084,8074085,8074086,8074087,8074088,8074089,8074090,8074091,8074092,8074093,8074094,8074095,8074096,8074097,8074098,8074099,8074100,8074101,8074102,8074103,8074104,8074105,8074106,8074107,8074108,8074109,8074110,8074111,8074112,8074113,8074114,8074115,8074116,8074117,8074118,8074119,8074120,8074121,8074122,8064674,8064675,8064679,8064681,8064684,8064685,8064687,8064691,8064692,3655576,3655664,3655666,3655794,3655795,3655969,3655970,3655971,3655972,3655973,3655974,3655975,3655976,3655977,3656215,3656216,3656231,3656232,3656290,3656291,3656292,3656293,3656353,3656438,8072718,8072719,8072720,8072721,8072722,3656684,3656685,8073090,3656995,8073497,8073518,10918519,10918520,10918527,10918528,10918529,10918530,10623057,10623064,10918619,10918620,10918703,10623198,10918721,10918739,10918740,10918744,10918922,10918923,10918924,10918925,10918926,10918927,10623485,10623489,10623502,10623582,10919264,10919265,10919266,10919267,10919293,10919294,10623824,10623889,10919625,10919626,10919627,10919628,10919629,10919630,10919631,10919632,10919633,10919634,10919635,10919636,10919637,10919638,10919639,10919640,10919641,10919850,10919916,10919917,10919926,10919927,10919928,10919929,10919930,10919931,10624469,10624470,10624471,10920127,10920128,10920129,10920130,10920165,10920166,10920167,10920168,10920169,10920170,10920171,10920172,10920173,10624843,10917489,10917508,10917509,10917510,10917511,10917512,10917513,10917514,10917515,10917516,10917517,10917518,10917519,10917520,10917521,10917522,10917523,10917524,10917525,10622121,10917742,10917743,10917744,10917745,10622263,10622400,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917973,10917974,10917975,10917976,10917977,10918158,10918159,10918356,10918357,10918358,10918359,10918360,10622917,10622918,10915472,10915473,10915474,10915475,10915476,10619995,10915742,10915743,10620317,10620340,10620359,10915884,10915885,10915886,10915887,10915888,10915889,10915890,10915891,10915892,10915893,10915894,10915895,10915896,10915897,10915898,10915899,10915900,10915901,10915902,10915903,10915904,10915905,10915906,10915907,10915908,10915909,10915910,10915911,10916023,10916024,10916025,10916026,10916027,10916028,10916029,10916030,10916031,10916032,10916033,10916176,10916177,10620924,10620927,10621117,10621118,10621119,10621120,10621121,10621122,10621123,10621124,10621125,10621126,10621127,10621128,10621129,10621130,10621131,10621132,10621133,10621134,10621135,10621136,10917088,10917089,10917090,10917091,10917092,10917093,10917094,10917095,10917096,10917097,10917414,10565142,10565143,10610998,10611146,10611147,10611148,10565312,10565313,10565314,10611179,10611253,10611306,10611307,10611308,10611434,10611518,10611616,10611647,10611648,10611689,10611690,10611694,10611715,10611738,10611740,10611741,10611757,10611796,10611806,10611807,10611837,10566091,10566092,10566093,10608987,10608988,10608989,10563242,10563243,10563244,10609104,10609200,10609236,10563428,10563429,10563430,10563431,10563432,10563433,10609284,10563444,10563445,10563447,10563448,10563449,10609327,10609329,10609340,10609341,10609342,10609343,10609365,10609367,10609369,10563548,10563549,10609400,10563550,10609409,10609410,10563583,10563592,10563593,10563594,10563595,10563596,10563597,10563598,10563599,10563600,10563601,10563627,10563628,10563693,10563694,10563695,10563696,10563698,10563699,10563700,10563709,10563714,10563715,10563716,10563717,10563718,10563719,10563728,10563729,10563730,10563731,10563732,10563742,10563743,10563744,10563745,10563746,10563747,10563749,10563760,10563776,10563789,10609640,10563791,10563792,10563793,10563794,10563798,10563799,10563800,10563801,10563802,10563803,10563804,10563806,10563807,10563808,10563809,10563810,10563811,10563812,10563822,10563823,10563824,10563825,10563826,10563836,10563837,10563838,10563850,10609719,10609722,10609723,10563880,10563881,10609751,10609752,10563910,10563911,10563912,10563913,10563914,10563915,10563916,10563923,10563927,10563928,10563929,10563930,10563931,10563932,10563933,10563936,10563937,10563938,10563939,10563940,10563941,10563942,10563943,10563944,10563947,10563948,10563949,10563950,10563951,10563952,10563953,10563954,10563957,10563958,10563959,10563960,10563961,10563970,10563971,10563972,10563973,10563974,10609825,10563977,10563978,10563979,10563980,10609831,10563981,10563982,10609854,10609855,10609856,10609857,10609858,10564008,10609859,10564009,10609860,10564010,10609861,10609862,10609863,10609864,10609865,10609866,10609867,10609868,10609869,10564029,10564030,10564031,10564032,10564033,10564034,10564035,10564036,10564037,10564038,10564039,10564044,10609903,10609907,10609908,10609909,10564083,10564103,10564122,10564130,10564131,10564132,10564133,10564134,10564135,10564136,10564146,10564147,10564155,10564156,10610007,10564157,10564158,10564159,10564160,10564164,10564165,10564166,10564167,10564168,10564169,10610020,10564170,10564171,10564172,10564173,10564174,10564175,10564176,10564177,10564178,10564179,10564180,10564181,10564182,10564183,10564184,10564185,10564188,10564189,10564190,10564191,10564192,10564193,10564194,10564195,10564196,10564197,10564214,10564215,10564216,10564217,10564218,10610093,10610094,10564256,10564257,10564263,10564264,10564265,10564266,10564267,10564268,10564269,10564270,10564313,10564320,10564321,10564322,10564323,10564324,10610175,10610176,10610177,10610180,10564376,10564377,10564378,10564389,10564390,10564414,10564428,10564444,10564445,10564446,10564450,10610357,10610520,10610584,10610585,10610696,10564883,10610796,10610824,10610839,10610862,10610865,10610878,10610909,10517141,10517248,10517249,10517250,10517251,10517256,10517276,10517282,10517283,10517284,10517290,10517291,10517292,10517296,10517297,10517451,10555486,10555487,10555488,10555489,10555490,10555491,10555492,10555539,10555540,10555541,10555542,10555543,10555544,10555545,10555546,10555547,10555548,10555549,10555550,10555551,10555552,10555553,10555554,10555555,10555556,10555557,10555558,10555559,10555560,10555561,10555562,10555563,10555564,10555833,10555834,10555835,10555838,10555839,10555840,10555841,10556027,10556028,10556029,10556030,10556031,10556032,10556033,10556034,10556035,10556036,10556037,10556038,10556039,10556040,10556041,10556042,10556043,10556044,10556045,10556046,10556047,10556048,10556049,10556050,10556051,10556052,10556053,10556054,10556055,10556056,10556057,10518076,10556339,10556340,10518551,10518556,10556568,10556569,10518617,10518664,10518665,10518666,10518667,10518668,10556928,10556929,10557097,10557098,10557099,10557100,10557101,10557102,10557103,10557104,10557105,10557106,10557107,10557108,10557109,10557110,10557111,10419306,10419307,10419308,10419309,10419310,10419311,10419312,10419313,10419314,10419315,10419316,10419317,10415318,10419318,10419319,10419320,10419321,10419322,10419323,10419324,10419325,10419326,10419327,10419328,10419329,10415371,10415455,10419461,10419464,10415468,10419469,10415518,10415521,10415522,10415524,10419597,10415598,10419601,10415652,10415655,10415659,10415670,10419707,10419729,10415758,10415759,10415767,10415768,10415769,10415770,10415771,10415772,10415777,10415825,10415826,10415831,10415840,10419881,10415901,10415952,10420040,10416044,10416045,10420078,10420082,10420112,10416153,10462908,10471019,10471020,10463024,10463134,10463135,10471173,10471489,10471585,10471588,10471676,10471706,10471707,10471708,10471709,10471713,10471714,10471715,10471716,10471720,10471721,10471724,10471771,10471790,10471849,10471857,10471858,10471859,10471863,10471864,10471865,10471866,10471868,10471869,10471870,10471871,10469914,10469926,8563249,8563250,8563251,8563252,10470001,10470002,10470003,10470067,10470126,10470147,10470184,10470360,10470391,10470395,10470454,10470501,10470503,10470598,10470728,10470731,10470734,10470740) 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'