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(10939590,10943427,10943437,10939651,10939704,10939705,10939706,10939707,7068166,7068177,7068253,10939944,7076325,7068326,7076331,7068343,7068351,7068368,8569555,7068618,7068632,7068650,7068654,7068658,10976346,7068665,10940336,10940337,10963399,7068740,4970978,7068765,7068768,7068775,10940420,8569778,8569794,8569795,7068821,8569798,8569800,8569801,7068828,8569804,7068830,7068831,7068833,7068834,7068835,7068836,7068837,8569818,7068851,8569869,8569887,10976601,7068917,7068926,7068928,7073974,10976751,7074107,10976793,10976794,10976795,10976796,10976797,10976798,10976799,10976800,10976801,10976802,10976803,10976804,10976861,10976862,10976863,10976864,10976865,10976866,8067224,7074250,10976992,8067516,7074597,10977285,7074615,7066654,7074675,10977408,7074744,7066750,7074778,10977471,10977472,10964487,7074803,10964489,10977491,10964494,10964499,10964500,10964501,10964502,10964503,10964504,10964505,10964506,10964507,10964508,10964509,10964510,10964511,10964512,10964513,10964514,10964515,10964516,10938478,7074909,10964600,7074936,8067903,7067084,8068022,8068069,8068071,8068073,7067204,8068133,10961928,8068136,10961929,8068143,7067270,8068311,8068314,7075466,8068398,8068420,8068464,8068472,8068493,8068494,8068495,8068496,8068497,8068498,8068499,8068500,8068501,8068502,8068503,8068504,8068505,8068506,8068507,8068508,8068524,8068525,8068526,8068527,8068540,8068541,8068542,8068543,8068544,8068545,8068546,7067748,10975536,10975537,7075904,7067932,10972696,7064048,7064050,10931570,10931584,10972977,10972978,10972979,10972980,10972981,10972982,10972983,10972984,10972985,10972986,10972987,10972988,10972989,10972990,10972991,10972992,10972993,10972994,10972995,10972996,10972997,10972998,10972999,10973000,10973001,10973002,10973003,10973004,10960004,10973005,10973006,10973007,10973008,10973009,10973010,10973011,10973012,10973013,10973014,10973015,10973016,10973017,10973018,10973019,10973020,10973021,10973022,10973023,10973024,10973025,10973026,10973027,10973028,10973029,10973030,10973031,10973032,10973033,10973034,10973035,10973036,10973037,10973038,10960051,10973107,10973108,10973109,10973113,10960123,10973188,10960214,10960228,10960229,10973340,7072677,7072678,7072702,7072704,10932096,7072754,8065798,4967040,4967041,4967044,4967051,4967067,7072876,7072885,7072886,10960624,7072943,10960630,10960633,10960638,10960641,10960644,10960645,10960648,7073008,7073009,7073010,10960704,7073041,7073044,7073047,7073063,7073064,7073094,7073096,7073103,7073140,7073141,8066209,8066210,8066211,8066214,8066216,7073277,8066269,7073449,8066498,8066499,8066500,8066501,8066502,8066503,8066504,8066505,8066506,8066508,8066509,10961223,10961224,10961225,10961374,10961375,10961467,8066880,7065906,7070996,8063984,10971750,10942709,11049009,10942747,10942763,10971872,10942814,10971881,10971886,10971887,10942878,10972000,10972006,10972036,10972037,10972073,10972074,10972099,10943049,10972209,10972210,10972213,10972267,10972268,10972269,10972270,7071600,7071620,7071621,7071642,7071690,7071748,7071750,10972463,10972465,10972468,10972471,10972476,7071805,8970215,10972603,10972607,7068945,10969684,10969685,10969686,10969687,10969688,7069059,10969770,10969920,7069269,7069270,7069271,7069272,7069273,7069274,7069275,7069276,7069277,7069278,7069309,7069310,7069379,7069410,7069421,10970207,10970225,10970238,7069597,3656223,11047587,3656278,10941344,3656460,10970662,3656597,10941692,10941697,10941699,10941702,7070087,10970887,10971029,10941994,10971067,10942013,10942058,7070459,10942141,11048592,10971490,10971494,7070810,10971505,7070822,7070823,7070824,10942457,7070851,7070855,10918472,10918473,10918474,10923476,10923477,10923478,10923479,10923533,10928563,10928564,10918603,10928604,10928605,10928606,10928607,10928608,10618121,10918634,10918635,10918636,10918637,10918638,10918639,10918640,10928657,10928673,10928677,10923730,10623300,10623301,10623302,10623312,10618371,10968057,10923966,10924132,10924137,10919178,10919179,10919180,10919181,10924264,10968422,10924292,10968591,10919479,10919480,10919481,10924594,10924595,10968773,10968777,10624203,10619227,10968893,10619310,10619311,10619312,10619313,10619314,10619315,10619316,10619317,10619318,10619319,10619320,10619321,10619322,10619323,10919944,10924979,10924982,10924984,10924992,10925382,10925436,10925459,10966686,10622104,10622105,10622114,10622129,10617143,10922709,10617233,10922817,10922818,10922819,10927836,10922862,10617357,10617358,10617359,10617360,10922911,10617427,10927978,10923028,10954234,10622656,10622662,10928210,10923231,10928253,10923279,10923401,10622892,10923402,10923403,10923404,10923405,10923447,10923448,10923449,10923450,10923451,10918471,10615014,10615077,10920596,10920597,10920753,10920765,10920766,10920784,10920785,10920786,10920794,10920796,10964949,10964950,10620294,10620296,10920813,10920831,10920846,10925854,10925855,10920862,10620352,10620353,10620354,10620355,10620356,10620357,10620358,10620359,10620360,10620361,10620362,10620363,10620364,10620365,10620366,10620367,10620368,10620369,10920908,10920909,10920910,10920911,10920912,10620408,10620409,10620410,10926025,10926026,10926051,10921200,10921201,10930668,10921248,10926279,10965464,10965465,10965466,10965467,10921328,10921329,10930757,10930758,10921346,10930778,10921398,10965581,10965584,10965585,10965592,10921467,10921468,10921469,10921525,10921540,10621117,10952789,10621132,10952794,10952795,10952796,10952801,10621146,10621150,10621155,10952816,10952820,10952822,10621239,10616256,10621292,10621293,10621323,10621375,10621376,10621377,10621378,10621379,10621380,10966049,10966068,10966079,10922042,10621587,10922110,10927434,10562118,10611004,10611005,10611006,10614192,10565356,10565372,10565377,10565378,10565403,10565404,10565409,10565418,10565437,10565445,10565446,10565447,10565448,10565449,10565452,8864216,10614403,10565708,8864586,6666082,6666105,6666214,10611884,10611886,10611921,8864819,7057502,8861980,10612244,7057775,10557429,10557430,10557431,10557432,10557433,10557434,10557435,10557436,10557437,10557438,10557439,10557440,10557441,10557442,10557473,10560487,10557519,10563546,10563572,10557865,7058228,7058229,7058285,7058289,8862759,10609943,10613009,10613010,10610030,7058667,7058668,7058669,7058670,7058671,7058672,10610233,7058763,10610261,10610262,10613302,8863162,7058842,8863309,7058956,7058957,7058958,7058959,7058960,7058961,7058962,10558622,10558624,10558625,8863376,10558679,7059033,7059034,8863401,8863482,8863483,7059151,7059152,8863521,8863522,8863523,8863524,8863525,8863526,8863527,8863532,8863533,8863551,8863552,8863553,8863554,8863574,10613745,8863715,10515173,10515205,10555260,10515296,10515297,10515298,10515299,10515300,10515301,10515302,10515303,10515304,10555375,10555378,10513400,10513483,10513484,10513485,10513494,10555783,10555784,10555785,10555786,10555787,4974834,10517809,7056164,4974853,10513854,10513858,10513859,10513863,10513864,10555932,10555933,10555934,10555935,10555936,7056357,10516059,7056422,10514114,10556238,10556252,7057017,10556667,7057067,10518736,7057106,10518759,10518760,10518761,10518762,10518763,10518764,10518765,10518766,10518767,10518768,10518769,10518770,10514833,10512839,10512903,10556906,10556909,10516919,10516920,10516929,10516930,10556988,10556989,10557018,8918063,10416505,10416506,8918245,10416627,10418676,10418689,10419729,10419730,10419731,4973706,4973707,4973747,10419899,10419904,10419905,10419907,10418985,10420066,10420072,8864906,8864912,8864973,8865008,8865009,8865030,8865031,4971389,4971486,4971544,10471486,4971932,4971942,4971943,4971993,4972030,10465909,10465913,8917185,8917192,8917194,4972429,4972458,4972489,8917292,4972503,10470269,8563602,10466304,10470308,10470341,10468356,8917446,10462424,10470442,10470443,10462464,10462510,10470570,10470618,10462637,10628119,10628120,10628672,10629746,10629747,10629751,10629781,10629782,10629891,10629906,10632171,10627182,10627183,10627184,10627185,10627186,10627308,10627343,10153876,10153888,10153889,10153894,10627782,10627784,10627785,10627806,10627816,10627851,10627889,10627897,10627898,10627901,10627904,10627905,10627906,10627917,10627919,10630466,10630701,10630702,10630703,10630704,10630705,10630706,10630707,10630708,10630709,10630807,10630846,10630888,10626192,10626502,10568594,10571644,10571645,10571646,10571647,10571648,10571687,10568884,10568940,10568941,10568974,10568995,10569010,10569011,10569014,10569015,10569016,10569018,10569019,10569020,10569024,10569025,10569032,10569033,10569053,10569054,10569058,10569059,10569060,10569061,10569079,10569080,10569107,10569116,10569121,10569124,10566125,10569127,10569163,10569164,10569165,10569166,10569167,10569168,10569169,10569170,10520788,10520789,10520812,10520815,10520817,10520904,10520905,10420559,10421202,10421203) 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'