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(4970231,4970232,4970234,4970237,4970244,4970248,4970253,4970257,4970259,4970265,4970333,4970370,4970556,4970585,4970586,4970587,4970588,4970646,4970647,4970648,4970659,4970660,4970661,4970666,4970667,4970668,4970669,4970673,4970677,4970684,4970687,4970692,4970694,4970696,4970699,4970700,4970710,4970711,4970719,4970726,4970727,4970728,4970730,4970731,4970735,4970736,4970737,4970738,4970745,4970753,4970758,4970759,4970782,4970783,4970793,4970794,4970816,4970853,4970854,4970875,4970876,4970877,4970886,4970887,4970888,4970889,4970908,4970909,4970910,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970948,4970951,4970961,4970964,4970973,4971019,4971020,4971021,4971030,4971031,4971032,4971033,4971045,4971061,4971062,4971070,4971071,4971072,4971077,4971078,4971079,4971080,4971082,4971083,4971084,4971090,4971091,4971092,4971093,4971094,4971101,4971107,4971112,4971113,4971114,4971115,4971116,4971117,4971118,4971126,4968190,4968191,4968209,4968220,4968226,4968231,4968239,4968240,4968241,4968310,4968311,4968316,4968317,4968342,4968357,4968371,4968410,4968411,4968516,4968517,4968518,4968519,4968520,4968521,4968522,4968575,4968576,4968577,4968578,4968579,4968580,4968604,4968605,4968606,4968607,4968608,4968611,4968613,4968614,4968635,4968645,4968655,4968659,4968668,4968669,4968683,4968760,4968846,4968847,4968859,4968886,4968948,4968949,4968950,4968951,4968952,4968953,4969007,4969008,4969018,4969019,4969115,4969116,4969123,4969178,4969179,4969209,4969210,4969211,4969212,4969270,4969271,4969272,4969273,4969274,4969275,4969276,4969277,4969278,4969279,4969280,4969281,4969318,4969319,4969465,4969466,4969467,4969468,4969469,4969470,4969538,4969547,4969548,4969554,4969556,4969560,4969566,4969568,4969570,4969571,4969572,4969573,4969574,4969575,4969576,4969577,4969578,4969579,4969580,4969581,4969582,4969583,4969584,4969585,4969586,4969587,4969630,4969631,4969654,4969655,4969656,4969657,4969741,4969742,4969743,4969744,4969745,4969746,4969747,4969748,4969749,4969750,4969960,4970021,8074670,8074671,8074672,8074673,8074674,8074675,8074676,8074677,8074678,8074679,8074680,8074681,8074682,8074683,8075249,8075278,8075279,8075282,8075283,8075306,8075317,8075318,8075324,8075325,8075326,8075327,8075328,8075329,8075330,8075331,8075339,8075340,8075386,8075387,8075388,8075389,8075390,8075391,8075392,8075393,8075394,8075395,8075396,8075397,8075398,8075399,8075428,8075429,8075430,8075431,8075443,8075444,8075445,8075446,8075447,8075488,8075490,8075491,8075492,8075493,8075535,8075536,8075537,8075538,4967029,4967032,4967047,4967068,4967437,4967438,4967439,4967440,4967441,4967442,4967443,4967444,4967445,4967446,4967447,4967448,4967449,4967450,4967451,4967452,4967453,4967454,4967455,4967456,4967457,4967458,4967459,4967460,4967461,4967470,4967471,4967475,4967478,4967481,4967482,4967487,4967494,4967497,4967512,4967560,4967717,4967811,4967826,4967906,4967907,4967908,4967909,4967910,4967911,4967912,4967913,4967914,4967915,4967916,4967917,4967918,4967919,4967920,4967921,4967922,4967923,4967924,4967925,4967926,4967927,4967980,4967982,4967992,4967993,4967994,4967995,4968021,4968022,4968023,4968024,4968025,4968026,4968080,4968087,4968104,4968109,4968113,4968115,4968119,8074064,8074065,8074066,8074067,8074068,8074069,8074107,8074108,8074109,8074110,8074111,8074596,8074597,8074598,8074599,8074600,8074601,8074602,8074603,8074604,8074605,8074606,8074607,8074608,8074609,8074610,8074611,8074612,8074613,8074614,8074615,8074616,8074617,8074618,8074619,8074620,8074621,8074622,8074623,8074624,8074625,8074626,8074627,8074628,8074629,8074630,8074631,8074632,8074633,8074634,8074635,8074636,8074637,8074638,8074639,8074640,8074641,8074642,8074643,8074644,8074645,8074646,8074647,8074648,8074649,8074650,8074651,8074652,8074653,8074654,8074655,8074656,8074657,8074658,8074659,8074660,8074661,8074662,8074663,8074664,8074665,8074666,8074667,8074668,8074669,8071773,8071774,8071775,8071776,8071777,8071778,8071779,8071780,8071781,8071782,8071783,8071784,8071785,8071786,8071787,8071788,8071789,8071790,8071791,8071792,8071793,8071794,8071795,8071796,8071797,8071798,8071799,8071800,8071801,8071802,8071803,8071804,8071805,8071806,8071807,8071808,8071809,8071810,8071811,8071812,8071813,8071814,8071815,8071816,8071817,8071818,8071819,8071820,8071821,8071822,8071823,8071824,8071825,8071826,8071827,8071828,8071829,8071830,8071831,8071832,8071833,8071834,8071835,8071836,8071837,8071838,8071839,8071840,8071841,8071842,8071843,8071844,8071845,8071846,8071847,8071848,8071849,8071850,8071851,8071852,8071853,8071854,8071855,8071856,8071857,8071858,8071859,8071860,8071861,8071862,8071863,8071864,8071865,8071866,8071867,8071868,8071869,8071870,8071871,8071872,8071873,8071874,8071875,8071876,8071877,8071878,8071879,8071880,8071881,8071882,8071883,8071884,8071885,8071886,8071887,8071888,8071889,8071890,8071891,8071892,8071893,8071894,8071895,8071896,8071897,8071898,8071899,8071900,8071901,8071902,8072384,8072437,8072560,8072561,8072588,8072589,8072600,8072601,8072602,8072603,8072604,8072605,8072606,8072607,8072608,8072609,8072647,8072652,8072657,8072662,8072667,8072672,8072677,8072682,8072687,8072692,8072697,8072702,8072707,8072712,8072717,8072722,8072727,8072732,8072737,8072742,8072747,8072752,8072757,8072762,8072763,8072764,8072765,8072766,8072767,8072772,8072777,8072782,8072787,8072792,8072800,8072808,8072816,8072824,8072832,8072840,8072852,8072860,8072872,8072880,8072886,8072887,8072888,8072889,8072890,8072892,8072893,8072894,8072895,8072896,8072908,8072916,8072924,8072931,8072942,8072949,8072957,8072965,8072973,8072981,8072995,8073029,8073030,8073031,8073032,8073033,8073034,8073035,8073064,8073065,8073093,8073220,8073221,8073222,8073224,8073225,8073226,8073227,8073228,8073230,8073231,8073232,8073233,8073234,8073238,8073239,8073240,8073241,8073242,8073243,8073248,8073249,8073250,8073251,8073253,8073254,8073255,8073256,8073257,8073258,8073259,8073260,8073261,8073262,8073263,8073391,8073392,8073396,8073397,8073399,8073400,8073404,8073405,8073406,8073468,8073470,8073476,8073485,8073486,8073490,8073497,8073501,8073510,8073518,8073523,8073524,8073542,8073552,10622966,10622967,10622968,10622969,10622970,10622971,10622972,10622974,10622975,10622976,10623003,10623042,10623045,10623057,10623058,10623067,10623070,10623174,10623175,10623176,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623198,10623208,10623252,10623261,10623262,10623263,10623264,10623265,10623266,10623267,10623268,10623269,10623270,10623271,10623272,10623273,10623274,10623275,10623276,10623277,10623278,10623279,10623280,10623281,10623282,10623283,10623284,10623285,10623286,10623287,10623288,10623289,10623290,10623304,10623307,10623345,10623399,10623400,10623401,10623402,10623403,10623404,10623405,10623406,10623407,10623408,10623409,10623410,10623411,10623412,10623413,10623414,10623415,10623416,10623417,10623418,10623419,10623420,10623421,10623422,10623423,10623424,10623425,10623426,10623427,10623428,10623429,10623430,10623431,10623432,10623433,10623434,10623435,10623436,10623437,10623438,10623439,10623440,10623441,10623442,10623443,10623444,10623445,10623446,10623447,10623448,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,10623478,10623479,10623480,10623489,10623491,10623492,10623498,10623499,10623500,10623502,10623503,10623507,10623566,10623571,10623572,10623573,10623582,10623591,10623592,10623609,10623613,10623627,10623640,10623641,10623642,10623643,10623713,10623723,10623724,10623725,10623726,10623727,10623728,10623729,10623730,10623746,10623768,10623770,10623784,10623796,10623824,10623850,10623852,10623858,10623889,10623910,10623936,10623955,10623965,10623968,10623969,10623970,10623971,10623972,10623973,10623974,10623975,10623976,10623977,10623978,10623979,10623980,10623981,10623982,10623983,10623984,10623985,10623986,10623987,10623988,10623989,10623990,10623991,10623992,10623993,10623994,10623995,10623996,10623997,10623998,10623999,10624000,10624001,10624002,10624003,10624004,10624005,10624006,10624007,10624008) 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'