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(10943469,10943470,10943471,10943472,10943473,10943474,10943475,10943476,10943477,10943478,10943479,10943480,10943481,10943482,10943483,10943484,10943485,10943486,10943487,10943488,10943489,10943490,10943491,10943492,10943493,10943494,10943495,10943496,10943497,10943498,10943499,10943500,10943501,10943502,10943503,10943504,10943505,10943506,10943507,10943508,10943509,10943510,10943511,10943512,10943513,8569395,7068607,10944055,10963466,10963467,10963559,10963560,4971121,10437193,10437564,7066821,7066899,10938545,10938546,10938547,10938548,10938549,10938550,10938551,10938552,10938553,10938554,10938555,10938556,10938557,10938558,10938559,10938560,10938561,10938562,10938563,10938564,10938565,10938566,10938567,10938568,10938569,8067838,10938570,10938571,8067839,10938572,8067840,8067841,10938573,8067842,10938574,8067843,10938575,10938576,10938577,10938578,10938579,10938580,10938581,7067179,7075212,7075213,4969554,4969555,4969556,4969557,4969558,4969559,4969560,4969561,7075495,10962249,10962250,10962251,7067868,7064151,7064152,7064153,7064154,7064155,7064156,7064157,7064158,7064159,7064160,7064161,7064162,7064163,7064164,7064165,7064166,7064167,7064168,7064169,7064170,7064171,7064172,7064173,7064174,7064175,7064176,7064177,7064178,7064179,7064180,7064181,7064182,7064183,7064184,7064185,7064186,7064187,7064188,7064189,7064190,7064191,7064192,7064193,7064194,7064195,7064196,7064197,7064198,8065180,7064302,7064303,8065513,10932325,4967331,4967332,4967333,4967334,4967335,4967336,4967337,4967338,4967339,4967340,4967341,4967342,4967343,4967344,4967345,4967346,4967347,4967348,4967349,4967350,4967351,4967352,4967353,4967354,4967355,4967356,4967357,4967358,4967359,7073143,4967360,4967361,4967362,4967363,4967364,4967365,4967366,4967367,4967368,4967369,4967370,4967371,4967372,4967373,4967374,4967375,4967376,4967377,4967378,4967379,4967380,4967381,4967382,4967383,4967384,4967385,4967386,4967387,4967388,4967389,4967390,4967391,4967392,4967393,4967394,4967395,4967396,4967397,4967398,4967399,4967400,4967401,4967402,4967403,4967404,4967405,4967406,4967407,4967408,4967409,4967410,4967411,4967412,4967413,4967414,4967415,4967416,4967417,4967418,4967419,4967420,4967421,4967422,4967423,7065426,7065427,10932864,7065920,10958845,10958846,8064151,8064152,8064153,8064154,8064155,8064156,8064157,8064158,8064159,8064160,8064161,8064162,8064163,8064164,8064165,8064166,8064167,8064168,8064169,8064170,8064171,8064172,8064173,8064174,8064175,8064176,8064177,8064178,8064179,8064180,8064181,8064182,8064183,8064184,8064185,8064186,8064187,8064188,8064189,8064190,8064191,8064192,8064193,8064194,8064195,8064196,8064197,8064198,8064199,8064200,8064201,8064202,8064203,8064204,8064205,8064206,8064207,8064208,8064209,8064210,8064211,8064212,8064213,8064214,8064215,8064216,8064217,8064218,8064219,8064220,8064221,8064222,8064223,10958990,10958991,10958992,10958993,10958994,10958995,10958996,11049269,11049292,11049295,6000051,6000052,6000053,6000054,6000055,6000056,7071812,7071813,10959500,6000119,6000149,6000150,6000151,6000152,6000153,6000154,6000155,6000156,11047600,10941724,11048357,10971342,11049554,11049555,11049556,11049557,11049558,11049559,11049560,11049561,11049562,11049563,11049564,11049565,10623338,10623432,10918966,10619090,10619091,10619092,10619093,10619094,10619095,10619096,10966715,10953925,8570160,10615291,8570295,10930651,10930655,10615821,10953005,10953006,10953007,10953008,10953009,10953010,10953011,10953012,10953013,10953014,10953015,10953016,10953017,10953018,10953019,10953020,10953021,10953022,10953023,10953024,10953025,10953026,10953027,10953028,10953029,10953030,10953031,10953032,10953033,10953034,10953035,10953036,10953037,10953038,10953039,10953040,10953041,10953042,10953043,10953044,10953045,10953046,10953047,10953048,10953049,10953050,10953051,10953052,10953053,10953054,10953055,10953056,10953057,10953058,10927228,10927229,10927230,10927231,10922314,10922462,7059601,10565329,10565330,10611232,6665747,9165971,9165972,10614637,10614638,9166055,9166056,9166057,9166058,10565928,10565929,10565930,10566002,10566003,8862139,8862140,10563446,10563447,10563448,10563449,10609303,10612505,10612730,8862799,8862800,8862801,8862802,8862889,10613153,10613154,10613173,10558409,10558410,10558411,10558412,10558413,10558414,10561531,10610438,10610855,10610857,10610940,10517117,10517118,10517119,10517120,10511120,10517121,10511121,10517122,10511122,10517123,10511123,10517124,10511124,10517125,10511125,10517126,10511126,10517127,10511127,10511128,10517128,10511129,10517129,10511130,10517130,10511131,10517131,10511132,10517132,10511133,10517133,10511134,10517134,10511135,10517135,10517136,10517137,10517138,10517139,10517140,10517141,10513142,10513143,10513193,10513194,10513195,10513196,10513197,10513198,10513199,10513200,10513201,10513202,10513203,10513204,10513205,10513206,10513207,10513208,10513209,10513210,10513211,10513212,10513213,10513214,10513215,10513216,4974353,4974507,7055993,10513766,10513776,10513777,10513960,10513961,10514003,2809082,2809083,2809084,2809085,2809086,2809087,2809088,2809089,2809090,2809091,2809092,2809093,2809094,2809095,2809096,2809097,2809098,2809099,2809100,2809101,2809236,2809237,2809238,2809239,2809414,7057180,8861608,8861609,8861610,8861611,8861612,8861613,8861614,8861615,10516906,8861616,8861617,8861618,8861619,8861620,8861621,8861622,8861623,8861624,8861625,8861626,8861627,8861628,8861629,10514932,10514933,10514934,10514935,10514936,10514937,10514938,10514939,10514940,10514941,10514942,10514943,10514944,10514945,10514946,10517004,10517005,10417279,10417366,10417371,10416555,9160668,9160669,9160670,9160671,9160672,9160673,9160674,9160675,9160676,9160677,9160678,9160679,9160680,9160681,8918328,9160682,9160683,9160684,9160685,4973538,9160686,9160687,9160688,9160689,9160690,9160691,9160692,9160693,9160694,9160695,9160696,9160697,9160698,9160699,9160700,9160701,9160702,9160703,9160704,9160705,9160706,9160707,9160708,9160709,10415631,9160710,10415632,9160711,9160712,9160713,9160714,9160715,9160716,9160717,9160718,9160719,10419706,10415819,7055295,10462876,10462877,10462878,10462879,10462880,10462881,10462882,10462883,10462884,10462885,10462886,10462887,10462888,10462889,10462890,10462891,8864843,10467242,10467243,10467244,10467245,10467246,8916389,8916390,8916391,10469839,10466255,8917491,8917516,8917785,10462832,10462833,10462834,10462835,10462836,10462837,10462838,10462839,10462840,10462841,10462842,10462843,10462844,10462845,10462846,10462847,10462848,10462849,10462850,10462851,10462852,10462853,10462854,10462855,10462856,10462857,10462858,10462859,10462860,10462861,10462862,10462863,10462864,10462865,10462866,10462867,10462868,10462869,10462870,10462871,10462872,10462873,10462874,10462875,10628163,10628164,10628165,10628166,10628167,10628168,10628169,10628170,10628171,10628221,10628222,10628223,10629526,10154162,10154163,10154164,10154165,10154166,10154167,10154168,10154169,10154170,10154171,10154172,10154173,10154174,10154175,10154176,10154177,10154178,10154179,10154180,10154181,10154182,10154183,10154184,10154185,10154186,10154187,10154188,10154189,10154190,10154191,10154192,10154193,10154194,10154195,10154196,10154197,10154198,10154199,10154200,10154201,10154202,10154203,10154204,10154205,10154206,10154207,10154208,10154209,10154210,10154211,10154212,10154213,10154214,10154215,10154216,10154217,10154218,10154219,10154220,10154221,10154222,10154223,10154224,10154225,10154226,10154227,10154228,10154229,10154230,10154231,10154232,10154233,10154234,10154235,10154236,10154237,10154238,10154239,10154240,10154241,10154242,10154243,10154244,10154245,10154246,10154247,10154248,10154249,10154250,10154251,10154252,10154253,10154254,10154255,10154256,10154257,10630072,10630103,10631263,10631275,10631737,10631738,10631739,10571114,10571115,10571128,10571129,10571130,10571316,10571317,10571996,10567621,10567622,10567623,10567624,10567625,10567902,10567903,10567904,10567905,10567906,10567907,10567908,10567909,10567910,10567911,10567912,10519990,10519991,10519992,10519993,10519994,10519995,10519996,10519997,10519998,10519999,10520000,10520001,10520002,10520003,10520004,10520005,10520006,10520007,10520008,10520009,10520010,10520011,10520012,10520013,10520014,10520015,10520016,10520017,10520018,10520019,10520020,10520021,10520022,10520023,10520024,10520025,10520026,10520027,10520028,10520029,10520030,10520031,10520032,10520033,10520034,10520035,10520036,10520037,10520038,10520039,10520040,10522640,10522641,10420400,10420542,10420543,10420582,10421981,10421982,10421983,10421063,10472975,10472978,10475667,10473829,10473836,10473838,10473939,10473985,10472509,10472510) 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'