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(10437426,10437600,8067961,8067962,8067963,8067964,8067965,8067966,8067967,8068026,8068027,8068028,8068029,8068030,8068031,8068075,8068076,8068077,8068078,8068079,8068080,8068081,8068082,8068083,8068084,8068085,8068143,8068144,8068145,8068146,8068147,8068148,8068149,8068150,8068151,8068152,8068153,8068154,8068155,8068156,8068157,8068158,8068159,8068160,8068161,8068162,8068163,8068164,8068165,8068166,8068167,8068168,8068169,8068170,8068171,8068172,8068256,8068257,8068258,8068259,8068260,8068261,8068262,8068263,8068264,8068265,8068301,8068310,8068311,8068312,8068313,8068314,8068315,8068316,8068317,8068318,8068319,8068320,8068321,8068322,8068323,8068324,8068325,8068326,8068327,8068328,8068329,8068330,8068331,8068332,8068333,8068334,8068399,8068400,8068401,8068402,8068403,8068404,8068405,8068406,8068524,8068525,8068526,8068527,8068528,8068529,8068602,8068603,8068604,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068633,8068634,8068680,8068681,8068682,8068683,8068684,8068685,8068686,8068697,8068698,8068699,8068700,8068701,8068702,8068703,8068715,8068716,8068717,8068746,8068747,8068761,8068762,8068763,8068764,8068765,8068766,10931894,10932376,10932377,10932378,10932603,10932680,10932689,10932921,10932922,10932949,10942928,10942929,10942930,10942931,10942932,10942933,10942934,10942935,10942936,10942937,10942938,10940531,10940549,10940553,10940554,10940562,10940565,10940727,8072673,8072674,8072675,8072676,8072677,8073039,10923638,10923639,10923640,10923641,10923642,10923643,10923644,10923645,10923646,10923647,10923648,10923649,10923650,10923651,10923652,10923653,10923654,10923655,10923656,10923657,10923658,10923659,10923660,10923661,10923662,10923663,10923664,10923665,10923666,10923667,10923668,10923669,10923670,10923671,10923672,10923673,10923674,10923675,10923676,10923677,10923678,10923679,10923680,10923681,10923682,10923683,10923684,10923685,10923686,10923687,10923688,10923689,10923690,10923691,10923692,10923693,10923694,10923695,10923696,10923697,10923698,10923699,10923700,10923701,10923702,10923703,10923704,10923705,10923706,10923707,10923708,10923709,10923710,10923711,10923712,10923713,10923714,10923715,10923716,10923717,10923718,10923719,10923720,10923721,10923722,10923723,10923724,10923725,10923726,10923727,10923728,10923729,10923730,10923731,10923732,10923733,10923734,10923735,10923736,10923737,10923738,10923739,10923740,10923741,10923742,10923743,10923744,10923745,10923746,10923747,10923748,10923749,10923750,10923751,10923752,10923753,10923754,10923755,10923756,10923757,10923758,10923759,10923760,10923761,10923762,10923763,10923764,10923765,10923766,10923767,10923768,10923769,10923770,10923771,10923772,10923773,10923774,10923775,10923776,10923777,10923778,10923779,10923780,10923781,10923782,10923783,10923784,10923785,10923786,10923787,10923788,10923789,10923790,10923791,10923792,10923793,10923794,10923795,10923796,10923797,10923798,10923799,10923800,10923801,10923802,10923803,10923804,10923805,10923806,10923807,10923808,10923809,10923810,10923811,10923812,10923813,10923814,10923815,10923816,10923817,10923818,10923819,10923820,10923821,10923822,10923823,10923824,10923825,10923826,10923827,10923828,10923829,10923830,10923831,10923832,10923833,10923834,10923835,10923836,10923837,10923838,10923839,10923840,10923841,10923842,10923843,10923844,10923845,10923846,10923847,10923848,10923849,10923850,10923851,10923852,10923853,10923854,10923855,10923856,10923857,10923858,10923859,10923860,10923861,10923862,10923863,10923864,10923865,10923866,10923867,10923868,10923869,10923870,10923871,10923872,10923873,10923874,10923875,10923876,10923877,10923878,10923879,10923880,10923881,10923882,10923883,10923884,10923885,10923886,10923887,10923888,10923889,10923890,10923891,10923892,10923893,10923894,10923895,10923896,10923897,10923898,10923899,10923900,10923901,10923902,10923903,10923904,10923905,10923906,10923907,10923908,10923909,10923910,10923911,10923912,10923913,10923914,10923915,10923916,10923917,10923918,10923919,10923920,10923921,10923922,10923923,10923924,10923925,10923926,10923927,10923928,10923929,10923930,10923931,10923932,10923933,10923934,10923935,10923936,10923937,10923938,10923939,10923940,10923941,10923942,10923943,10923944,10923945,10923946,10923947,10923948,10923949,10923950,10923951,10923952,10923953,10923954,10923955,10923956,10923957,10923958,10923959,10923960,10923961,10923962,10923963,10923964,10923965,10923966,10923967,10923968,10923969,10923970,10923971,10923972,10923973,10923974,10923975,10923976,10923977,10923978,10923979,10923980,10923981,10923982,10923983,10923984,10923985,10923986,10923987,10923988,10923989,10923990,10923991,10923992,10923993,10923994,10923995,10923996,10923997,10923998,10923999,10924000,10924001,10924002,10924003,10924004,10924005,10924006,10924007,10924008,10924009,10924010,10924011,10924012,10924013,10924014,10924015,10924016,10924017,10924018,10924019,10924020,10924021,10924022,10924023,10924024,10924025,10924026,10924027,10924028,10924029,10924030,10924031,10924032,10924033,10924034,10924035,10924036,10924037,10924038,10924039,10924040,10924041,10924042,10924043,10924044,10924045,10924046,10924047,10924048,10924049,10924050,10924051,10924052,10924053,10924054,10924055,10924056,10924057,10924058,10924059,10924060,10924061,10924062,10924063,10924064,10924065,10924066,10924067,10924068,10924069,10924070,10924071,10924072,10924073,10924074,10924075,10924076,10924077,10924078,10924079,10924080,10924081,10924082,10924083,10924084,10924085,10924086,10924087,10924088,10924089,10924090,10924091,10924092,10924093,10924094,10924095,10924096,10924097,10924098,10924099,10924100,10924101,10924102,10924103,10924104,10924105,10924106,10924107,10924108,10924109,10924110,10924111,10924112,10924113,10924114,10924115,10924116,10924117,10924118,10924119,10924120,10924121,10924122,10924123,10924124,10924125,10924126,10924127,10924128,10924129,10924130,10924131,10924132,10924133,10924134,10924135,10924136,10924137,10924138,10924139,10924140,10924141,10924142,10924143,10924144,10924145,10924146,10924147,10924148,10924149,10924150,10924151,10924152,10924153,10924154,10924155,10924156,10924157,10924158,10924159,10924160,10924161,10924162,10924163,10924164,10924165,10924166,10924167,10924168,10924169,10924170,10924171,10924172,10924173,10924174,10924175,10924176,10924177,10924178,10924179,10924180,10924181,10924182,10924183,10924184,10924185,10924186,10924187,10924188,10924189,10924190,10924191,10924192,10924193,10924194,10924195,10924196,10924197,10924198,10924199,10924200,10924201,10924202,10924203,10924204,10924205,10924206,10924207,10924208,10924209,10924210,10924211,10924212,10924213,10924214,10924215,10924216,10924217,10924218,10924219,10924220,10924221,10924222,10924223,10924224,10924225,10924226,10924227,10924228,10924229,10924230,10924231,10924232,10924233,10924234,10924235,10924236,10924237,10924238,10924239,10924240,10924241,10924242,10924243,10924244,10924245,10924246,10924247,10924248,10924249,10925101,10925102,10925103,10925104,10925109,10925110,10621977,10621983,10621990,10621991,10621992,10621993,10621994,10621995,10621996,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622007,10622008,10622009,10622010,10622011,10922721,10920594,10920595,10920596,10920597,10920598,10920599,10920600,10920601,10920602,10920603,10920604,10920605,10920606,10920607,10920608,10920609,10920610,10920611,10920612,10920613,10920614,10920615,10920616,10620372,10620373,10620374,10620375,10620376,10620377,10620378,10620411,10620412,10620413,10621147,10621148,10621149,10621151,10621152,10621230,10621231,10621232,10621233,10621234,10621235,10621236,10621237,10621238,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621267,10621268,10621281,10621286,10621292,10621293,10621305,10621306,10621307,10621308,10621309,10621325,10621326,10621327,10621328,10621329,10621330,10621331,10621332,10621333,10621334,10621335,10621336,10621337,10621338,10621339,10621386,10621387,10621388,10621427,10621428,10621429,10621436,10621437,10621438,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621493,10621494,10621495,10621496,10621500,10621501,10621529,10621530,10621531,10621532,10621533,10621567,10621568,10621571,10621573,10621574,10621576,10621577,10621581,10621582,10621621,10621622,10621623,10621624,10621625,10621634,10621635,10621636,10621646,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621692,10621693,10621694,10621705,10621706,10621707,10621708,10621709,10621710,10621711,10621712,10621713,10621714,10621715,10621745,10922296,10614271,10564770,10564771,10564772,10564773,10518992,10518993,10519082,10465761,10465777,10465778,10465779,10465805,10465806,10465807,10465808,10465809,10465810,10465811,10465867,10465868,10465869,10465870,10465871,10465872,10465873) 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'