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(10939610,10939649,4970409,10943592,10943593,10943628,4970520,4970521,4970670,4970675,10940094,4970733,10940136,10940300,4971081,10944265,4971143,8067027,4968320,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,8067368,8067396,8067524,10437559,8067757,8067927,8067931,10939439,10931829,8065506,8065514,8065515,8065516,10931901,10931961,10931962,10931963,10931964,8065696,8065730,8065731,8065732,8065853,8065932,8065933,8065934,8065935,8066127,10932792,10932793,10932797,10932798,10932799,10932800,10932801,10932802,10932806,10932807,10932808,10932809,10932810,10932960,10932963,10932964,10932965,10932966,10932967,10932968,10932975,10932979,4967985,4968076,4968077,4968078,8064672,8064673,10941045,10941046,10941047,10941118,3656385,3656393,3656396,10941691,10941692,10941693,10941695,10941701,10941704,10941716,10941757,10941758,10941759,10941760,10941763,10941764,10941765,10941766,10941769,10941773,10941776,10941782,10941783,10941948,3656993,10942027,10942100,10942401,10942410,10623065,10623165,10623166,10623167,10623493,10623507,10623508,10623665,10623714,10623728,10624134,10624555,10922500,10922501,10922505,10922511,10922512,10922513,10922514,10922518,10922520,10622146,10622266,10622405,10622672,10622673,10622674,10622675,10620172,10620186,10620187,10620188,10620195,10620196,10620197,10620198,10620199,10620200,10620201,10620207,10620208,10620254,10620255,10620256,10620257,10620258,10620259,10620301,10620302,10620303,10620309,10620335,10620336,10620337,10620923,10922135,10922136,10922137,10922138,10922143,10922256,10922257,10922258,10922259,10922260,10922269,10922270,10922271,10922272,10922273,10922274,10922275,10922277,10922282,10613962,10613963,10610963,10613964,10610964,10610965,10613965,10610966,10613966,10613967,10613968,10610969,10613969,10613970,10610971,10610975,10610976,10610977,10610978,10610980,10611025,10614057,10565258,10565296,10614182,10614221,10611250,10611375,10611376,10611377,10611378,10611380,10611382,10611383,10611390,10611391,10611392,10611393,10611394,10611396,10611398,10611399,10611400,10611404,10611407,10611408,10611409,10611411,10611412,10611413,10611414,10611422,10611426,10611427,10611428,10611432,10611434,10611435,10611436,10611437,10611440,10611441,10611442,10611443,10611444,10611449,10611450,10611451,10611452,10611455,10611459,10611461,10611463,10611464,10611467,10611473,10611476,10611477,10611479,10611480,10611482,10611485,10611486,10611491,10611492,10611493,10614495,10614496,10611498,10611499,10611500,10614500,10614501,10614503,10614504,10611505,10614505,10611507,10611509,10611514,10611517,10611520,10614520,10611522,10611525,10611526,10611527,10611528,10611530,10611532,10611536,10611537,10611538,10611539,10611542,10611543,10611546,10611549,10611551,10611552,10611554,10611555,10611560,10611564,10611567,10611569,10611570,10611571,10611572,10611573,10611574,10611577,10611579,10611580,10611581,10611582,10611584,10611585,10611586,10611587,10611588,10611589,10611590,10611594,10611596,10611597,10611598,10611600,10611603,10611604,10611605,10611608,10611611,10611612,10611613,10611617,10611618,10611619,10611620,10611621,10611623,10611624,10611635,10611636,10611637,10611638,10611640,10611641,10611643,10611646,10611647,10611648,10611649,10611655,10611659,10611660,10611665,10611676,10611758,10611821,10611832,10611834,10611835,10611957,10611969,10612022,10612025,10612062,10612086,10612097,10612102,10612106,10612107,10612136,10609155,10609285,10612293,10612294,10612295,10609307,10609354,10609355,10609366,10609369,10612380,10612381,10609834,10609845,10609937,10612938,10609938,10612943,10612960,10612961,10610015,10613017,10610044,10610054,10610061,10610075,10613093,10613097,10613099,10613105,10613107,10613108,10613109,10613112,10613115,10613117,10613137,10613143,10613162,10613175,10613176,10613191,10613192,10613215,10610241,10610242,10610243,10610244,10610245,10610246,10610306,10610307,10610311,10610312,10613343,10613369,10613372,10610376,10613392,10613475,10610479,10610480,10610481,10610482,10613483,10613513,10613514,10613547,10610568,10610569,10610570,10610571,10610572,10610573,10610574,10610575,10610576,10610577,10610578,10610579,10610580,10610581,10610582,10610583,10610584,10610585,10610586,10610587,10610588,10610589,10610590,10610591,10610592,10610593,10610594,10610595,10610596,10610597,10610598,10610599,10610600,10610601,10610602,10610603,10610604,10610605,10610606,10610607,10610608,10610609,10610610,10610611,10610612,10610613,10610614,10610615,10610616,10610617,10610618,10610619,10610620,10610621,10610622,10610623,10610624,10610625,10610626,10610627,10610628,10610629,10610630,10610631,10610632,10610633,10610677,10613696,10610697,10610709,10610729,10610730,10613738,10613739,10610739,10613740,10610917,10610918,10610919,10610954,10613958,10613959,10613960,10613961,10517670,10517789,10517796,10517797,10512530,10518658,10518661,10518668,10518669,10518675,10518676,10518677,10518678,10518679,10518680,10518690,10518691,10518692,10518693,10518694,10518695,10518696,10518697,10512782,10415232,10416257,10419307,10415342,10416351,10416352,10416361,10416364,10416369,10416384,10416385,10416387,10415392,10415393,10416430,10416435,10419438,10419439,10416443,10419469,10419477,10419478,10419479,10419491,10419492,10419498,10419499,10419500,10419501,10419502,10419503,10419504,10419505,10419506,10419507,10419508,10419509,10419510,10419511,10419512,10419513,10419514,10419515,10419516,10419517,10419518,10419519,10419520,10419521,10419522,10419523,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419536,10419537,10419538,10419568,10415599,10415604,10415605,10415614,10419668,10419671,10419672,10419673,10419674,10419675,10415675,10415676,10419677,10415677,10419678,10415678,10419679,10419680,10415685,10419687,10419689,10419690,10419694,10419695,10419703,10419704,10419706,10419708,10419709,10419710,10419713,10419714,10419715,10419717,10419719,10415726,10415727,10415728,10415729,10415730,10419731,10415732,10415735,10419736,10415736,10419737,10419744,10419745,10419746,10419747,10415796,10415797,10419802,10419803,10419804,10419805,10419806,10416807,10416808,10419808,10416809,10419809,10416810,10419823,10419824,10419825,10419826,10416826,10419827,10415827,10419837,10419838,10419839,10419840,10419894,10419898,10419899,10419900,10419904,10420039,10420045,10420046,10417053,10417054,10417055,10417056,10417057,10417058,10417059,10417060,10417061,10417062,10417063,10417064,10417065,10417066,10417067,10417068,10417069,10417070,10417071,10417072,10417073,10417074,10417075,10417076,10417077,10417078,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10420091,10420092,10417092,10417093,10420093,10417094,10420094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10420102,10420103,10417103,10417104,10420104,10420105,10417105,10417106,10417107,10417108,10420108,10417109,10420109,10417110,10420110,10420111,10417111,10417112,10417113,10420113,10417114,10417115,10420117,10420118,10420125,10420126,10420127,10420171,10420172,10420173,10420174,10420175,10420176,10420177,10420178,10420179,10420180,10420181,10420182,10420183,10420184,10420185,10420186,10420187,10420188,10420189,10420190,10420191,10420192,10420193,10420194,10420195,10420196,10420197,10420198,10420199,10420203,10420204,10420205,10420206,10420207,10420208,10420209,10420210,10420211,10420212,10420213,10420214,10420215,10463009,10463010,10463012,10463013,10463023,10463053,10463054,10463056,10463059,10463060,10471172,10463311,10463312,10463315,10463316,10463439,10463552,10463553,10463587,10463589,10463590,10463591,10463592,10463593,10463650,10463651,10463652,10463656,10463659,10463663,10463664,10463666,10463667,10463670,10463673,10463674,10463678,10463689,10463690,10463731,10463732,10463734,10463735,10463737,10463741,10463742,10463743,10463744,10463747,10463754,10463762,10463774,10463775,10463776,10463785,10463801,10463802,10463808,10463809,10463810,10463811,10463812,10463813,10463818,10463819,10463820,10463822,10463828,10463830,8563204,8563250,10469949,10470084,10462292,10462293,10462294,10462295,10462296,10462297,10462298,10462300,10462301,10462302,10462305,10462306,10462307,10462308,10462310,10462311,10462312,10462313,10462318,10462319,10462320,10462321,10462324,10462326,10462327,10462333,10462334,10462335,10462336,10462337,10462344,10462395,10462396,10462397,10462399,10462400,10462406,10462416,10462417,10462418,10462421,10462425,10462432,10462433,10462434,10462435,10462442,10462443,10462449,10462450,10462476,10462477,10462478,10462482,10462486,10462490,10462491,10462492,10462493,10462494,10462495,10462499,10462512,10462513,10462515,10462519,10462529,10462534,10462540,10462541,10462543,10462577,10462578,10462581,10462582,10462584,10462587,10462588,10462591,10462592,10462596,10462597,10462600,10462601,10462603,10462604,10462605,10462610,10462611,10462617,10462621,10462622,10462623,10462626,10462630,10462754,10462756) 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'