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(4970152,4970153,4970154,4970155,4970156,4970157,4970158,4970159,4970160,4970161,4970162,4970163,4970164,4970165,4970166,4970167,4970168,4970169,4970170,4970171,4970172,4970173,4970174,4970175,4970176,4970177,4970178,4970179,4970180,4970181,4970182,4970183,4970184,4970185,4970186,4970187,4970188,4970189,4970190,4970191,4970192,4970193,4970194,4970195,4970196,4970197,4970198,4970199,4970200,4970201,4970202,4970203,4970204,4970205,4970206,4970207,4970208,4970209,4970210,4970211,4970212,4970213,4970214,4970215,4970216,4970217,4970218,4970219,4970220,4970221,4970222,4970223,4970224,4970225,4970226,4970227,4970228,4970229,4970230,4970231,4970232,4970233,4970234,4970235,4970236,4970237,4970238,4970239,4970240,4970241,4970242,4970243,4970244,4970245,4970246,4970247,4970248,4970249,4970250,4970251,4970252,4970253,4970254,4970255,4970256,4970257,4970258,4970259,4970260,4970261,4970262,4970263,4970264,4970265,4970266,4970267,4970268,4970269,4970270,4970271,4970272,4970273,4970274,4970275,4970276,4970277,4970278,4970279,4970280,4970281,4970282,4970283,4970284,4970285,4970286,4970287,4970288,4970289,4970290,4970291,4970292,4970293,4970294,4970295,4970296,4970297,4970298,4970299,4970300,4970301,4970302,4970303,4970304,4970305,4970306,4970307,4970308,4970309,4970310,4970311,4970312,4970313,4970314,4970315,4970316,4970317,4970318,4970319,4970320,4970321,4970322,4970323,4970324,4970325,4970326,4970327,4970328,4970329,4970330,4970331,4970332,4970333,4970334,4970335,4970336,4970337,4970338,4970339,4970340,4970341,4970342,4970343,4970344,4970345,4970346,4970347,4970348,4970349,4970350,4970351,4970352,4970353,4970354,4970355,4970356,4970357,4970358,4970359,4970360,4970361,4970362,4970363,4970364,4970365,4970366,4970367,4970368,4970369,4970370,4970371,4970372,4970373,4970374,4970375,4970376,4970377,4970378,4970379,4970380,4970381,4970382,4970383,4970384,4970385,4970386,4970387,4970388,4970389,4970390,4970391,4970392,4970393,4970394,4970395,4970396,4970397,4970398,4970399,4970400,4970401,4970402,4970403,4970404,4970405,4970406,4970407,4970408,4970409,4970410,4970411,4970412,4970413,4970414,4970415,4970416,4970417,4970418,4970419,4970420,4970421,4970422,4970423,4970424,4970425,4970426,4970427,4970428,4970429,4970430,4970431,4970432,4970433,4970434,4970435,4970436,4970437,4970438,4970439,4970440,4970441,4970442,4970443,4970444,4970445,4970446,4970447,4970448,4970449,4970450,4970451,4970452,4970453,4970454,4970455,4970456,4970457,4970458,4970459,4970460,4970461,4970462,4970463,4970464,4970465,4970466,4970467,4970468,4970469,4970470,4970471,4970472,4970473,4970474,4970475,4970476,4970477,4970478,4970479,4970480,4970481,4970482,4970483,4970484,4970485,4970486,4970487,4970488,4970489,4970490,4970491,4970492,4970493,4970494,4970495,4970496,4970497,4970498,4970499,4970500,4970501,4970502,4970503,4970504,4970505,4970506,4970507,4970508,4970509,4970510,4970511,4970512,4970513,4970514,4970515,4970516,4970517,4970518,4970519,4970520,4970521,4970522,4970523,4970524,4970525,4970526,4970527,4970528,4970529,4970530,4970531,4970532,4970533,4970534,4970535,4970536,4970537,4970538,4970539,4970540,4970541,4970542,4970543,4970544,4970545,4970546,4970547,4970548,4970549,4970550,4970551,4970552,4970553,4970554,4970555,4970556,4970557,4970558,4970559,4970560,4970561,4970562,4970563,4970564,4970565,4970566,4970567,4970568,4970569,4970570,4970571,4970572,4970573,4970574,4970575,4970576,4970577,4970578,4970579,4970580,4970581,4970582,4970583,4970584,4970585,4970586,4970587,4970588,4970589,4970590,4970591,4970592,4970593,4970594,4970595,4970596,4970597,4970598,4970599,4970600,4970601,4970602,4970603,4970604,4970605,4970606,4970607,4970608,4970609,4970610,4970611,4970612,4970613,4970614,4970615,4970616,4970617,4970618,4970619,4970620,4970621,4970622,4970623,4970624,4970625,4970626,4970627,4970628,4970629,4970630,4970631,4970632,4970633,4970634,4970635,4970636,4970637,4970638,4970639,4970640,4970641,4970642,4970643,4970644,4970645,4970646,4970647,4970648,4970649,4970650,4970651,4970652,4970653,4970654,4970655,4970656,4970657,4970658,4970659,4970660,4970661,4970662,4970663,4970664,4970665,4970666,4970667,4970668,4970669,4970670,4970671,4970672,4970673,4970674,4970675,4970676,4970677,4970678,4970679,4970680,4970681,4970682,4970683,4970684,4970685,4970686,4970687,4970688,4970689,4970690,4970691,4970692,4970693,4970694,4970695,4970696,4970697,4970698,4970699,4970700,4970701,4970702,4970703,4970704,4970705,4970706,4970707,4970708,4970709,4970710,4970711,4970712,4970713,4970714,4970715,4970716,4970717,4970718,4970719,4970720,4970721,4970722,4970723,4970724,4970725,4970726,4970727,4970728,4970729,4970730,4970731,4970732,4970733,4970734,4970735,4970736,4970737,4970738,4970739,4970740,4970741,4970742,4970743,4970744,4970745,4970746,4970747,4970748,4970749,4970750,4970751,4970752,4970753,4970754,4970755,4970756,4970757,4970758,4970759,4970760,4970761,4970762,4970763,4970764,4970765,4970766,4970767,4970768,4970769,4970770,4970771,4970772,4970773,4970774,4970775,4970776,4970777,4970778,4970779,4970780,4970781,4970782,4970783,4970784,4970785,4970786,4970787,4970788,4970789,4970790,4970791,4970792,4970793,4970794,4970795,4970796,4970797,4970798,4970799,4970800,4970801,4970802,4970803,4970804,4970805,4970806,4970807,4970808,4970809,4970810,4970811,4970812,4970813,4970814,4970815,4970816,4970817,4970818,4970819,4970820,4970821,4970822,4970823,4970824,4970825,4970826,4970827,4970828,4970829,4970830,4970831,4970832,4970833,4970834,4970835,4970836,4970837,4970838,4970839,4970840,4970841,4970842,4970843,4970844,4970845,4970846,4970847,4970848,4970849,4970850,4970851,4970852,4970853,4970854,4970855,4970856,4970857,4970858,4970859,4970860,4970861,4970862,4970863,4970864,4970865,4970866,4970867,4970868,4970869,4970870,4970871,4970872,4970873,4970874,4970875,4970876,4970877,4970878,4970879,4970880,4970881,4970882,4970883,4970884,4970885,4970886,4970887,4970888,4970889,4970890,4970891,4970892,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,4970924,4970925,4970926,4970927,4970928,4970929,4970930,4970931,4970932,4970933,4970934,4970935,4970936,4970937,4970938,4970939,4970940,4970941,4970942,4970943,4970944,4970945,4970946,4970947,4970948,4970949,4970950,4970951,4970952,4970953,4970954,4970955,4970956,4970957,4970958,4970959,4970960,4970961,4970962,4970963,4970964,4970965,4970966,4970967,4970968,4970969,4970970,4970971,4970972,4970973,4970974,4970975,4970976,4970977,4970978,4970979,4970980,4970981,4970982,4970983,4970984,4970985,4970986,4970987,4970988,4970989,4970990,4970991,4970992,4970993,4970994,4970995,4970996,4970997,4970998,4970999,4971000,4971001,4971002,4971003,4971004,4971005,4971006,4971007,4971008,4971009,4971010,4971011,4971012,4971013,4971014,4971015,4971016,4971017,4971018,4971019,4971020,4971021,4971022,4971023,4971024,4971025,4971026,4971027,4971028,4971029,4971030,4971031,4971032,4971033,4971034,4971035,4971036,4971037,4971038,4971039,4971040,4971041,4971042,4971043,4971044,4971045,4971046,4971047,4971048,4971049,4971050,4971051,4971052,4971053,4971054,4971055,4971056,4971057,4971058,4971059,4971060,4971061,4971062,4971063,4971064,4971065,4971066,4971067,4971068,4971069,4971070,4971071,4971072,4971073,4971074,4971075,4971076,4971077,4971078,4971079,4971080,4971081,4971082,4971083,4971084,4971085,4971086,4971087,4971088,4971089,4971090,4971091,4971092,4971093,4971094,4971095,4971096,4971097,4971098,4971099,4971100,4971101,4971102,4971103,4971104,4971105,4971106,4971107,4971108,4971109,4971110,4971111,4971112,4971113,4971114,4971115,4971116,4971117,4971118,4971119,4971120,4971121,4971122,4971123,4971124,4971125,4971126,4971127,4971128,4971129,4971130,4971131,4971132,4971133,4971134,4971135,4971136,4971137,4971138,4971139,4971140,4971141,4971142,4971143,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151) 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'