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(8574184,8574197,8574201,8838614,8630791,8630877,8630906,10939910,8630935,8574467,8574468,8574473,8574475,8574524,7068397,8631043,8631066,8631102,8631105,8631106,3228957,10940221,3229019,10963490,4971143,9215633,9215634,9215635,9215636,9215637,9215638,9215639,9215640,9215641,9215642,9215643,9215644,4968333,4968334,8583656,9215853,9215854,9215870,8575554,8067524,8632215,10849857,8632216,10850034,3230230,8632547,10964606,10929306,8573267,8573268,8573269,10929431,7067253,3227670,7067278,7067281,8561243,10447337,8630143,8630144,8630190,8630502,10962542,8630505,8627601,8627602,8627612,7201325,8559028,3238524,8627827,8627834,10931548,8628044,8628075,8628085,8628087,8628088,10999133,10960213,10960214,10960215,10960216,10960217,10931903,10931904,10931905,10931906,8628383,10986471,10986472,8628525,10104032,10104038,10104039,10104040,7202200,7202208,8628736,8628746,8628747,8628748,7202467,7202468,7202469,7202470,7202471,5654606,11000083,7202672,10932805,10932819,10932826,10932827,5654816,10104660,10932956,10932958,10932960,10844370,10932976,10932977,3227064,3227072,3227078,3227082,8629321,8629332,10102114,8626766,8626835,8626836,8626837,8626838,8626839,10984927,7200610,7200612,8834860,8910457,8835027,8835030,11037226,11037227,7200901,7200902,7200904,10998405,7071829,10959567,11011612,11011613,10995914,10995915,10944726,10944734,8624962,8624963,8624964,8624965,8624966,8624967,8624968,8624969,8624970,8624971,8624972,8624973,7198645,7198648,7198681,7198682,7198696,7198697,7198699,7198701,7198702,10840219,7198716,7198718,7198721,7198723,7198724,7198730,7198731,7198736,7198740,7198746,7198751,7198759,7198769,7198770,7198772,8625342,8625343,8625344,8625345,8625346,8625347,8625348,8625352,8625353,8625354,8625355,8625356,8625357,8625358,8625693,7199471,10101504,10101534,8626113,8626120,8626126,8626129,8626130,8626132,8626133,8565238,8565239,8565240,8565244,8565246,11048454,8626209,7199877,7199881,10101772,11010437,7070760,8626406,10101891,8626417,10997521,10997522,10997523,10997524,10997525,10997526,10997527,7196205,7196223,7196227,11045718,8612942,10618253,10618254,8613074,10618274,3923672,8070049,8070054,8070057,8070061,8070186,8070189,11007143,11007144,3923937,3234098,3234121,3234125,7196967,3924150,3924155,10838546,10838552,10968571,10968572,10968573,10968574,8907073,8554994,8555009,8555016,8555025,8555029,8555030,3234547,8555156,8555159,10838966,8555163,8907276,8907283,8907290,8907294,10838989,8907295,8907296,10619351,8555278,10619458,8907502,7197707,3234901,3234903,7197816,8907637,8907801,8614606,11047458,11047460,11047461,11047463,8555793,10619875,8624507,8624512,8624540,10995580,10619923,10619927,10619928,10922496,10922497,10922498,8634620,10922515,8634627,8905156,11044797,11044798,11044799,11044803,11044807,11044808,11044809,11044810,11044811,11044812,11044813,3232550,8905251,10617345,10617350,10617353,10617369,11045029,10617373,10617374,10617400,10617401,10617402,10617403,10617404,10617405,10617409,10617423,10617426,10617430,10617432,10617435,10617437,10617441,10617442,10617443,3922838,3232909,11045218,10837363,8612469,8905718,10993382,10993391,10928301,8905900,8632597,10951612,8609825,8609915,8609918,8609924,8570095,3230644,3230667,10848001,3230698,3230699,3230707,3230833,10848194,8633122,8633208,9217222,9217223,9217224,8633216,9217225,9217226,9217227,8633232,8633551,8633567,10426384,10426385,8540568,10991741,3231533,8540715,8904266,8904285,3231712,3231713,3231714,10992294,8552555,10992297,10992298,10992299,10992300,10992302,10992306,10992307,10992310,8611462,10992322,10992323,10992325,8577872,8577873,8577874,8577875,8577886,8577887,8577888,8577889,8577890,10922261,10922288,8634441,8634446,8578008,8578010,8634480,8634481,8634492,8634493,8634546,3232329,10610977,9915538,10614009,10614054,7019064,7019099,8853300,7019137,7019292,7019326,7019358,10614523,10611581,6665992,9174052,9174070,10611927,7019951,10119709,9211553,10612292,10612295,10612381,9171805,9211924,7017941,7017961,7017981,10610015,8862874,10613017,9196360,10610030,10613104,10613113,7018180,8567055,8567056,10561554,7018516,10613527,7018550,7018584,7018618,7018652,10613721,6677364,10613823,10613824,10613825,10613826,10613827,10613828,10613829,7018824,10564990,8853014,8853020,8853022,8853024,8853026,7018858,9205233,7018892,10610913,10610958,6673506,10117525,9177368,10515344,7055775,10515423,7015285,7015305,7015325,10513560,10513561,9185808,10517670,9169948,10118147,9169951,10118148,10118149,9169955,10118274,6674329,6674330,8849971,9162146,10118375,9912425,9912439,9912457,9912459,9912641,9912642,10118675,10118676,10118677,9912798,9912799,9912800,9912859,9186788,9186811,9178849,9178850,8552198,9913333,9913351,9913358,10119354,10119355,10119456,9176428,10416386,9192475,10116702,10417444,10419468,10419493,8918228,10419521,8918274,10418563,10418564,10418565,10418566,6672900,10419677,10419678,10419740,10419742,10415796,10415797,10415832,9168931,10417090,10419112,10417123,10417143,10417144,10417145,10417146,10417147,7019979,7020007,7020035,7020063,7020188,10467126,7020216,7020244,10122831,8549819,10469338,8549916,7020471,7020495,7020519,10467444,7020543,8550064,7020567,7020591,7020615,7020639,7020688,7020741,8550266,7020766,7020791,10463729,7020812,7020832,10465758,7020853,7020875,9175238,7020896,7020916,9175276,9175277,7020936,9175292,9175293,9175294,9175295,9175296,9175297,9175302,7020982,7021086,8855260,8917098,7021106,7021139,976361,10466303,10466304,10466373,10462405,8550993,10462461,9175886,9175934,10462524,10462546,9208024,10116290,10462729,9192258,10466849,10903839,10628380,10884083,10884094,10884097,10894115,10889231,10910024,10171146,10890137,10890149,10890154,10890159,10171198,10171199,10171200,10171201,10171202,10171203,10176227,10885361,10887557,10902823,10184066,10184067,10184068,10883143,7001400,7001401,10890473,10630148,10900719,10172096,10886098,10886099,10886100,10886101,10886102,10886103,10886104,10886105,10886106,10886107,10886108,10886109,10886110,10886111,10886112,10886113,10886114,10886115,10886116,10886117,10172193,10162248,10891383,10626105,10949540,10949541,10626240,10626297,10631427,10173116,10173120,10173121,10882149,10907226,10907229,10892339,10950152,10950153,10945212,10907452,10602171,10580512,10598572,10598573,10598574,10602689,10602694,10602696,10602705,10602706,10602722,10602723,10602727,10602730,10590276,10603688,10603694,10603696,10603700,10648017,10590996,10582568,10601438,10579797,10579798,10579799,10579800,10579801,10579802,10579817,10601706,10601759,10601760,10539113,10539114,10541443,10539807,10539808,10527905,10527906,10527907,10527908,10527913,10527914,10527915,10527916,10549985,10549986,10522256,10522257,10522260,10548310,10546313,10548314,10522384,10520894,10520895,10521024,10422231,10425275,10425278,10425279,10423306,10420425,10420426,10420445,10423514,10423566,10422615,10422652,10507544,10423670,10423671,10420676,10508576,10508577,10508578,10498691,10421807,10424906,10425039,10507938,10482900,10482901,10482902,10482903,10482904,10482905,10482906,10482907,10482908,10482909,10482910,10482911,10482912,10482913,10482914,10482915,10482916,10482917,10482918,10482919,10482920,10482921,10482922,10482923,10482924,10482925,10482926,10482927,10482928,10482929,10482930,10482931,10482932,10482933,10482934,10482935,10482936,10482937,10482938,10482939,10482940,10482941,10482942,10482943,10482944,10482945,10482946,10482947,10482948,10482949,10482950,10482951,10482952,10482953,10482954,10482955,10482956,10482957,10482958,10482959,10482960,10482961,10482962,10482963,10482964,10482965,10482966,10482967,10482968,10482969,10482970,10482971,10482972,10482973,10482974,10482975,10482976,10482977,10482978,10482979,10482980,10482981,10482982,10482983,10482984,10482985,10482986,10482987,10482988,10482989,10482990,10482991,10482992,10482993,10482994,10482995,10482996,10482997,10482998,10482999,10483000,10483001,10483002,10483003,10483004,10483005,10483006,10483007,10483008,10483066,10407445,10407469,10409663,10409676,10409677,10409678,10409679,10484503,10484504,10484517,10411957,10411958,10411959,10413995,10413996,10410024,10473715,10473716,10473717,10410262,10410263,10410264,10410265,10410266,10410270,10486954,10410323,10410491,10414519,10414520,10408549,10408558,10412570,10412571,10412572,10412615,10412622,10412623,10412624,10412627,10412628,10412629,10414644,10414645,10412675,10412676,10412677,10412681,10412682,10410695,10410708,10410723,10410728,10410738,10410740,10410741,10410756,10410757,10410758,10410759,10410760,10410761,10410762,10410763,10410768,10414770,10414841,10414842,10410914,10408936,10408988,10409042,10415111,10415112,10415113,10415114) 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'