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(8838437,8838438,8838439,8838440,7067965,11001738,11001739,8621056,8621057,8621058,8621059,8621060,8621061,8621062,8621063,8621064,8621065,8621066,8621067,8621068,8621069,7068251,7068252,8574540,8574541,8574542,8574608,7068710,8569811,8569812,10940462,10940463,10940464,10940508,7074639,10951272,11039646,11039647,11039648,11039649,11039650,11039651,11039652,11039653,11039654,11039655,11039656,11039657,11039658,11039659,11039660,8067942,8067961,8067962,8067963,8067964,8067965,8067966,8067967,10962124,8838111,10962380,10939436,6000225,8835521,8835522,8835523,8835524,8835525,8835526,8835527,8835528,8835529,8835530,7072087,7072088,4967104,8066224,8066225,8066226,8066227,8066228,8066229,8066230,8066231,8066232,10844234,10844270,11000203,10961237,10961238,10497544,10497545,10497546,10497547,10497548,10497549,10497550,10497551,10497552,10497553,10497554,10497555,10497556,10497557,10497558,10497559,10961462,10961463,10961464,10961465,10961570,7073886,10961571,10961572,10961573,10961574,10961575,10961576,10997872,10102915,11011486,7068961,7069230,10840197,8615339,8564781,10840850,10840952,8616210,8616292,8616293,8616310,7070496,10942150,7070623,10841391,10841392,8909729,10997370,10918486,10918487,10618007,10618008,10618443,11046625,11046626,11046627,11046628,11046629,11046630,11046631,10839269,10925101,10925102,10925103,10925104,8611785,8611786,8611787,11005785,11005786,11005787,11005788,11005789,11005790,11005791,11005792,11005793,11005794,11005795,11005796,11005797,11005798,11005799,11005800,11005801,11005802,11005803,11005804,11005805,11005806,11005807,11005808,11005809,11005810,11005811,11005812,11005813,11005814,11005815,11005816,11005817,11005818,11005819,11005820,11005821,11005822,11005823,11005824,11005825,11005826,11005827,11005828,11005829,11005830,11005831,11005832,11005833,11005834,11005835,11005836,11005837,11005838,11005839,11005840,11005841,11005842,11005843,11005844,11005845,11005846,11005847,11005848,11005849,11005850,11005851,11005852,10917704,11005853,10917705,11005854,10917706,10917707,11005855,11005856,10917708,11005857,10917709,11005858,11005859,11005860,11005861,11005862,11005863,11005864,11005865,11005866,11005867,11005868,11005869,11005870,11005871,11005872,11005873,11005874,11005875,11005876,11005877,11005878,11005879,11005880,11005881,11005882,11005883,11005884,11005885,11005886,11005887,11005888,11005889,11005890,11005891,11005892,11005893,11005894,11005895,11005896,11005897,11005898,11005899,11005900,11005901,11005902,11005903,11005904,11005905,11005906,11005907,11005908,11005909,11005910,11005911,11005912,11005913,11005914,11005915,11005916,11005917,11005918,11005919,11005920,11005921,11005922,11005923,11005924,11005925,11005926,11005927,11005928,11005929,11005930,11005931,11005932,11005933,11005934,11005935,11005936,11005937,11005938,11005939,11005940,11005941,11005942,11005943,11005944,11005945,11005946,11005947,11005948,11005949,11005950,11005951,11005952,11005953,11005954,11005955,11005956,11005957,11005958,11005959,11005960,11005961,11005962,11005963,11005964,11005965,11005966,11005967,11005968,11005969,11005970,11005971,11005972,11005973,11005974,11005975,11005976,11005977,11005978,11005979,11005980,11005981,11005982,11005983,11005984,11005985,11005986,11005987,11005988,11005989,11005990,11005991,11005992,11005993,11005994,11005995,11005996,11005997,11005998,11005999,11006000,11006001,11006002,11006003,11006004,11006005,11006006,11006007,11006008,11006009,11006010,11006011,11006012,11006013,11006014,11006015,11006016,11006017,11006018,11006019,11006020,11006021,11006022,11006023,11006024,11006025,11006026,11006027,11006028,11006029,11006030,11006031,11006032,11006033,11006034,11006035,11006036,11006037,11006038,11006039,11006040,11006041,11006042,11006043,11006044,11006045,11006046,11006047,11006048,11006049,11006050,11006051,11006052,11006053,11006054,11006055,11006056,11006057,11006058,11006059,11006060,11006061,11006062,11006063,11006064,11006065,11006066,11006067,11006068,11006069,11006070,11006071,11006072,11006073,11006074,11006075,11006076,11006077,11006078,11006079,11006080,11006081,11006082,11006083,11006084,11006085,11006086,11006087,11006088,11006089,11006090,11006091,11006092,11006093,11006094,11006095,11006096,11006097,11006098,11006099,11006100,11006101,11006102,11006103,11006104,11006105,11006106,11006107,11006108,11006109,11006110,11006111,11006112,11006113,11006114,11006115,11006116,11006117,11006118,11006119,11006120,11006121,11006122,11006123,11006124,11006125,11006126,11006127,11006128,11006129,11006130,11006131,11006132,11006133,11006134,11006135,11006136,11006137,11006138,11006139,11006140,11006141,11006142,11006143,11006144,11006145,11006146,11006147,11006148,11006149,11006150,11006151,11006152,11006153,11006154,11006155,11006156,11006157,11006158,11006159,11006160,11006161,11006162,11006163,11006164,11006165,11006166,11006167,11006168,11006169,11006170,11006171,11006172,11006173,11006174,11006175,11006176,11006177,11006178,11006179,11006180,11006181,11006182,11006183,11006184,11006185,11006186,11006187,11006188,11006189,11006190,11006191,11006192,11006193,11006194,11006195,11006196,11006197,11006198,11006199,11006200,11006201,11006202,11006203,11006204,11006205,11006206,11006207,11006208,11006209,11006210,11006211,11006212,11006213,11006214,11006215,11006216,11006217,11006218,11006219,11006220,11006221,11006222,11006223,11006224,11006225,11006226,11006227,11006228,11006229,11006230,11006231,11006232,11006233,11006234,11006235,11006236,11006237,11006238,11006239,11006240,11006241,11006242,11006243,11006244,11006245,11006246,11006247,11006248,11006249,11006250,11006251,11006252,11006253,11006254,11006255,11006256,11006257,11006258,11006259,11006260,11006261,11006262,11006263,11006264,11006265,11006266,11006267,11006268,11006269,11006270,11006271,11006272,11006273,11006274,11006275,11006276,11006277,11006278,11006279,11006280,11006281,11006282,11006283,11006284,11006285,11006286,11006287,11006288,11006289,11006290,11006291,11006292,11006293,11006294,11006295,11006296,11006297,11006298,11006299,11006300,11006301,11006302,11006303,11006304,11006305,11006306,11006307,11006308,11006309,11006310,11006311,11006312,11006313,11006314,11006315,11006316,11006317,11006318,11006319,11006320,11006321,11006322,11006323,11006324,11006325,11006326,11006327,11006328,11006329,11006330,11006331,11006332,11006333,11006334,11006335,11006336,11006337,11006338,11006339,11006340,11006341,11006342,11006343,11006344,11006345,11006346,11006347,11006348,11006349,11006350,11006351,11006352,11006353,11006354,11006355,11006356,11006357,11006358,11006359,11006360,11006361,11006362,11006363,11006364,11006365,11006366,11006367,11006368,11006369,11006370,11006371,11006372,11006373,11006374,11006375,11006376,11006377,11006378,11006379,11006380,11006381,11006382,11006383,11006384,11006385,11006386,11006387,11006388,11006389,11006390,11006391,11006392,11006393,11006394,11006395,11006396,11006397,11006398,11006399,11006400,11006401,11006402,11006403,11006404,11006405,11006406,11006407,11006408,11006409,11006410,11006411,11006412,11006413,11006414,11006415,11006416,11006417,10620145,10620146,11004094,11043270,11043271,11043272,10978826,10978828,10978829,10978830,10978831,10978832,10978833,10978834,10978835,10978836,10978837,10978838,10978839,10978840,10978841,10952865,10621230,10621231,10621232,10621233,10952892,10621234,10952893,10621235,10952894,10621236,10952895,10621237,10952896,10621238,10952897,10621239,10621240,10621241,10621242,10621243,10621244,10621245,10621246,10621264,10979156,10979157,10979158,10979159,10979160,10979161,8904589,7059890,9205825,9173880,9190148,9214244,9196133,9196134,9196135,9196136,9196137,9196138,9196139,9196140,9196455,8863087,8863309,8863310,8863311,8863312,8863313,8863332,9189179,10515113,10515114,10513330,10513331,10513332,10513333,10513334,9178891,9178892,9178893,9178894,9178895,9178896,9178897,10518862,10518863,10518864,10518865,10518866,10518867,9171167,9179202,9192541,10417554,9200694,10419688,10418159,6666509,9206572,9206573,9206574,9206575,9206576,9206577,9206578,9206579,9206580,9206581,9206582,9206583,9206584,9206585,9206586,4972134,8550519,9199762,10462671,9176165,9176166,8593597,10179754,10159845,10174862,10174863,10174864,10174865,10174866,10174867,10174868,8593912,8593913,8593914,8593915,8593916,8593917,10155581,10155744,10155745,8069148,10629355,10629356,10629357,10880214,10875230,10168825,10168826,10168827,10171657,10186784,10186785,10186786,10186787,10162167,10631013,10626225,10626226,10626227,10626228,10168219,10168220,10168221,10168222,10168223,10168224,10168225,10168226,10168227,10173384,10173385,10173386,10173387,10173388,10173389,10584791,10584792,10582197,10588377,10588378,10588379,10588380,10588381,10588382,10591765,10591766,10591767,10591768,10591769,10591770,10591771,10498505,10498506,10421933,10420938,10420939,10477570,10476543) 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'