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(7076081,7076083,7076319,11041519,7065938,10950683,7074096,10976792,8067150,8067151,8067152,8067157,8067158,7066470,7066585,7066590,7066668,7066669,11001236,8068481,8068490,7067661,7067758,10939388,10939389,10939410,7072176,7072178,7072180,7072273,7072274,7072275,10999277,10999278,10999291,10999292,10999293,10999294,10999295,10999296,10999297,10999298,10999299,10999300,10999310,8836208,8836250,8836251,10960685,10960770,7073169,11000115,11000116,11000117,11000118,11000129,11000130,8066485,8066486,4967996,7070944,11010628,11010641,11048927,7071069,10985211,7071594,7071596,7071597,7071603,7071604,7071610,7071611,7071612,7071613,7071615,10943302,10943304,10943306,10943308,10943309,10943324,10972396,10943378,10943388,10943395,8835261,10943397,10943406,10943407,10943413,6000200,6000201,6000202,6000203,6000204,6000205,6000206,6000207,6000208,6000209,6000210,6000211,6000212,6000213,7069369,7069370,7069372,7069389,10996731,10941708,10941869,10941870,10941889,10941930,10941942,10941983,10942027,10942028,7070650,7070655,7070657,7070658,7070659,7070661,7070663,7070664,7070667,3657271,7070717,7070719,7070721,7070722,7070723,7070726,10618034,10928585,10928592,10928596,11045779,11045780,11045781,11045784,10928640,11045812,11045813,11045814,10928685,10928686,10928687,10928688,10928689,10928690,10928691,10928692,10928693,10928694,10928695,11045981,11045982,11045983,11045990,11045998,11045999,11046000,11046001,11046002,11046003,11046004,11046005,11046006,11046007,11046008,11046009,11046010,11046011,11046012,11046013,11046014,11046015,11046016,11046017,11046018,11046019,11046020,11046021,11046022,11046023,11046024,11046025,11046026,11046027,11046028,11046029,11046030,11046031,11046032,11046033,11046034,11046035,11046036,11046037,11046038,11046039,11046040,11046041,11046042,11046043,11046044,10994511,10994512,10994513,10994514,10994515,10994516,10994517,10994524,10994525,10994526,10994527,10994528,10994529,10994530,10618941,10618942,10618943,11046637,11046660,11046661,11046689,11046690,11046691,11046794,11046807,11046812,11046828,11046833,11046843,11046866,11047049,11047356,11047357,11047358,11047359,10616970,10616996,10966673,10617016,10953676,10953677,10953678,10953679,10953680,10617108,10992770,10992771,10992772,10992773,10992774,10617124,10617134,10992822,10617169,10617170,10617171,11044858,11044859,11044860,11044861,11044862,11044874,11044875,11044876,11044878,11044879,11044880,11044881,11044882,11044883,10993055,10617472,10622515,10928030,10622527,10993314,10622661,10622667,10622668,10622669,10993382,10993383,10993384,10928237,10993385,10993386,10993387,10993388,10993389,10993390,10993391,10993392,10993393,10993394,10993395,10993396,10993397,10993398,10993399,10993400,10622829,10993518,11045608,11045609,11045610,10615063,10620083,10615317,10615373,10615393,10615444,8570524,10615597,10615598,10615647,10991337,10991338,10615681,10991339,10991340,10991343,10991344,10991345,10991346,10991347,10991354,10991527,10615923,10615931,10615944,10615945,10991613,10991614,10991615,10991616,10991617,10991618,10991619,10991620,10615979,10615980,10992566,10616958,10614071,10611141,7059738,8864199,10611342,10614476,10614479,10614480,10614481,9189820,10614483,10614485,10559636,9189823,10559637,9189824,10614488,10559638,10559639,10559640,10559641,10614492,10559642,10559643,10559644,10559645,10559646,10559647,10559648,10559649,10559650,10559651,10559652,10614537,9189983,10614662,10614710,10614713,10614735,10614736,10614849,10611863,10611879,10611900,9182288,9182289,10611988,7057516,7057622,10612181,10612187,10612193,10612194,9171531,10612195,9171532,10612196,9171533,10612197,9171534,10612198,9171535,7057717,9187561,9187562,9187563,9187564,9187565,9187566,9187567,9187568,9187569,9187570,9187571,9187572,9187573,9187574,9187578,9187579,9187580,9187581,9187582,9187583,7057751,10609269,10612328,10612342,10557529,10557530,10557641,10612624,10557805,10557806,10557807,10557808,10557809,10557810,10557811,10557812,10557813,10612723,10612724,10612725,10612730,10612731,10612732,10612733,10612734,10612735,10612736,10612738,10612740,10612756,10612757,10612761,10612762,10612763,10612764,10612765,10612766,10612769,10612771,10612781,10612782,10612783,10612784,10612785,10612786,10612787,10612797,10612800,10612803,10612805,10612806,10557977,10609829,8862716,9196196,9196197,9196198,9188211,10612889,10612897,10612898,9188251,10612936,10612940,10609980,10612998,8862895,9188508,9188526,10610378,10610379,10610380,10610383,10610384,10610385,10610386,10610387,10610403,10610406,10610407,10610409,10610410,10610412,10610413,10610414,9172787,10610486,10610490,10610495,10610496,10610498,10610499,10610671,9189234,10610909,10515169,9161374,9161376,9185376,9185377,9161378,9161379,9185379,9185380,9185381,9185382,9185383,9185386,9185390,9185391,9185392,9185393,9185398,9185399,9185400,9185401,9185402,9185406,9185407,9185408,9185409,9185410,9185413,9185415,9185416,9185417,9185418,9185421,9185422,9185423,9185424,9185425,9185426,10515239,9185429,9185430,9185431,9185435,9185436,9185437,9185438,9185439,9185440,9185441,9185442,9185443,9185455,9185456,9185457,9185458,9185459,9185460,9185461,9185462,9185463,9185464,9185465,9169465,10517284,10517285,9185473,9185474,9185475,9185585,9185639,9185653,7055871,9169709,9169753,9169754,9169755,9177805,9169822,9169867,9185954,7056160,7056168,9170047,10555909,10555910,9186169,9186177,9186217,10512115,10512116,10512117,9186315,9186316,7056497,7056498,7056499,7056500,9170427,9186435,9186489,9186490,9186506,9186517,9186544,9186545,9186600,9186601,9186772,9186773,9186774,9186775,9186781,9186782,9186783,9186784,9186785,9186786,9186787,9186788,9186789,9186790,9186791,9186792,9186793,9186794,10516646,10516647,10516648,10516649,10516650,10516651,10516652,10516653,10516663,7057147,9186982,9187013,9187048,9187049,9187065,10512969,4973179,4973180,4973181,4973182,4973183,4973184,4973185,4973186,4973187,4973188,4973189,4973253,4973254,4973255,4973283,4973284,4973285,4973286,4973287,4973288,4973289,4973290,4973291,4973292,8918100,10415468,10418685,10418686,10418687,10418700,10416758,9169033,10418996,10420011,7055363,10419156,9161281,9182323,9182324,9182325,9182326,9182330,9182331,9182332,6666568,9182586,9174752,9174893,10469661,10467822,10467823,10467824,10467825,10467826,10467829,10467830,10467831,10467832,10467835,10467838,10467842,10467843,10467844,10467845,10467847,10467848,10467849,10467850,10467852,10467853,10467854,10467855,10467856,10467858,10467860,8917006,9175429,8917091,9175462,9191500,9175501,9175502,9191529,9191575,10468154,10468155,8563597,9175801,9175802,9175804,10468391,10468482,10468483,10468495,9167979,9167980,9167981,9167986,8917685,9168072,9168075,6668154,9168184,10466850,10466851,10466852,10466853,10466854,10466855,10628549,10627012,10627013,10627014,10632056,10632170,10172068,10172069,10172070,10172107,10625807,10625920,10625921,10626292,10626293,10626503,10626504,10626505,10626506,10163279,10580151,10580158,10586207,10586208,10586209,10586210,10586211,10586212,10586224,10583607,10583608,10583609,10583610,10583611,10583612,10583613,10583614,10583615,10583616,10583617,10583618,10583619,10583620,10583621,10583622,10583623,10583624,10579443,10579444,10579445,10579446,10579447,10579448,10579761,10579762,10579763,10579764,10579765,10579766,10585898,10525121,10525122,10525124,10521258,10521260,10521261,10521263,10521264,10521269,10521270,10521271,10531344,10531527,10531528,10531529,10531530,10531531,10521681,10521682,10529735,10529736,10529737,10529738,10529739,10529740,10529741,10529742,10529743,10529744,10529745,10529746,10529747,10529748,10529755,10529756,10529757,10529759,10529760,10529761,10529762,10529763,10529765,10529766,10529767,10529768,10529769,10529770,10531773,10531774,10529780,10529781,10529782,10529783,10529784,10529785,10529786,10529787,10529788,10529789,10529793,10529794,10529824,10529825,10529826,10529827,10529828,10529829,10529830,10529831,10529832,10521835,10521844,10523848,10523849,10523850,10523851,10523852,10523853,10523854,10523855,10523856,10529976,10529977,10532004,10530125,10532151,10532152,10532153,10532154,10532155,10532156,10532157,10532158,10532159,10532160,10532161,10532162,10532163,10522208,10532315,10532316,10532317,10520331,10520332,10520333,10520334,10520335,10520336,10520337,10532410,10530478,10530479,10530480,10522515,10522516,10532519,10532520,10532521,10532522,10532523,10532524,10532525,10532526,10530655,10522727,10530782,10520855,10530986,10530987,10531020,10525083,10525084,10525085,10525086,10525087,10525088,10525089,10525090,10525091,10525092,10525093,10525094,10525095,10525096,10525097,10525098,10525099,10525105,10425250,10425253,10420324,10498366,10424741,10422024,10422046,10422054,10422055,10425066,10422089,10422139) 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'