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(8630766,3228555,8574477,8574486,8574488,8574494,8574507,8574531,8574532,8574533,3228947,4970758,4970767,3229030,11041316,3229120,3229121,3229122,3229132,7065980,7066017,8583495,7066060,10950705,10950756,10950763,10990306,10990307,8609572,8609573,10929243,8573237,8573238,8573252,8573253,8573254,8573255,8630431,10939432,10930108,7201273,7201281,8594736,8594795,8594945,8595088,8628215,8595231,3899091,8595236,8595242,8595245,7201965,8065820,8065833,7202127,7202339,7202340,8628812,5654562,5654564,5654651,8628997,8628998,3227101,3227185,8629476,10933212,8910256,8910257,8910258,7200505,8834750,8834762,7200779,11037331,7200895,7200934,10931197,7198193,8624653,8624654,8624679,8624680,8614926,8908231,8908266,8624925,3235779,3235780,3235781,7198677,7198682,8908500,7198734,7198735,7198742,7198744,7198745,7198747,7198748,7198749,7198751,7198757,7198761,7198768,7198783,7198785,8625285,8625286,8625288,8625290,8625299,8625300,8625301,8625303,8625307,8625308,8625309,8625310,8625311,8625312,8625313,8625314,8625315,8625316,8625317,7198946,8625385,8625386,8625387,8625388,8625389,8625392,8625393,8625395,7199113,7199173,7199177,7199360,7199378,7199441,7199482,7199483,7199529,7199530,7199531,7199532,7199533,7199549,7199554,7199555,7199559,7199560,7199561,7199611,7199620,7199621,7199647,11048307,7199652,11048308,7199668,10101561,11048365,7199749,7199750,7199765,7199768,7199769,11048478,3237340,8906040,8906041,7196243,7196244,7196246,3923393,7196247,8906120,8906134,8906135,8906136,8906157,8906158,8906159,8906160,8906161,3923539,8906218,8906263,8906264,3923635,8906306,8906307,8906308,8906324,8906325,8906326,8906327,3923669,8906401,8906470,8906480,7196685,8906519,8906520,8906524,8906526,10623498,8906536,8906547,7196752,8906568,8906585,8906586,8906587,8906590,7196809,7196853,7196854,7196866,8906804,8906849,8906854,8906855,8906856,8906858,8906859,7197111,7197133,8906952,7197239,10838782,10838910,7197420,7197427,7197431,10838948,10838949,10838950,7197454,3234854,3234857,3234863,3234867,3234868,3234869,7197871,7198010,7198029,7198054,3232354,10616968,10616969,8905062,10617099,10617120,10617131,10617172,10617174,10617198,8905267,11044917,8905316,8905353,10622344,8905379,8905380,10622428,3232891,3232892,8905555,8905556,3922922,8905859,8905880,8905973,8905974,8905975,8905976,10615019,10615038,10615039,10615040,10615041,10615052,10615053,10615054,10615056,10615057,10615061,10615065,10615066,10615067,10615072,10615080,10425566,10615252,10615314,10615323,10615324,10615352,10615357,10615405,10615406,10615407,10615408,10615409,10615425,10615430,10615434,10615442,10615449,10615450,10615472,10615499,10615503,10615540,10615549,10615560,10615577,8633197,10615588,10615592,10615596,10615605,10615634,10615668,8633335,10615721,10615824,10615866,10615874,10615876,10426223,10615886,10615899,10426244,10615954,10615959,10615988,10615992,10426334,10616003,10616013,8540519,8540520,10426393,8540595,8540600,8540606,8540613,8540628,10616195,3231591,8904491,8904492,8904506,8611314,8904561,8904562,8904577,8611408,8611425,8611435,8611436,10616716,10616736,10616864,10616893,8904946,8634561,8634562,10614025,8863906,10611051,10614092,10614093,10611114,10614253,10611277,10714175,10614424,10614426,10611466,10611519,10614633,10614637,8853816,8853817,10614742,10614793,10614849,10611885,10614952,10611956,10611958,8851125,8851130,10611968,8851134,8851139,8851142,8851144,8851148,8851153,8851155,8851158,8851162,8851168,8851171,10612009,8851176,8851196,10609043,10609044,10612095,10612096,10612097,8851265,8851267,8851269,8851270,8851274,8851300,8851301,8851323,8851337,8851344,8851355,8851361,8851396,10612263,10609379,7017421,7017422,7017423,7017424,10612441,10612442,10612497,10612512,8851684,8851709,10612575,8851750,10609662,10609695,10609748,10609769,8851942,8851987,10609826,10609844,10609884,10609890,10612892,10612894,10609904,10612916,10612921,10612929,7017938,9220274,7017958,7017978,10613057,10613058,10610072,10613086,10613087,10613088,10613097,10613098,10613099,10613100,10613101,10613102,10613103,10613104,10613105,10613106,10613107,10613108,10613109,10613110,10613124,8852312,8852354,8852372,8852375,10613245,10613316,10610353,10613371,8852554,10610418,10610419,10613430,10613523,8852736,9172930,8852781,10610694,10613811,10613817,10610862,10610941,10610942,10613958,7055465,7055473,7055510,7055561,7055562,9169407,9169478,9169479,9169480,9169492,9169505,6673730,7015178,7015199,10117744,9169552,9169556,9169559,7015220,6673784,7015241,7015262,10117832,10117833,9169648,9169650,9169668,10117877,9169686,10117886,9169719,10118052,10118053,8849714,6674157,8849781,9161963,10118189,10118199,6674289,10118303,10118305,10118374,10118375,10118377,10118379,10118386,10118419,8850072,10118494,10118495,10118497,10118500,10118501,10118502,8850230,7016164,8850595,8850615,6672551,10418285,10416289,10418295,10419299,10419315,10417316,10417324,10417325,9168407,10419343,10417343,10419344,10417344,10417345,6672653,10417396,9168484,10415426,6672714,10415435,10415453,10419463,10415475,10418478,10418479,10418486,10417501,10418533,10418534,10418535,10416537,10418550,10418551,10417553,10417554,10417560,10417576,10418622,10418623,10418624,10418625,10418626,10417738,10415760,10419797,10416799,6673088,10418809,10418810,10418811,10418812,10418813,10418814,10418815,6673120,6673125,10415851,10415852,10415853,10415854,10416934,10417949,10415970,10416975,9169177,10419122,10419123,10419124,10419125,10419126,10419127,10419128,10419129,10419130,10419131,10419132,10419133,10419134,10419135,10419136,10419137,10418141,10419145,10419146,10419147,10418151,7055395,10418156,10418157,10418158,10418159,10419163,10418168,10418176,9169255,10418178,10417181,10417182,8549556,6670688,6670689,10471121,10471124,8549932,8550061,8550097,10467534,8550157,8550174,10469714,10469715,10469791,10469792,10469793,10469894,10469897,10469898,10469899,10469942,10469965,9183394,10469972,10469973,10469974,10470025,10470026,10470027,10470057,10470091,10470137,10464213,10464230,10468295,10468304,10464312,10464323,10464324,10464325,10464326,9167780,10464361,10464389,10464398,10468428,9167973,10470676,10470679,10470711,10470723,9168166,9168200,9168201,10888503,10888539,10888562,10888570,10888573,10888589,10888607,10888640,10888657,10888660,10628157,10888680,10888682,10888690,10888699,10888718,10888796,10888811,10888818,10888819,10888838,10888839,10888898,10888922,10888923,10883960,10888975,10888987,10888996,10889024,10889042,10884075,10884076,10889167,10889219,10889291,10889314,10884427,10884460,10884461,10884581,10889584,10889585,10884642,10884695,10889712,10889713,10889714,10889715,10889716,10889720,10889745,10884761,10884795,10889909,10889924,10889926,10890028,10885028,10875050,10885087,10875088,10875090,10875194,10875195,10890202,10885229,10875234,10875235,10875236,10875237,10885316,10885379,10885413,10877529,10877534,10877535,10877588,10877599,10882613,10882694,10887700,10882707,10882718,10887847,10887859,10887860,10882865,10882891,10882900,10882913,10882914,10627411,10882941,10887945,10887956,10882982,10887996,10627666,10883189,10888301,10888397,10888398,10888399,10888400,10888405,10888408,10888413,10888435,10888441,10883445,10888453,10888454,10883454,10888455,10883455,10883456,10885530,10885531,10885532,10885533,10885534,10885535,10630045,10885759,10885760,10885761,10885867,10885906,10885908,10161967,10880978,10162121,10162167,10162170,10162171,10162172,10162221,10162269,10886396,10886491,10881581,10876588,10886610,10886751,10886752,10886753,10876808,10876809,10876816,10876817,10876818,10876819,10876820,10876821,10876825,10886866,10168012,10887060,10882061,10877177,10882280,10887387,10887390,10887391,10887407,10882436,10887437,10887438,10887439,10882454,10882455,10882456,10882457,10647337,10647342,10647361,10647501,10647640,10647641,10647664,10647691,10647692,10647694,10647696,10647697,10647698,10647699,10582559,10529727,10527948,10546486,10546487,10546488,10546491,10546492,10546493,10546494,10546495,10546504,10546505,10546506,10546507,10546510,10546511,10546512,10546542,10546543,10546544,10546545,10546546,10546547,10546548,10546634,10546635,10546637,10524923,10507594,10507599,10507600,10507601,10507602,10507603,10507604,10506786,10507829,10507830,10507920,10508012,10482901,10409465,10409466,10409467,10409468,10409496,10409617,10409974,10409975,10409976,10409977,10477682,10477685,10477686,10410058,10410059,10410060,10410061,10410062,10410063,10410064,10410098,10410105,10410110,10410113,10410118,10410128,10410704,10410724,10410756,10410757,10410758,10410759,10410760,10410761,10410762,10410763,10410768,10408825,10408826,10408827,10408828,10408829,10408830,10408831,10408832,10408833,10487525) 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'