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(8068815,8068817,8068818,8068819,8068821,8068822,7075905,7076318,7076345,7073925,7073926,10963678,8067408,11011552,11011553,6000252,7072450,7072451,7072452,7072453,7070820,7070850,8860897,8860904,10943320,10943377,10943387,10943392,10943393,10943394,10943396,10943412,3655525,3655526,7069360,3656145,3656146,3656147,3656148,10996569,10941793,10941794,10941803,10941805,10941812,10941831,10941835,10941836,10941837,10941865,10941866,10941892,10941900,10941925,10941926,10941927,10941936,10941937,10941953,10941964,10941965,10941966,10941974,10941981,10941998,10942002,10942008,10942011,10942020,10942034,10942403,10942404,7070770,10993500,10993501,10993502,10993504,10993531,10993532,10993533,10993579,10993580,10993581,10993582,10993583,10993584,10993585,10993586,10993587,10993588,10993589,10993594,10993595,10993596,10993597,10993598,10993604,10993605,10993606,10993607,10993608,10993609,10993610,10993611,10993612,10993613,10993614,10993615,10993616,10993617,10993618,10993619,10993620,10993621,10993622,10993623,10993624,10993625,10993626,10993627,10993628,10993629,10993630,10993631,10993632,10993633,10993634,10993635,10993636,10993637,10993638,10993639,10993640,10928613,10993641,10928614,10993642,10993643,10993644,10993645,10993646,10993647,10928619,10993648,10993649,10993650,10993651,10993652,10928628,10928629,10928630,10928647,10928648,10928651,10928662,10928663,10928664,10928665,10928666,10618177,10967807,10968057,10919484,10992564,10992641,10992642,10992656,10992657,10992658,10992659,10992660,10992661,10992662,10992663,10992664,10992669,10992684,10992685,10992686,10992687,10992688,10992699,10992700,10992701,10992702,10992704,10992723,10992724,10992767,10992768,10992795,10992818,10992819,10992820,10992821,10992837,10992925,10992926,10993011,10993012,10993013,10993014,10993015,10993016,10993017,10993018,10993019,10993020,10993021,10993022,10993023,10993024,10993050,10993051,10993052,10993053,10993056,10993089,10993090,10993091,10993152,10993153,10993154,10993165,10993166,10993167,10993168,10993169,10993204,10993206,10993207,10993212,10993226,10993234,10993235,10993236,10993237,10993238,10993239,10993242,10993243,10993244,10993245,10993246,10993258,10993261,10993264,10993265,10993266,10993267,10993283,10993284,10993285,10993286,10993287,10993288,10993289,10993290,10993298,10993299,10993300,10993301,10993302,10993305,10993309,10928305,10928317,10928318,10928319,10928320,10993442,10993443,10993452,10993453,10993454,10993455,10993456,10993482,10993483,10993484,10993485,10993486,10993487,10993488,10993489,10993490,10993491,10993492,10993493,10993494,10993495,10993496,10993497,10993498,10993499,10920530,10920560,8570015,8570214,8570523,10991531,10991563,10991569,10991651,10991652,10991653,10991654,10991655,10991656,10991663,10991682,10991686,10991750,10991751,10991752,10991756,10991779,10991780,10991781,10991791,10991792,10991793,10991794,10991795,10991796,10991797,10991852,10991853,10992008,10992009,10992036,10992037,10992038,10992039,10992040,10992093,10992094,10992140,10992141,10992142,10992143,10992144,10992145,10992177,10992184,10992185,10992186,10992187,10992190,10992191,10992193,10992194,10992195,10992196,10992197,10992204,10992205,10992206,10992221,10992222,10992333,10992337,10992357,10992358,10992359,10992360,10992361,10992362,10992363,10992364,10992474,10992475,10992476,10992477,10992478,10992486,10992487,10565172,10565173,9189500,7059854,7059859,9197812,8864531,9174040,8864577,7057484,7057518,7057526,7057529,7057532,7057654,10563480,10563481,10563482,10563483,10609399,7058239,9172460,10558615,10610723,10610911,9173265,10513401,9185641,9185642,9185684,9185685,9185709,9185710,9185714,9185753,9169757,9185763,9185952,9185953,9185965,9185966,9185971,9185975,9185982,9185983,9185987,9185991,9185999,9186008,9186045,9186071,9186074,9186075,9186087,9186088,9186089,9186093,9186109,9186144,9186153,9186168,9186189,9186231,9186237,9186308,9186309,9186310,9186311,9186312,9186313,9186342,9186396,9186397,9186424,9186425,9186439,9186440,9186441,9186447,9186448,9186485,9186486,9186504,9186505,9186515,9186521,9186527,9186528,9186530,9186531,9186593,9186594,9186595,9186596,9186597,9186616,9186644,9186645,9186646,9186662,9186663,9186668,9186669,9186670,9186673,9186674,9186678,9186683,9186696,9186697,9186701,9186707,9186708,9186709,9186712,9186717,9186718,9186719,9186720,9186727,9186749,9186766,9186844,9186850,9186864,9186865,9186867,10512735,7057464,8918053,8918316,8918317,8918319,8918322,8918324,8918325,10417732,10417733,10417734,9193105,9193106,6667152,6667154,6667163,6667164,9175511,8917775,10628311,10629413,10629418,10174074,10174077,10174078,10174079,10174080,10174081,10174082,10174083,10174084,10174085,10174086,10630100,10172103,10172106,10177126,10177127,10177128,10177129,10177130,10177131,10177132,10626180,10626275,10568494,10568556,10568557,10584189,10575981,10567821,10567822,10567823,10567824,10567825,10586092,10586093,10531174,10531175,10531176,10531177,10531178,10531179,10531180,10531181,10531182,10531183,10531184,10531185,10531186,10531187,10531188,10531189,10531190,10531191,10531192,10531193,10531194,10531195,10531196,10531197,10531198,10531199,10531200,10531201,10531202,10531203,10521250,10521251,10521252,10521291,10521292,10531444,10531445,10531446,10531447,10531646,10531662,10531663,10531726,10531727,10531728,10531729,10531730,10531731,10531783,10531784,10531785,10531786,10531787,10531788,10531789,10531790,10531791,10531818,10531819,10531820,10531821,10531822,10531841,10531842,10531846,10531847,10531887,10531888,10531889,10529892,10529893,10529894,10529895,10529896,10529897,10521899,10521900,10529936,10529937,10529938,10529939,10529940,10529956,10529957,10529964,10529965,10529967,10531977,10531978,10531979,10531980,10531981,10531982,10531983,10531984,10531985,10529985,10531986,10531987,10531988,10531989,10531990,10529990,10531991,10531992,10531993,10531994,10531995,10531996,10531997,10531998,10531999,10532000,10532001,10530009,10530010,10530011,10530012,10530013,10530014,10530015,10530016,10530017,10530018,10530019,10530020,10530021,10530022,10532042,10532043,10532044,10530048,10530049,10530050,10530051,10530052,10530053,10530054,10530057,10530058,10530059,10530063,10530064,10530079,10530080,10532094,10532095,10532096,10530096,10530097,10530119,10530132,10530160,10530161,10530162,10530175,10530194,10530203,10530204,10530205,10530206,10530207,10530208,10530209,10532210,10530210,10530211,10530212,10530213,10530214,10530215,10530216,10530217,10530218,10530219,10530220,10530221,10530222,10530223,10530224,10530225,10530226,10530227,10530228,10530229,10530230,10530231,10530232,10530233,10530234,10530235,10530236,10530237,10530238,10530239,10530240,10530241,10530242,10530244,10530253,10530254,10530255,10530256,10530257,10530258,10530259,10530260,10530261,10530262,10532263,10530263,10532264,10532265,10530265,10530266,10532266,10532267,10530267,10532268,10530268,10532269,10532270,10532271,10530271,10532272,10530272,10532273,10530273,10532274,10532275,10530278,10530279,10530298,10530337,10530338,10530339,10530340,10530341,10530342,10530343,10530344,10530345,10530346,10530347,10530348,10530349,10530350,10530351,10530352,10532353,10530353,10532354,10532355,10532356,10530382,10530383,10530384,10530385,10530386,10530387,10530388,10530389,10530390,10530391,10532402,10532403,10532421,10532422,10532423,10532424,10532425,10532426,10532427,10532471,10532472,10532473,10530487,10522532,10530533,10530534,10530537,10530538,10530539,10530540,10530541,10530542,10530543,10530544,10530545,10530546,10530547,10532553,10532554,10532555,10532556,10532557,10532558,10530565,10530566,10530567,10530568,10530569,10530570,10530571,10530576,10530577,10530578,10530579,10532580,10532581,10532582,10532583,10532584,10532585,10532586,10532587,10530587,10532588,10530588,10532589,10532590,10532591,10532592,10532593,10532594,10532595,10532596,10532597,10532598,10532599,10532600,10532601,10530606,10530621,10530622,10530623,10530624,10530625,10530626,10530627,10530628,10530629,10530630,10530631,10530632,10530645,10532652,10530656,10532664,10532665,10522674,10522675,10522676,10522677,10522678,10522679,10532682,10532683,10532684,10532685,10532686,10532687,10532695,10532696,10532697,10530697,10532698,10530698,10532699,10532700,10532701,10532702,10532703,10530703,10532704,10532705,10532706,10530706,10532707,10532708,10532709,10530714,10530715,10530716,10532717,10530717,10532718,10532720,10532721,10532723,10532724,10532725,10532726,10532727,10532728,10530746,10530747,10530748,10530761,10530785,10530786,10530787,10530788,10530789,10530794,10530803,10530804,10530805,10520823,10520824,10520826,10520851,10530883,10530884,10530885,10530886,10530902,10530903,10530904,10530970,10530982,10530997,10530998,10531018,10423409,10423563,10422014,10422044,10422056,10422057,10422080,10422132,10422143,10422150,10422152,10422155,10422157,10422197) 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'