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(8630625,8630626,8630627,8630628,8630629,8630630,8630631,8630632,8630633,8630634,8630635,8630636,8630637,8630638,8630639,8630640,8630641,8630642,8630643,8630644,8630645,8630646,8630647,8630648,8630649,8630650,8630651,8630652,8630653,8630654,8630655,8630656,8630657,8630720,8630743,8630746,8630854,8630855,8630856,8630902,8630903,4970675,8631119,8631120,8631121,8631133,8631147,8631253,3229130,3229131,3229171,3229285,8631594,8631598,8631599,8631606,8631609,8631611,8631622,8631623,8631624,8631625,8631630,8631635,8631636,8631712,8631716,7066178,7066265,10990291,3230230,8632498,8632499,8632514,8632515,8632518,8632519,8632521,8632545,8632546,8632559,8632560,8632573,8632574,8629596,8067943,8629745,8629765,10939443,8627596,7201309,7201319,7201335,7201366,7201367,7201377,8627795,8627796,8627797,8627821,8627822,7201454,7201727,7201728,7201729,8628137,8628138,8628183,8628187,8628250,8628258,8628259,8628261,8628263,8628265,7201901,8628343,7201959,7201974,10960474,8628490,8628491,8628492,8628493,8065853,8628626,8628627,8628633,8628634,8628813,8628814,5654588,5654670,7202585,5654682,5654683,7202643,7202687,7202689,7202690,7202692,10104638,9794589,7202769,8629258,8629463,8629472,8626723,8626724,8626725,8626726,8626807,8626808,8626809,8626810,8626812,8626813,8626814,8626815,8626825,7200456,7200458,7200469,7200470,10958953,10958954,8834762,8834763,7200527,7200528,7200529,8626939,10959088,8627068,8627150,8627151,8627163,8627164,8627176,8627177,7200778,7200779,7200780,8627188,8627189,8910604,8910605,8627206,8627207,8627243,8627252,8627289,7200901,7200903,7200904,8627430,8627431,8627432,8627433,8627434,8627435,8627441,8627442,8627443,8627444,8627530,8627546,8627547,8627548,8627549,8627550,8627551,8627552,8627553,7201153,7201154,7201155,7201156,8627567,8627568,8627569,8627570,8627571,8627572,8627573,8624589,8624935,8624944,8624945,8624960,8624961,8624973,8624978,8624985,8625022,8625025,8625042,8625045,8625055,8625056,8625057,8625058,8625059,7198678,7198684,7198685,7198694,7198696,7198704,7198723,7198724,7198728,7198729,7198730,7198733,7198736,7198737,7198738,7198739,7198742,7198743,7198744,7198745,7198746,7198747,7198749,7198750,7198751,8625157,7198759,7198760,7198762,7198764,7198765,7198766,7198769,7198770,7198772,7198784,7198785,8625209,8625241,8625242,8625251,8625256,8625265,8625385,7199130,7199211,8564678,7199403,10101491,10101492,7199739,7199740,7199741,7199742,7199743,7199768,11048460,11048461,11048462,7196890,7196891,7196892,8906901,3234660,3234661,3234662,3234663,3234664,3234729,7197793,7197796,7197800,7197802,7197804,7197805,7197807,7197809,8541459,3232382,8541521,8541549,10617126,10617138,10617139,10617140,8541668,8905250,8905252,8905256,10617323,10617324,10617326,10617331,10617336,10617337,10617338,10617340,10617341,10617342,10617343,10617344,10617345,10617346,10617353,10622365,10617372,10617373,10617374,10617378,10617384,10617399,10617426,10622428,10617436,10617437,10617438,10617439,10617440,10617441,10617442,10617443,10617444,10617445,10617452,10617455,10617456,10617461,10617511,3232910,8542165,8905717,8905718,8905822,8905844,10425391,3230564,3230565,3230566,10620195,10620196,10620197,10620198,10620199,10620201,10620202,10425578,10425584,10615363,10425911,10615710,10615721,10615722,10615822,10615823,10615824,10426197,10426338,10616005,10616006,8540612,8540613,8540631,8611390,8611455,8611466,8611467,8611468,8904857,10616888,10616906,10610966,10610967,10610971,10610975,10610976,10610977,10610978,10610984,10610985,10613985,10614048,9165550,10614220,10614269,10611350,10614376,10611444,10611466,10611495,10614501,10614503,10614504,10614505,10614565,10614593,10611611,10611804,10611970,10612094,10612095,10612096,10612097,10612268,10609285,10612294,10609355,10612381,7058247,7058248,7058249,7058250,10609845,10612916,10612931,10612936,10612937,10612938,10612939,10612941,10612942,10612943,7017936,7017937,7017938,7017939,7017940,7017941,7017942,7017943,7017944,7017945,7017946,7017947,7017948,7017949,7017950,7017951,7017952,7017953,7017954,7017955,7017956,7017957,7017958,7017959,7017960,7017961,7017962,7017963,7017964,7017965,7017966,7017967,7017968,7017969,7017970,7017971,7017972,7017973,7017974,7017975,7017976,7017977,7017978,7017979,7017980,7017981,7017982,7017983,7017984,7017985,7017986,7017987,7017988,7017989,7017990,7017991,7017992,7017993,7017994,7017995,10613018,9196366,9196371,9196372,9196373,10613192,10610233,10613235,10613337,10613369,10610376,10613421,10613431,10613432,10610480,10610481,10613513,10613514,10613524,10613525,10610729,10610730,10613732,10613733,10610739,10610901,10610954,10610958,6673506,6673524,10117529,6673538,6673542,6673563,7055541,7055546,9169475,6673686,6673688,6673697,6673698,6673699,9169586,9169638,9169695,9169748,9169937,9169942,9169944,9169945,6674152,9169946,9169947,9169948,9169954,9169955,6674175,10118171,6674236,6674248,6674249,10118247,6674256,10118248,6674276,6674278,6674280,6674281,6674285,6674308,6674309,6674310,6674311,6674312,6674313,6674326,6674330,10118374,10118375,10118391,10118392,10118606,10118607,10118608,10118609,10118610,10118676,10118677,10118678,9178490,9178492,8552227,6672521,10419256,9168366,9168367,6672592,9168393,10415325,10419370,10415373,10415374,10417424,10419468,10419469,10419472,10419473,10419474,10419475,10419476,10419477,10419478,10419479,10419480,10416481,10419481,10419482,10419483,10419484,10419485,10419486,10419487,10419488,10419489,10419490,10419491,10419492,10419493,10419504,10419515,6672802,10419521,10418543,10418544,10418545,10418546,6672896,6672897,6672898,6672899,6672900,6672901,6672903,6672904,10417633,6672960,9168817,6673064,6673067,6673089,6673122,6673124,6673125,6673126,10417079,10417080,10417081,10417082,10417083,10417084,10417085,10417086,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10418109,10417109,10418110,10417110,10417111,10417112,10417113,10417114,10417115,10417116,10417117,10417118,10417119,10417120,10417121,10417122,10417123,10417124,10417125,10417126,10417127,10417128,10417129,10417130,10417131,10417132,10417133,10417134,10417135,10417136,10417137,10417138,10417139,10417140,10418141,10417141,10418142,10417142,10418143,10417143,10418144,10417144,10418145,10417145,10418146,10417146,10417147,10417148,10417149,10417150,10417151,10417152,10417153,10417154,10417155,9169233,10417156,10417157,10417158,10417159,10417160,10419169,10419172,10419173,10419174,10419175,10419176,10419177,10471173,10471174,10469245,8550018,8550097,8550155,8550247,8550263,8916794,10467821,9167324,9167779,9167792,9167937,9167988,9168101,9168102,9168103,10470721,10470722,10888524,10888552,10888553,10883625,10888637,10888638,10888639,10888640,10888641,10888642,10888655,10888656,10946563,10946564,10946565,10888839,10888840,10888841,10889052,10884075,10884081,10884082,10884084,10884086,10884088,10884089,10884094,10889231,10884324,10884698,10889756,10889757,10884764,10889776,10889777,10879926,10890105,10890106,10890107,10890108,10890109,10890110,10890111,10890112,10890113,10890114,10890115,10890116,10890117,10890118,10890119,10890120,10890121,10890122,10890123,10890124,10890125,10890127,10890128,10890129,10890130,10890133,10890135,10890136,10890137,10890138,10890148,10890157,10890158,10890159,10890160,10890161,10890162,10890173,10890174,10890175,10885313,10885347,10885348,10885349,10885350,10631994,10632010,10632011,10632012,10632013,10632014,10632018,10887546,10887557,10887724,10627319,10627321,10882916,10883067,10883137,10883143,10627775,10627793,10883358,10883359,10883378,10883392,10883396,10883397,10883398,10883407,10883414,10883457,10883458,10883459,10883460,10630026,10630029,10630030,10630033,10630034,10630040,10630043,10630044,10630045,10630047,10630048,10630049,10630050,10630051,10630052,10630053,10630054,10630055,10630056,10630057,10630058,10630059,10630060,10630061,10630062,10630063,10630064,10630065,10630066,10630067,10630069,10630071,10630072,10630073,10630074,10630075,10630076,10630077,10630079,10630080,10630081,10630082,10630083,10630084,10630085,10630086,10630087,10630088,10630090,10630091,10630092,10630093,10630094,10630095,10630096,10630097,10630098,10161705,10885763,10885867,10886057,10886058,10886059,10886060,10886062,10886063,10162081,10162177,10881538,10886589,10886850,10886918,10167934,10168012,10882061,10887072,10882284,10882353,10647649,10647650,10647703,10582561,10545356,10545357,10545358,10545371,10545372,10545373,10498867,10425097,10407925,10487111) 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'