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(10448131,8630906,8630907,8630908,8631119,8631120,8631121,8631161,3228961,8631252,3229078,10950305,8621550,8631478,8631596,10950606,8631657,10963720,8583657,8631856,8631857,8631858,10950885,10950943,10847129,8575734,8632437,8632438,8632439,8632440,8632441,8632442,8632443,8632444,8632445,8632446,8632447,8632448,8632449,8632450,8632451,8632452,8632453,8632454,8632455,8632456,8632457,3230230,8632458,8632459,8632460,8632461,8632462,8629811,10844945,10844947,10962144,7075498,8630510,7075912,3238561,8627791,8627792,10842915,8627824,11011910,11011911,8618187,7201631,10999129,10843211,10843212,10843213,10103591,10843214,10960174,8618359,8618360,8618361,8618362,8065506,8618365,8628213,7201847,7201849,7201850,8628293,8628299,8628306,8628307,8628308,8628316,8628317,8628325,8628327,8628328,10843459,10103845,8065823,10104052,7202211,3899574,8628724,7202667,7202692,10104591,3227049,3227094,8629484,7200233,10997859,8626892,8626893,8626894,8626895,8626896,8626897,8626898,8626899,8626900,8626901,10958965,7200614,8627062,8627129,8627137,8627138,8627146,8627147,8627148,8627150,8627151,8627159,8627160,8627161,8627163,8627164,8627172,8627173,8627174,8627176,8627177,8627184,8627185,8627186,8627188,8627189,8910602,8910603,8627192,8627193,8627194,8627202,8627203,8627204,8627206,8627207,8627370,8627372,8627375,8627376,6000119,8970230,7198363,7198364,7198365,7198384,7198386,3655782,8908406,10840150,10840151,10840152,10840153,10840154,10840155,7198684,7198685,7198688,7198696,7198697,7198698,7198703,7198716,7198719,7198723,7198730,7198731,7198736,7198744,7198745,7198746,7198750,7198751,7198752,7198760,7198769,7198772,7198785,11009238,11009239,11009240,11009241,11009242,11009243,11009244,11009264,11009265,11009266,8625240,8615503,8625333,8625361,8625362,8625369,8625373,7199063,8625519,8625520,8625521,8625522,8625523,8625524,8625534,8625535,8625538,8625542,8625543,8625544,8625545,8625546,8625547,8625548,8625549,8625627,8625636,8625642,8625661,8625664,8625670,8625674,8625690,8625691,8625692,8625693,8625694,8625695,8625696,8625697,8625698,8625699,8625702,8625703,8625704,8625705,8625706,8625707,8625708,8625709,8625712,8625715,8625718,8625719,8625724,8625730,8625736,8625737,8625738,8625739,8625740,8625741,8625742,8625743,8625746,8625751,8625752,8625763,8625765,8625768,8625769,8625770,8625773,8625774,8625775,8625776,8625780,8625783,8625784,8625786,8625787,8625788,8625789,8625791,8625795,8625796,8625801,8625805,8625806,8625807,8625808,8625812,8625813,8625816,8625817,8625821,8625822,8625827,8625828,8625829,8625834,8625835,8625838,8625839,10101335,8625866,8625868,8625877,8625878,8625880,7199480,8625881,8625882,8625883,8625893,8625897,8625898,8625925,8625926,8625927,8625928,8625929,8625930,8625931,8625932,8625933,8625934,8625935,8625936,8625951,8625952,8625953,8625954,8625959,8625960,8625961,8625977,10101477,10101518,10102051,10837707,3233390,3233671,3233672,3233673,3233674,3233675,3233676,3233677,3233678,3233679,3233680,3233681,3233682,3233683,3233684,3233685,3233699,11045990,7196890,3234112,3234113,3234123,10838517,10838535,10838536,10838541,10838552,8906890,10838803,10838965,10838974,10838986,10838991,7197820,10619864,10619865,10619873,10839624,10839655,3232443,8541569,10836850,11044797,11044798,11044799,11044800,11044801,11044802,11044806,8905249,8905250,8905253,8905258,8905262,8905263,10617327,10617332,10617356,10617357,10617358,10617359,10617360,10617391,10617425,10617428,10617429,10617437,10617439,10617440,10617441,10617444,10617449,11045196,11045209,11045210,8612411,8612412,8612413,8612414,11045306,3233158,8905822,10425387,8570011,10620117,10620208,10848001,10848002,10848007,10615726,10615727,10952582,8904299,8540754,10616417,3232177,3232245,3232326,3232346,10562176,10562177,10562178,10562179,10562180,10562181,10562182,10562183,10562184,10562185,10562186,10562187,10562188,10562189,10562190,10562191,10562192,10562193,10562194,10562195,10562196,10562197,10562198,10562199,10562200,10562201,8864074,10559396,6669818,6669823,9197687,9197688,9197689,9197690,9197691,9197692,9197693,9197694,9197695,7059861,9197696,9197697,9197698,9197699,9197700,9197701,9197702,9197703,9197704,9197705,9197706,9197718,9197719,9197720,9173732,9173733,9173734,9173735,9173736,9173737,9173738,10611600,8864498,8864499,8864500,8864501,8864502,8864507,8864508,9166136,6666259,10611945,8542550,10612135,8862008,10612381,9188344,7058534,9196441,9196442,9212546,10558453,10561552,10610435,10561808,10561809,10561810,10561811,10561812,10561817,10561818,10561819,10561820,10561821,10561822,10561823,10561824,10561825,10561826,10561827,10561828,10561829,10561830,10561831,10561832,10561833,10561834,10561835,10561836,10561837,10561838,10561839,10561840,10561841,10561842,10561843,10561844,10561845,10561846,10561847,10561848,10561849,10561850,10561851,10561852,10561853,10561854,10561855,10561856,10561857,10561858,10561859,10561860,10561861,10561862,10561863,10561864,10561865,10561866,10561867,10561868,10561869,10561870,10561871,10561872,10561873,10561874,10561875,10561876,10561877,10561878,10561879,10561880,10561881,10561882,10561883,10561884,10561885,10561886,10561887,10561888,10561889,10561890,10561891,10561892,10561893,10561894,10561895,10561896,10561897,10561898,10561899,10561900,10561901,10561902,10561903,10561904,10561905,10561906,10561907,10561908,10561909,10561910,10561911,10561912,10561913,10561914,10561915,10561916,10561917,10561918,10561919,10561920,10561921,10561922,10561923,10561924,10561925,10561926,10561927,10561928,10561929,10561930,10561931,10561932,10561933,10561934,10561935,10561936,10561937,10561938,10561939,10561940,10561941,10561942,10561943,10561944,10561945,10561946,10561947,10561948,10561949,10561950,10561951,10561952,10561953,10561954,10561955,9197142,10561956,10561957,10561958,10561959,10561960,10561961,10561962,10561963,10561964,10561965,10561966,10561967,10561968,10561969,10561970,10561971,10561972,10561973,10561974,10561975,10561976,10561977,10561978,10561979,10561980,10561981,6677375,10561982,6677376,10561983,10561984,10561985,10561986,10561987,10561988,10561989,10561990,10561991,10561992,10561993,10561994,10561995,10561996,10561997,10561998,10561999,10562000,10562001,10562002,10562003,10562004,10562005,10562006,10562007,10562008,10562009,10562010,10562011,10562012,10562013,10562014,10562015,10562016,10562017,10562018,10562019,10562020,10562021,10562022,10562023,10562024,10562025,6673524,9161357,10117580,10515328,10515377,10515422,10515423,10117904,7055956,10513622,10118130,9169954,9169955,9169960,9169961,9169962,9169963,6674330,10118674,10514364,10518673,10518674,10518675,10518676,10518677,10518678,10518679,10518680,10518681,9168403,6672616,10417424,6672758,10419499,10419501,10419506,10419511,10419517,10419529,10419530,10419532,10419533,10419534,10419535,10419536,10419537,6672862,6672863,6672864,6672865,6672866,6672867,6672868,6672869,6672870,6672871,6672872,6672873,6672874,6672875,6672876,6672877,6672888,6673019,6673020,6673021,6673022,6673023,6673024,6673025,6673122,9168938,10415874,4973896,6673267,6673271,6673272,6673273,6673277,10418048,10417082,10417083,10417084,9185260,9169275,8550264,6667178,9191265,9175287,10115556,10123646,10123647,9191560,10123848,10468326,10468415,9160291,10883568,10883569,10883570,10883571,10883587,10883589,10883592,10883593,10883624,10883628,10883661,10893680,10628291,10884042,10884088,10628769,10894377,10894378,10879888,10890148,10890152,10890159,10890166,10890170,10885313,10887557,10877606,10877725,10877726,10877727,10877728,10627319,10888067,10883069,10885867,10891115,10886266,10887097,10173122,10892183,10892184,10892185,10892186,10892187,10892188,10892189,10892190,10892191,10892192,10892193,10892194,10892195,10892196,10892197,10892198,10892199,10887225,10887229,10568128,10568129,10568130,10580172,10580173,10580174,10580175,10580176,10580177,10580178,10580180,10568305,10643469,10643470,10598560,10590289,10590298,10584526,10584527,10567625,10544472,10536857,10536858,10536859,10423309,10424542,10424543,10424544,10424545,10424546,10421860,10420921,10506819,10506822,10506823,10506824,10506825,10420958,10424003,10421097,10407228,10407229,10485885,10407232,10407465,10486122,10486123,10486124,10486125,10407913,10486571,10408039,10408189,10408190,10496902,10496903,10496904,10496934,10496935,10496936,10496937,10496938,10496939,10496940,10496941,10496942,10496943,10496944,10496945,10496946,10496947,10496980,10496982,10478004,10497034,10497036,10493046,10408564,10476506,10476507,10408902,10406981,10406982,10406983,10406984,10406985,10406986,10406987,10406988,10406989,10406990,10406991,10406992,10406993,10409175) 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'