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(4970259,4970272,4970494,4970495,4970496,4970497,4970498,4970499,4970652,4970657,4970658,4970666,4970674,4970688,4970700,4970714,4970715,4970716,4970717,4970718,4970728,4970738,4970739,4970740,4970741,4970745,4970763,4970765,4970766,4970776,4970852,4970872,4970895,4970903,4970904,4970920,4970925,4970926,4970936,4970937,4970946,4970947,4970948,4970960,4970961,4970962,4970971,4970976,4970980,4970988,4970994,4971016,4971017,4971024,4971025,4971026,4971027,4971054,4971055,4971056,4971057,4971058,4971060,4971061,4971062,4971063,4971081,4971143,4968152,4968153,4968154,4968155,4968156,4968157,4968158,4968159,4968160,4968161,4968162,4968163,4968164,4968165,4968166,4968167,4968168,4968169,4968170,4968172,4968175,4968184,4968187,4968192,4968199,4968200,4968201,4968202,4968203,4968204,4968205,4968206,4968207,4968208,4968209,4968210,4968211,4968212,4968213,4968214,4968215,4968216,4968217,4968218,4968219,4968220,4968221,4968222,4968223,4968224,4968225,4968226,4968227,4968228,4968229,4968230,4968231,4968232,4968233,4968234,4968254,4968260,4968268,4968269,4968270,4968271,4968300,4968301,4968302,4968303,4968320,4968321,4968322,4968323,4968324,4968325,4968326,4968327,4968328,4968329,4968330,4968331,4968332,4968333,4968334,4968335,4968336,4968337,4968338,4968339,4968340,4968341,4968374,4968404,4968405,4968406,4968407,4968408,4968433,4968434,4968435,4968436,4968437,4968438,4968439,4968440,4968441,4968442,4968443,4968444,4968445,4968446,4968447,4968448,4968449,4968450,4968451,4968469,4968470,4968471,4968472,4968473,4968481,4968503,4968504,4968510,4968523,4968524,4968525,4968526,4968527,4968528,4968529,4968530,4968531,4968532,4968533,4968534,4968535,4968536,4968537,4968538,4968539,4968540,4968546,4968557,4968558,4968559,4968560,4968561,4968562,4968563,4968564,4968565,4968579,4968581,4968582,4968587,4968593,4968595,4968602,4968603,4968609,4968620,4968624,4968635,4968637,4968642,4968643,4968644,4968645,4968646,4968647,4968648,4968649,4968650,4968651,4968652,4968653,4968668,4968669,4968670,4968671,4968681,4968682,4968685,4968692,4968698,4968699,4968700,4968716,4968717,4968718,4968719,4968720,4968721,4968722,4968723,4968754,4968764,4968773,4968784,4968793,4968800,4968802,4968803,4968808,4968809,4968810,4968811,4968812,4968813,4968814,4968815,4968816,4968817,4968818,4968819,4968820,4968821,4968822,4968823,4968824,4968825,4968826,4968827,4968828,4968829,4968830,4968831,4968837,4968838,4968839,4968840,4968843,4968849,4968859,4968860,4968897,4968927,4968928,4968929,4968930,4968931,4968932,4968933,4968939,4968945,4968946,4968948,4968949,4968950,4968951,4968952,4968953,4968954,4968955,4968956,4968957,4968958,4968959,4968960,4968961,4968962,4968963,4968964,4968965,4968966,4968967,4969002,4969011,4969012,4969013,4969014,4969015,4969025,4969039,4969042,4969045,4969051,4969052,4969053,4969054,4969055,4969094,4969105,4969109,4969136,4969154,4969160,4969164,4969168,4969169,4969170,4969175,4969177,4969181,4969199,4969223,4969229,4969527,4969528,4969544,4969545,4969546,4969552,4969553,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,4969615,4969616,4969617,4969618,4969619,4969620,4969621,4969622,4969623,4969624,4969625,4969626,4969627,4969990,4969991,4969992,4969993,8075245,8075253,8075321,8075346,8075347,8075348,8075349,8075350,8075351,8075352,8075353,8075354,8075355,8075356,8075359,8075360,8075361,8075362,8075363,8075366,8075367,8075368,8075369,4967027,4967028,4967029,4967030,4967031,4967045,4967108,4967110,4967113,4967130,4967134,4967140,4967480,4967481,4967482,4967483,4967484,4967485,4967486,4967487,4967488,4967516,4967517,4967518,4967519,4967520,4967521,4967522,4967523,4967524,4967525,4967526,4967527,4967528,4967529,4967530,4967531,4967532,4967533,4967534,4967878,4967879,4967880,4967881,4967882,4967896,4967897,4967934,4967935,4967997,4967998,4967999,4968000,4968001,4968002,4968003,4968029,4968033,4968035,4968049,4968058,4968060,4968074,4968075,4968076,4968077,4968078,4968086,4968093,4968118,4968119,4968121,4968122,4968123,4968124,4968125,4968126,4968127,4968128,4968129,4968130,4968131,4968132,4968133,4968134,4968135,4968144,4968145,4968146,4968147,4968148,4968149,4968150,4968151,8072362,8072363,8072364,8072365,8072366,8072367,8072375,8072376,8072377,8072378,8072379,8072380,8072381,8072382,8072397,8072398,8072399,8072400,8072401,8072402,8072403,8072404,8072405,8072406,8072413,8072414,8072415,8072416,8072423,8072424,8072425,8072426,8072429,8072430,8072431,8072432,8072433,8072443,8072444,8072445,8072446,8072455,8072456,8072457,8072458,8072470,8072471,8072535,8072536,8072537,8072538,8072539,8072562,8072563,8072564,8072565,8072698,8072699,8072700,8072701,8072702,8072703,8072704,8072705,8072706,8072707,8072708,8072709,8072710,8072711,8072712,8072713,8072714,8072715,8072716,8072717,8072718,8072719,8072720,8072721,8072722,8072723,8072724,8072725,8072726,8072727,8072728,8072729,8072730,8072731,8072732,8072733,8072734,8072735,8072736,8072737,8072738,8072739,8072740,8072741,8072742,8072743,8072744,8072745,8072746,8072747,8072748,8072749,8072750,8072751,8072752,8072848,8072849,8072850,8072851,8072852,8072856,8072857,8072858,8072859,8072860,8073077,8073479,8073481,8073482,8073483,8073484,8073494,8073528,8073529,8073538,10622972,10622974,10623065,10623100,10623125,10623126,10623164,10623185,10623186,10623187,10623188,10623189,10623190,10623191,10623192,10623193,10623194,10623195,10623196,10623197,10623201,10623202,10623203,10623204,10623205,10623206,10623207,10623215,10623216,10623328,10623355,10623356,10623357,10623358,10623359,10623360,10623361,10623362,10623363,10623364,10623365,10623422,10623451,10623494,10623503,10623505,10623576,10623577,10623584,10623652,10623653,10623654,10623658,10623788,10623789,10623805,10623869,10623870,10623871,10623890,10623891,10623892,10623893,10624016,10624017,10624058,10624059,10624060,10624061,10624062,10624063,10624064,10624065,10624066,10624067,10624068,10624069,10624070,10624071,10624072,10624073,10624074,10624075,10624076,10624263,10624356,10624357,10624358,10624359,10624360,10624361,10624362,10624363,10624399,10624533,10624538,10624539,10624547,10624549,10624609,10624610,10624611,10624658,10624734,10624818,10624819,10624820,10624821,10624822,10624823,10624824,10624825,10624826,10624827,10624828,10624829,10624830,10624831,10624832,10624833,10624834,10624835,10624836,10624837,10624838,10624839,10624840,10624841,10624842,10624843,10624896,10624897,10624953,10624954,10624955,10624956,10624957,10624958,10624959,10624960,10621979,10621980,10621982,10621997,10621998,10621999,10622000,10622001,10622002,10622003,10622004,10622005,10622006,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622025,10622031,10622044,10622046,10622047,10622049,10622050,10622051,10622054,10622057,10622059,10622061,10622062,10622063,10622064,10622065,10622066,10622074,10622075,10622076,10622083,10622088,10622089,10622090,10622093,10622095,10622102,10622103,10622116,10622117,10622118,10622119,10622120,10622121,10622127,10622128,10622129,10622130,10622132,10622197,10622261,10622263,10622274,10622277,10622306,10622325,10622329,10622330,10622335,10622337,10622338,10622341,10622343,10622345,10622346,10622347,10622348,10622349,10622350,10622351,10622352,10622353,10622354,10622355,10622356,10622357,10622358,10622359,10622364,10622371,10622379,10622381,10622382,10622383,10622384,10622385,10622386,10622387,10622388,10622389,10622390,10622391,10622392,10622393,10622394,10622395,10622396,10622397,10622398,10622402,10622403,10622404,10622405,10622406,10622407,10622410,10622414,10622427,10622429,10622430,10622445,10622457,10622464,10622465,10622466,10622478,10622504,10622544,10622545,10622656,10622657,10622660,10622672,10622673,10622674,10622675,10622677,10622678,10622679,10622680,10622681,10622701,10622702,10622703,10622714,10622727,10622728,10622729,10622734,10622735,10622750,10622773,10622801,10622802,10622803,10622804,10622805,10622806,10622807,10622808,10622809,10622818,10622819,10622820,10622850,10622851,10622852,10622853,10622854,10622855,10622856,10622857,10622858,10622859,10622873,10622916,10622919,10622926,10622931,10622946,10622947,10619964,10619985,10619986,10619999,10620000,10620001,10620011,10620012,10620013,10620017,10620029,10620045,10620046,10620047,10620056,10620057,10620058,10620059,10620065,10620068,10620074,10620080,10620096,10620106,10620121,10620123,10620132,10620166) 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'