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(10224119,10198165,10224226,10224227,10224228,7068347,7068361,7068362,10276993,10276994,10276995,5654664,10277092,10277093,7074090,7074132,7074138,10264444,10264445,8619709,8619710,10497700,10497769,8619814,8619845,10212759,10212760,10212761,10238806,10238829,8837741,8620164,10275090,8617232,8617233,8617288,8617289,10275171,10275201,10275202,8068054,8068055,8068116,8068232,8617614,8068233,8617647,10262612,10262613,8835383,8835480,8068622,10208084,10208085,10208086,10208087,10208088,10208089,10208090,10208091,10208143,10208144,10208145,10273167,10273168,10208230,10221244,10221245,10221246,10208254,10273280,10273281,10273282,10273283,10273284,8615451,10208482,10208483,10208504,10208510,10208511,10208512,10208549,10208559,10221619,10221620,10208628,10208648,10208649,10208650,10221653,10208720,10208721,10208722,10208723,10273747,10273807,10273824,7072650,7072652,7072653,10208910,7072690,7072691,10932212,10209058,10209059,10209060,10209061,10209062,10209096,10209103,10209122,7072936,10209219,10209220,10209256,7073029,8616393,7073030,8616459,10209355,10209356,7073120,10209380,10209426,10209436,10209437,10209494,10222513,10209514,10261535,10261536,10261537,10209566,10209567,10209602,10209603,10209604,10209622,10102133,10102185,10102206,10102233,10207061,10272078,10272111,10207116,8907471,10942747,10220299,10220300,10220301,10220302,10220303,10207304,10220304,10207305,10207306,8907694,8907695,8907696,10207358,10207359,10207360,10207361,10207362,10207363,10207364,10207408,10207409,10207410,10207527,10207528,10207529,10207530,10207578,10207579,10207580,10207599,10207639,7071471,8614986,8614987,8614988,10208022,10208023,10208028,7071793,10205121,10205122,10205127,8578598,10205189,8578668,8578669,10205381,10205382,10205383,10205384,10205385,8578867,8578868,8578869,8578894,8578897,8578977,7069469,10270938,10270939,10270940,10270941,10270942,10270943,10270944,10270945,10270946,10270947,10270948,10270949,10270950,10270951,10270952,10270953,10270954,10270955,10270956,10206080,10206081,10206082,10206083,10206084,10206085,10206086,10206087,10206088,10206089,10206090,10206091,10271163,10271164,10271165,10271166,10206221,10206222,10206238,10206239,10206281,10206282,10206283,10206284,10206401,10206402,10206403,10206404,10206405,10206406,10206407,10206408,10206409,10206410,10206411,10206445,10206446,7157278,10206447,10271466,7197045,10206549,10206550,10206551,10206584,10206585,10206639,10206689,10271690,10271691,7070465,10206742,10206743,10206814,10206815,10206816,10206817,10206818,10942325,10271849,10271850,10258866,8073504,10942385,10271909,10271910,10271911,10271912,10206918,10206942,10942451,10207007,10207008,10207009,10272022,10272027,10207059,10207060,10242093,3581941,10923700,10923701,10923702,10923703,10923704,10923705,10923811,10923812,10923862,10923932,10923933,10216542,10216543,10924105,10924106,10426550,10426551,10426557,10426573,10426585,10243004,10243005,10243006,3231848,3231849,10243209,10243210,8577757,3232026,3232039,3232040,10924750,10243334,10243385,10924841,10924842,10924843,10924844,10269473,10269474,10924960,10924961,10924962,10925080,10925081,10925082,10427352,8578173,3232472,3232473,8578247,10243782,10925201,10925202,8578285,10925353,10925354,10925355,10925356,10925357,10925358,10925359,10925360,10925361,10241175,10241176,10241177,10241178,10241179,10241180,10922696,10922699,10241393,10922849,10215571,8576109,10923076,10923107,10239072,10239073,8620234,10239114,10239115,10239116,10239184,10239185,10239186,10239187,10920608,10920609,8573668,8573685,8573762,10239307,10252333,10252334,8573871,8573872,8573873,8573874,10920833,10920834,10213417,10213418,10213419,10920837,10920838,10213420,10213421,10920839,10920840,10213422,10213423,10920841,10213424,10920842,8573934,10620368,10920902,8573953,8573954,8573955,8573956,8573957,10620412,10620413,10620421,10920938,10239550,8574028,8574073,8574074,8574075,8574087,8570358,8574091,10926053,10239681,8574156,8574166,10239703,10239718,10921165,10921166,10921167,8620899,10278790,10921231,8620965,10448046,8838725,8838736,10921451,10921518,10846267,8621727,8621780,10621735,10240849,10240850,8583686,8583687,10279974,10279975,7059520,6677577,9181476,9205963,9182152,9182153,9182154,9206178,9198223,9203343,9195343,9195409,10557241,10557242,6675643,6675650,9195475,9195476,9195477,7057648,9195520,9195521,6675821,6675822,10119817,9203629,9203630,10119828,9203631,9203632,9203633,9203634,9203635,9203636,9203637,6675848,6675870,6675884,9195692,9195693,6675902,6675914,6675922,6675949,9195745,9195849,9195850,9203916,9203917,6676148,6676149,6676150,6676151,6676169,9203975,6676199,6676227,7058192,7058201,6676245,9188045,9188046,9204072,9204170,6676433,9204250,6676462,9204285,9204362,9204401,9204443,9204485,8863119,8567105,8863154,8863177,6676974,8863368,7059331,7059332,7059361,9205203,9177481,10513526,10513527,9177732,10513545,10513546,9193802,9194018,9194019,9194263,9194264,9194265,9194266,9194267,9194268,9194269,9194270,9178431,9194548,6674865,6674866,6674867,6674916,6674943,6674953,6675059,6675060,6675061,6675062,6675130,9178938,9195019,9195020,6675309,6675310,6675404,6675421,9195223,6675485,6675486,6675487,10124534,9184457,9176480,10124699,10124713,10124714,10124715,9176540,9176541,9192542,9176579,9192586,9176591,9176592,9176600,9176667,9176690,6680896,9176701,9192705,10124906,10124907,9176731,9176775,6672987,9176793,9192812,9192825,9176839,9176847,9176850,10125067,9192890,9176899,10125108,9208917,9192923,9176944,10125151,9192977,9192978,9193000,9209012,9193033,9193040,9193052,9193075,6681334,10417157,9177300,9206310,10467125,10467126,9206608,9206609,4971466,9206627,9206639,4971518,4971523,4971599,4971630,4971631,4971632,9182931,9183015,10469598,10469599,10123357,10123358,4972084,4972085,4972086,4972087,8550429,8550430,8550431,9207285,8550471,10470038,10470225,10470258,10470259,6680036,10124289,8917793,10124436,10628032,10628033,10628034,10883653,10164732,10164733,10164734,10164735,10164736,10883783,10164886,10164887,10164888,10164889,10164890,10164980,10164981,10165123,10165124,10165125,10165126,10165127,10165128,10894163,10894208,10894209,10894210,10894211,10894228,10894283,10894303,10165315,10165316,10165317,10165318,10165319,10165320,10165398,10165399,10165400,10165401,10165486,10165487,10165488,10884489,8594503,10894501,10894502,10894503,10894504,10894525,10894526,10894534,10894550,10894551,10894591,10894592,10165636,10165637,10165638,10165639,10165640,10165641,10165642,10894686,10894690,10894691,10894692,10894701,10899735,10899736,10899737,10899738,10899739,10899740,10899756,10894806,10894807,10894808,10165813,10894809,10165814,10165815,10165816,10165817,10894865,10894870,10894872,10165882,10165920,10165921,10171015,10171034,10166098,10166099,10166100,10166137,10186229,10897512,10897539,10897623,10173971,7001157,10183990,10898078,7001319,10898157,10627696,10627697,10627698,10169327,10169328,10164329,10164330,10164331,10164332,10164333,10164334,10164335,10164336,10186494,10166552,10166553,10166554,10166565,10166592,10186602,10166626,10166643,10166644,10166645,10166674,10166675,10166676,10166677,10166678,10166679,10186701,10166758,10630237,10166772,10166915,10166919,10166920,10890948,10630433,10630434,10630435,10630436,10630437,10186981,10630459,10891107,10182131,10182132,10182133,10182134,10182135,10167151,10167152,10162182,10167235,10167236,10167267,10167321,10167322,10658633,10630802,10896363,10630865,10658756,10630975,10881506,10631035,10658965,10182720,10187732,10167918,10183110,10887241,10887242,10168364,10183443,10649211,10649212,10649360,10649414,10577730,10568837,10568838,10568839,10568840,10568841,10568842,10569256,10569257,10569258,10569259,10569260,10569261,10569262,10569263,10575334,10575335,10575336,10575337,10575338,10575339,10578512,10578513,10578514,10578515,10581675,10581676,10581677,10581678,10581679,10578718,10578763,10578790,10578791,10570029,10582548,10576904,10576905,10576906,10576907,10576908,10576909,10576910,10576911,10576912,10576913,10576914,10576915,10576916,10577066,10577067,10577068,10577069,10577070,10577071,10577072,10649161,10535142,10535143,10539559,10535706,10535707,10536277,10536278,10524320,10524321,10524322,10528737,10528738,10528739,10534788,10487890,10493968,10487974,10488063,10488064,10494083,10488092,10494197,10494226,10494259,10494260,10494277,10494290,10494310,10494311,10494333,10494439,10494440,10494531,10494543,10494544,10494575,10479786,10494878,10477931,10477932,10477933,10494941,10494942,10494973,10477989,10477990,10478028,10478055,10478170,10478171,10478177,10478183,10478198,10478199,10478200,10478201,10478220,10478246,10478263,10478266,10478272,10478516,10487571,10487598,10487630,10487676,10487677,10487684,10487730,10487769,10482795,10493813,10493814,10493872,10493873) 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'