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(10962575,10962579,10962580,8574472,8574513,10448383,3229078,3229106,3229107,3229109,10846493,3229171,10963637,10963652,8575152,8575153,8583486,10950648,10950651,10950655,8583681,10950885,8067369,8622461,3230165,3227264,8067931,11001373,11001374,11001383,10845537,11037514,6000119,7201152,10985593,7201203,10842810,7201380,7201631,7201683,7201706,10960213,10960222,10960223,10960224,10960225,10960226,10960227,10960228,10960229,7201797,7201801,7201803,7201805,7201807,7201810,7201812,7201814,7201815,7201817,7201819,7201821,7201823,7201825,7201896,7201897,10103845,8065823,7202088,7202101,7202127,7202129,7202130,7202136,7202137,7202139,7202140,7202161,7202162,7202196,7202200,8618791,7202205,7202208,7202210,7202211,8066126,7202348,7202402,10104332,10932790,10932796,10844133,11000084,10104538,7202692,10104578,10104579,10844217,10844218,10844220,10844221,10987336,3227094,8837240,11010591,11036703,8616854,11036704,11036705,7200527,11010970,11010971,7200555,7200562,7200563,7200578,7200579,8910448,10959088,10985137,10842237,10959188,7200778,7200779,10943257,8910599,11047502,11047548,10839726,8908063,8908064,10839907,7198458,10840150,7198679,7198684,7198685,7198688,8908503,7198696,7198697,7198699,7198702,7198710,7198714,8908710,8908711,8908759,10101566,10101737,7070749,8612813,11045722,10623310,10623311,10623312,10623313,10623314,10623315,10623316,10623317,10623318,10623319,10623320,10623321,10623322,10623323,10623324,10623325,10623326,10623327,10623328,10623329,10623330,10623331,10623332,10623333,10623334,10623335,10623336,10623337,10623338,10623339,10623340,10623341,10623342,10623343,10623344,10623345,10623346,10623347,10623348,10623349,10623350,10623351,10623352,10623353,10623354,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623366,10623367,10623368,10623369,10623370,10623371,10623372,10623373,10623374,10623375,10623376,10623377,10623378,10623379,10623380,10623381,10623382,10623383,10623384,10623385,10623386,10623387,10623388,10623389,10623390,10623391,10623392,10623393,10623394,10623395,10623396,10623397,10623398,10623399,10623400,10623401,10623402,10623403,10623404,10623405,11045944,10623406,10623407,10623408,10623409,10623410,11045949,10623411,11045950,10623412,11045951,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,11045974,10623436,10623437,10623438,10623439,10623440,8070149,10623441,10623442,10623443,8070152,10623444,10623445,10623446,10623447,10623448,8070157,10623449,10623450,10623451,10623452,10623453,10623454,10623455,10623456,10623457,10623458,10623459,10623460,10623461,10623462,10623463,10623464,10623465,10623466,10623467,10623468,10623469,10623470,10623471,10623472,10623473,10623474,10623475,10623476,10623477,8070230,11007198,10968445,10968446,10968447,10838522,10838526,10838528,10838530,10838544,10838545,10838546,8906892,10838967,10838987,11047033,11047054,8907500,8907501,11047148,11047149,11047150,11008170,10619874,10619894,11047498,11047499,10617158,10617159,10617209,11044797,11044798,11044799,11044801,8905210,8905214,8905216,8905219,10617326,10617327,10617355,10617356,10617357,10617358,10617359,10617360,10617361,10617362,10617363,10617364,10617365,10617366,10617367,10617368,10617425,10617426,10617427,10617428,10617429,10617430,10617431,10617432,10617433,10617439,10617440,10617441,10617442,10617443,10617447,10617511,10617793,8905737,8609684,10615178,10615222,10615334,10425553,10615343,10615344,8610094,8610106,10615438,10615439,10991219,10615709,10425936,10425941,10426013,10426018,10426019,10615953,10426196,10426386,8610860,10616175,8611382,10922252,10922253,8611466,8611467,8577870,8577871,10616955,10611037,10611338,9173732,9173757,10614499,10559744,9166136,10611830,6666230,6666231,6666232,6666234,6666239,10611906,10611907,10611908,10611911,10611918,10611923,10611924,10611928,10611932,10611938,9214286,10611953,10612013,10612105,9211492,9211500,9211556,9211557,9211921,7017679,7017680,7017681,7017682,7017683,7017684,7017685,7017686,7017687,7017688,7058247,7058248,7058249,7058250,9172147,10612916,10609928,10612936,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,9212324,9172327,9172328,9172329,9196360,9196361,7058534,10613102,10558298,9172547,10613369,10610480,10610481,7018483,7018484,7018485,7018486,7018487,7018488,7018489,7018490,7018491,7018492,9173055,9173119,10613882,10613883,10613884,10613885,10613886,10613887,9205253,9185357,9169396,9169475,9185540,9185541,7055723,9185622,7015300,7015301,7015302,7015303,7015304,7015305,7015306,7015307,7015308,7015309,7015310,7015311,7015312,7015313,7015314,7015315,7015316,7015317,7015318,7015319,10513554,10513555,9169949,10118151,9186135,10118369,10118370,10118371,10118372,10118373,10118391,10118610,10118674,10118679,10518673,9178996,10516955,10417225,10415242,10416255,10416256,10416257,10417318,10417319,10417320,10417321,10417322,10417323,10417324,10417325,10417326,10417327,9176405,9176406,10416349,10416350,9184492,10416434,10419454,10419496,10419524,10419525,10419526,10419527,10419528,10419529,10419530,10419531,10419532,10419533,10419534,10419535,10419536,10419537,10415575,7054903,10419690,10418701,7014458,7014459,7014460,7014461,7014462,7014463,10415732,7014464,10415733,7014465,10415734,7014466,7014467,10418798,10419807,10419818,10418821,10418822,9168938,10415884,10419888,9169046,7055241,10420043,10417055,10417060,10417078,10417082,10420090,10420093,10420097,10417132,10417135,10417137,10417138,10417144,10419165,10419188,10117478,10417212,10417218,10417219,10463010,10463053,10463054,10463055,10467069,10467070,10467093,10467137,10467156,10467158,10471173,10467174,8549885,10463313,10463314,8549918,10469349,10469350,6666777,9182784,8549957,10463403,9166829,8550007,8550008,10463431,10467436,10463438,10467439,10467458,10467474,10467475,10463554,10463555,10465681,10463691,8550269,6667130,10465712,10463733,10465737,10465738,10463751,10465761,10465762,10465770,10465772,10463781,10465793,10463794,10463803,9175226,10463814,10465814,10463815,10465815,10463816,10463817,9175240,10463818,10465820,10463821,10465821,10465835,10465836,10465838,10465839,6667326,10465914,10465920,10465921,10469950,8917030,10463997,10463998,9191564,10466310,9207741,10462328,10462329,10466336,9207765,8550921,10466356,10466368,10466380,10466381,10466385,10466386,10462419,10462420,10462421,10462422,10462423,10462424,10464427,10462428,10462440,10462441,10462442,10462446,9167877,10466471,10466472,10462516,10462527,10462528,9167988,10462579,10462580,10462729,8551315,8917857,10466859,10883562,10883597,10883668,10628321,10884077,10884081,10884466,10880304,10632043,10632107,10632310,10883142,7001399,10627752,10627753,10627754,10627755,10627756,10627757,10627758,10627759,10627760,10627761,10627762,10627763,10627764,10627765,10627766,10627767,10627768,10627769,10627770,10630026,10630029,10630033,10630034,10630039,10630040,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630069,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10630178,10172195,10162279,10631232,10631233,10631236,10631243,10631244,10631422,10168032,10188046,10188048,10626720,10626724,10631909,10568127,10580188,10580189,10580190,10601402,10601403,10598621,10598622,10598623,10598624,10598625,10598626,10598627,10598628,10598629,10598677,10598719,10598723,10598724,10598725,10598726,10598727,10598728,10598729,10598730,10598772,10598773,10598810,10598811,10598812,10598813,10598814,10598815,10598816,10598825,10598826,10598865,10590268,10590866,10582587,10582588,10582589,10567625,10579818,10579819,10525587,10529861,10528152,10528521,10528522,10528523,10528524,10528525,10420249,10422315,10422316,10422317,10422318,10422319,10422320,10422321,10425332,10498253,10420431,10420434,10421490,10422566,10421579,10423623,10423625,10420652,10421787,10421788,10421790,10421791,10421792,10421793,10421794,10421795,10422825,10424875,10424883,10424884,10424885,10424886,10424887,10424888,10423920,10423921,10423925,10422998,10423004,10423011,10423018,10425029,10425030,10422167,10483215,10490323,10486562,10486571,10477816,10495007,10495009,10478010,10495011,10495012,10495013,10495015,10482015,10495017,10478017,10495018,10495019,10495020,10478020,10482021,10493046,10476461,10487786) 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'