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(7201605,7201607,7201683,7201728,7201729,7201898,7076128,8628341,8628383,8628384,8628385,8628386,8628387,8628388,8628391,8628392,8628393,8628394,8628399,10198542,10103965,8628493,10104022,3899414,7202165,7202168,7202171,3899586,8836618,10250930,7202767,8629174,10104659,8629224,8629232,8629271,8629319,8629320,8629322,8629324,3227184,3227186,3227207,3227262,3227263,7074350,7074351,10225630,8837489,10238728,8629680,8629821,8629822,8629823,8629824,10199968,10199974,10199979,10199982,7066784,7066822,10437774,8067943,7200786,7200817,8627355,8627376,8627389,7067236,7201041,10236676,10236677,7201214,7201215,8627617,8627618,8627619,8627620,8627621,8627622,8627623,8627624,8627629,8627634,10275735,7075498,10842809,8627714,8627721,8627722,8627723,8627724,8627726,7201330,7201374,8627820,8627834,10249990,10249991,10249997,8627972,8624998,8625002,8625006,8625010,8625014,8625052,8625053,10195120,7198679,7198702,7198703,7198704,7198713,8625120,8625121,7198721,7198723,7198725,7198728,7198729,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198759,7198762,7198764,7198769,7198770,7198772,10247425,8625457,8625483,8625567,8625568,10273840,10273841,10273842,10273843,10273844,10273845,10273846,10273847,10273848,10273849,10273850,10273851,10273852,10195962,10195963,8616099,8626006,8626007,8626008,8626009,8626010,8626011,8626012,8626033,8626052,8626209,4967460,8626328,8626338,8626420,8626426,8626430,8626437,8626440,7073283,8616854,8626714,10248806,10248807,10248808,10248809,7200506,7200507,7200508,7200529,7200547,7197609,7197611,7197613,8907434,7197643,7197646,7197649,7197650,7197651,7197652,7197655,7197687,7197689,7197690,7197691,7197725,7197726,7197727,7197728,7197729,7197745,7197770,3234959,3234960,3234961,3234962,3234963,3234964,3234965,3234979,3234980,3234981,7197846,7197849,7197850,10285534,10285535,10285537,10285538,10285541,10246585,10839683,7198366,7198374,7198395,10194863,10194864,10839909,10194888,10194889,7198459,7198460,7198461,7198462,10205078,10231139,10231140,10231155,8612449,8542204,10231418,8542252,8542253,8905934,10283604,7196189,7196192,7196198,7196220,8612822,3233407,3233418,7196380,7196381,7196382,7196404,10283945,8613074,7196554,10284077,10941692,3233953,3233954,3233956,10941757,10941763,10941773,10941782,7196890,7196906,7196955,7196956,7196963,10838527,10838529,10838543,10838552,8907037,8907067,8860405,8860499,8860500,10942410,10838980,10838981,10838982,10838983,3234705,3234706,10229132,10229138,10229139,10229231,10425933,10425937,10425938,10425941,10229299,10426014,10229372,10229373,10618282,10618283,10618284,10618285,10618360,10618361,10618362,10618363,10426151,10426194,8540359,8540360,8540362,8540364,8540365,8540370,10229580,8540401,10426253,8540402,10426254,10229602,10229603,10229604,8540408,8540409,8540411,8540412,8540413,8540414,10433521,10426339,10623723,8611003,8904234,10229913,8904290,3231700,3231702,3231704,3231760,10230099,10230307,8611462,8611464,3232165,3232166,3232240,3232243,3232246,3232247,3232292,3232297,10282591,10282592,10282593,10282597,10282598,10282603,10282604,3232313,10282605,10282606,10282607,10282608,3232318,10282609,3232319,10230618,10230619,10230620,10230621,10230622,10230623,10230624,3232333,10230625,10230626,10230627,3232382,8541571,8541572,8541573,8541581,8541592,10204810,8905209,8612004,8612005,8612107,10619885,10619886,10619887,10619895,10619906,8622408,8622468,8622469,8622470,10617338,10617372,10617375,10617376,10617377,10617426,10617444,10617445,10617446,10617447,10622447,10425486,10425487,3230662,3230663,3230664,10848001,10848002,10848003,10848007,10614984,10614986,10614987,10614991,10614993,10615167,10845543,10447715,10447778,10447794,10447801,10447803,10615819,10239985,10615896,8574513,10615956,3228951,3228952,3228957,8621516,10431259,3229203,8583440,10431549,10922135,10922136,10922137,10922138,10431587,10431607,10922205,10922206,10922207,10922208,10922209,10922304,10922305,10616905,7059524,7059757,9173739,9173901,9214000,10122201,9166217,9206288,10612107,9211554,9211555,9211567,8542801,10612320,10612321,9211916,9211936,9211937,9172146,10612939,8862829,8862830,10612972,9212321,9196360,10613104,9172464,9172465,9172466,6676843,10613350,10613369,7018646,7018647,7018648,7018649,7018650,7018651,7018652,7018653,7018654,7018655,7018656,7018657,7018658,7018659,7018660,7018661,7018662,6677269,6677364,10515134,10515135,10515136,10117529,9209501,6673789,9185606,9185607,9185609,9185630,9185737,9185738,9185744,7055922,10118016,9185856,9185857,9185866,9185879,9185896,9185897,9169903,9185944,9185945,9185946,9169946,9169947,9169948,10118247,10118248,10118294,10118295,10118298,6674331,6674332,10516136,10118606,10118607,10118676,10118677,9186755,9170757,9186804,10518668,8552226,10512782,9171102,10119336,10515061,7057449,10416255,10416256,4973195,10416260,10416261,10416264,10416265,10416266,10416272,10416298,10419307,9192413,10416358,6672657,6672670,10417385,9192475,6672698,10416411,10116700,10116701,10116702,10116703,10116704,10116705,10116706,10116707,10116708,10116709,10419469,9192597,9192612,9192613,9168733,7054903,9168765,9168775,10419705,10419713,10419729,10419740,10418799,10418800,10418801,10418802,10418803,10418826,10418847,10418848,9168939,10419995,10420009,9193121,10420094,10420098,10417118,10417125,7020058,7020059,7020060,7020061,7020062,7020063,7020064,7020065,7020066,7020067,7020068,7020069,7020070,7020071,10122662,10467118,10467120,10467130,10471172,10471173,10471174,10467224,9166826,9166828,10467432,9166869,7020586,7020587,7020588,7020589,7020590,7020591,7020592,7020593,7020594,7020595,7020596,7020597,9183002,8550263,8550264,8550265,10465763,10465770,10465795,10465804,9175234,10465813,10465819,10465835,10465840,10465910,9167472,8550648,9175497,9175498,9175561,9175564,9175565,9207637,9207713,9207732,10466311,9207749,10466332,10466334,10466341,9207772,10466353,10466364,10466366,10466382,10466384,10466443,9183876,9183877,9183878,9167896,10466856,10466858,10888487,10884086,10884088,10889997,10885074,10890130,10890133,10890135,10890136,10890139,10890140,10890141,10890142,10890143,10890144,10890145,10890146,10890147,10890149,10890168,10880207,10880208,10880209,10885347,10885349,10632051,10632312,10888013,10888018,10888019,10627710,10630023,10630024,10630025,10630027,10630028,10630031,10630032,10630035,10630179,10172076,10891115,10162243,10886250,10891354,10891355,10886377,10886378,10886379,10886380,10886381,10886382,10886383,10886384,10886385,10886386,10886387,10886388,10886389,10886390,10881537,10626235,10631237,10631279,10631280,10631281,10631282,10631283,10631284,10631285,10631286,10631287,10631288,10631443,10882010,10168058,10887096,10887097,10892200,10892201,10892202,10892203,10892204,10892205,10892206,10892207,10892357,10892358,10631896,10631909,10631910,10887464,10580181,10580182,10580183,10580184,10580185,10580186,10580187,10568313,10568314,10568315,10601359,10601360,10601400,10598680,10598681,10598682,10598683,10598684,10598685,10598686,10598687,10598688,10598689,10598690,10598691,10598692,10598693,10598694,10598695,10598696,10598697,10598698,10598699,10598700,10598701,10598702,10598703,10598704,10598705,10598706,10598707,10598708,10598709,10598710,10598711,10598712,10598713,10598714,10598715,10598716,10598717,10598718,10598719,10598720,10598721,10598722,10598723,10598724,10598725,10598726,10598727,10598728,10598729,10598730,10598731,10598732,10598733,10598734,10598735,10598736,10598737,10598738,10598739,10598740,10598741,10598742,10598743,10598744,10598745,10598746,10598747,10598748,10598749,10598750,10598751,10598818,10598819,10598820,10598843,10598844,10598845,10598857,10598865,10598866,10590274,10590277,10590279,10590280,10590299,10590300,10590301,10590302,10590303,10590304,10590305,10590306,10590310,10590311,10590484,10590485,10590486,10590487,10590488,10590489,10590490,10590491,10591929,10591930,10591931,10591932,10591933,10591934,10591935,10591936,10545367,10545392,10529409,10529412,10529413,10541443,10541447,10541448,10525564,10527840,10527841,10528108,10528115,10528116,10528117,10528142,10528146,10528162,10528176,10528177,10522283,10522284,10520781,10520782,10520783,10520784,10520785,10526866,10543042,10539077,10422222,10420314,10420315,10420317,10420323,10421426,10421427,10420438,10422520,10420573,10423626,10423923,10506819,10506824,10506825,10425043,10425044,10425052,10425057,10423157,10407345,10407353,10407459,10407526,10490316,10483438,10486570,10407956,10473691,10495008,10495010,10495014,10478015,10495016,10487109,10487112,10493297,10493298,10497400,10406888,10406889,10406890,10406891,10406892,10476553,10408980,10408985,10408986,10408987,10408988,10476652,10409049) 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'