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(7067854,10939623,10939624,10939625,10939727,10939743,7076067,7076101,4970450,7068138,7068139,7068140,7068141,7068142,7068143,7068144,7068145,7068146,7076147,7068147,7068148,7068149,7068150,7068151,7068152,7068153,7068154,7068155,7068156,7068157,7068158,10939876,10939884,10943723,7068261,7068262,7068263,7068264,7068265,7068266,7068267,7068268,7068269,7068270,7068271,7068272,7068273,7068274,7068275,7068276,7068277,7068278,7068279,7068280,7068281,4970738,10940173,10940174,10940175,10940176,10940177,10940178,4970858,4970873,4970874,4970893,4970894,4970895,4970896,4970897,4970898,4970899,4970900,4970901,4970902,4970903,4970904,4970905,4970906,4970907,4970908,4970909,4970910,4970911,4970912,4970913,4970914,4970915,8569654,10944271,10944281,10944285,8569752,8569753,4971144,4971145,4971146,4971147,4971148,4971149,4971150,4971151,7073980,7074047,7074151,8067240,8067241,8067243,8067270,8067275,8067276,8067277,8067278,10437205,7066389,10437351,10437398,7074493,7074511,7074613,7074623,7074633,10437584,7074784,10437746,7074831,7066853,7066854,7066885,7066896,4969282,4969283,4969284,7074961,7074962,7066988,8067978,8067979,8067980,8067981,8067982,7067238,7067239,7067246,7075258,7067264,7067271,7067299,7075622,10939425,7067740,8064885,8064887,7071967,7071968,8065078,7064076,7072089,7072090,7072091,7072149,10931634,7064200,7064201,7064202,7064203,7064204,7064205,7064206,7064207,7064208,7064209,7064210,7064211,7072212,7072213,10931851,7072481,7072488,7072557,7072589,10932047,10932097,7072661,10932102,10932103,7072664,7072696,7072697,10932139,10932167,7072747,7072751,7072756,7072791,8065968,8065985,8065986,8065987,8065989,8065990,8066092,8066105,8066106,8066118,10932599,10932644,10932645,10932646,10932649,10932686,10932693,10932694,10932737,10932846,10932944,7073585,7073588,10933042,7073669,10942561,8861035,8861036,8861037,7071155,7071204,7071205,7071206,7071207,7071208,7071209,7071210,7071211,10942970,10942971,8064488,10943140,10943147,10943152,10943180,7071529,8861481,7071692,7071699,7071760,7071761,10931202,8071710,8071775,8071840,8071905,8071970,8072035,10944706,8072100,8072165,10944841,7069363,8072230,10944923,8072306,10944985,10945023,10941327,8072592,8072602,8072612,8072618,8072625,8072635,8072658,8072659,8072660,8072661,8072662,3656630,3656631,3656648,8072833,8072834,8072835,8072836,8072837,3656674,8072838,8072839,8072840,3656677,3656708,7070092,3656910,8073097,10942066,10942067,10942068,10942069,10942070,10942071,10942072,8860343,8860390,10942256,10942257,8860483,10942309,8860503,8860504,8860505,8860558,8860561,8860563,8860565,10918483,10918484,10918500,10918501,10918502,10617999,10618000,10618001,10618019,10918538,10918539,10918540,10918541,10918542,10918543,10918544,10918545,10918546,10918547,10918548,10923581,10923630,10918734,10918757,10918758,10618248,10618249,10918759,10918760,10918761,10918762,10918820,10918821,10918822,10918823,10918824,10623315,10918826,10918827,10923843,10923844,10923845,10623409,10618453,10618454,10618455,10618456,10618457,10618458,10618459,10618460,10618461,10618462,10618463,10618464,10618465,10618466,10618467,10618468,10618469,10618470,10618471,10618472,10618473,10618474,10618475,10618476,10623507,10924071,10924072,10924073,10924074,10924075,10924076,10919197,10919198,10919199,10919200,10919226,10919227,10618828,10618829,10618884,10618885,10618886,10618887,10618888,10924448,10924449,10924450,10924451,10924452,10924453,10924454,10924455,10924456,10924457,10924458,10924459,10924460,10924461,10924462,10924463,10924464,10924465,10924466,10924467,10919499,10919500,10919501,10919502,10919503,10919504,10919505,10919548,10919549,10919550,10924771,10919838,10919839,10619337,10619338,10619339,10619340,10619341,10619342,10619343,10619344,10619347,10919858,10919859,10919860,10919861,10919862,10919863,10919864,10919865,10919866,10919867,10919868,10919869,8071077,8071108,8071109,8071110,8071111,10919965,10919966,10919967,10920035,10920036,10920037,10920038,10920039,10920040,10920041,10920042,10920043,10920044,10920045,8071285,10624583,8071297,8071371,8071376,8071377,8071405,8071434,8071455,8071497,8071502,8071509,8071580,8071645,10617035,10922615,10922686,10917699,10917700,10917767,10917768,10917769,10917770,10917771,10917772,10917773,10917774,10917775,10917776,10917777,10917778,10622283,10622284,10622285,10622286,10622287,10622288,10622289,10622290,10622291,10622292,10622293,10622294,10622295,10622296,10622297,10622298,10622299,10622300,10622301,10622302,10622303,10622304,10927926,10927927,10927928,10617486,10617488,10917998,10617497,10617498,10617499,10617500,10617502,10617503,10617504,10617505,10918138,10918139,10928208,10918279,10918280,10918281,10918309,10918310,10918311,10915477,10915478,10915479,10915480,10915481,10915482,10915483,10915484,10915485,10915486,10915487,10915488,10915489,10915490,10915491,10915492,10915493,10915494,10915495,10915496,10915497,10915498,10915499,10915500,10915501,10915502,10915503,10915504,10915505,10915506,10915507,10915508,10915509,10915510,10915511,10915512,10915513,10915514,10915515,10620108,10615178,10615222,10920742,10920743,10920744,10620338,10920852,10920853,10920854,10615393,10920913,10920958,10920959,10920960,10921039,10921040,10921041,10926096,10615599,10615625,10926160,10926173,10615668,10926185,10926200,10926201,10921235,10921236,10921237,10921238,10926243,10921254,10921255,10926280,10921336,10615827,10921337,10921338,10921649,10921650,10921651,10921725,10921726,10921727,10921728,10921780,10921781,10921782,10921783,10921784,10921785,10921786,10921787,10921788,10921789,10921790,10921791,10921792,10921793,10921794,10921795,10921878,10921879,10921880,10921881,10921882,10917013,10917014,10917045,10922091,10922093,10616859,10616860,10917415,10917416,10917417,10917418,10616955,10611166,10565349,10614247,10611358,10611479,10614575,10614710,10611764,10611854,10566067,10566068,10566069,10566070,10612059,10612082,10612083,10557310,10557311,10557312,10557313,10557314,10563384,10609265,10612277,10557475,10612344,10609348,10609350,10609351,10609352,10557503,10609357,10609358,10609359,10609362,10609363,10609376,10609385,10563540,10612520,10612524,10612525,10612551,10612659,10612675,10609724,10609816,10612841,10612907,10609978,10610007,10613060,10558459,10558460,10558461,10558462,10558463,10558464,10558465,10558480,10558481,10558482,10558483,10558484,10558485,10558486,10613336,10558487,10558488,10558489,10558490,10558491,10558492,10558493,10558494,10558495,10558496,10561525,10561526,10561553,10564618,10564619,10564620,10564621,10564650,10564651,10564652,10564703,10564704,10564705,10564706,10564707,10564708,10564709,10564710,10564711,10610567,10564758,10564759,10564760,10564761,10564762,10564763,10564764,10564765,10610656,10610657,10513149,10513203,10513204,10511214,10511215,10511216,10513217,10511217,10513218,10511218,10511234,10511236,10513248,10511252,10511253,10555316,10555317,10555318,10555319,10555320,10555321,10555322,10511373,10511379,10511380,10511381,10511382,10513402,10515544,10515545,10511548,10513822,10513828,10511850,10511879,10511880,10511881,10511882,10511883,10511884,10511885,10511886,10511887,10511888,10511889,10511890,10511891,10511892,10513907,10513908,10513917,10555946,10513983,10514013,10514014,10512069,10516201,10516292,10516293,10516384,10516385,10516386,10516388,10516389,10516390,10516391,10516392,10516393,10516394,10516395,10516396,10514562,10516624,10516625,10516626,10516686,10518976,10518977,10518978,10518979,10518980,10518981,10518982,10518990,10518991,10518992,10518993,10518994,10518995,10518996,10518997,10518998,10518999,10519000,10415291,10415292,10415293,10415294,10415295,10417296,10417297,10417298,10417300,10416302,10416303,10416304,10417331,10416343,10416348,10416351,10416352,10416353,10416354,10416355,10416369,10415479,10415480,10417509,10416555,10419577,10419578,10419579,10419580,10415618,10415619,10415620,10419671,10419672,10419703,10415728,10417733,10415804,10419821,10419822,10415859,10415860,10417103,10417104,10417131,10416132,10417132,10417133,10417134,10418160,10418161,10416161,10416162,10416163,10416194,10462907,10462908,10462909,10467104,10467122,10467136,10467143,10467146,10463394,10463395,10463397,10471488,10471489,10471560,10467633,10465739,10465740,10465741,10465742,10465743,10465744,10465745,10465746,10465747,10463752,10463755,10463756,10463771,10465773,10465774,10465775,10465778,10465779,10465782,10465798,10465855,10465878,10465879,10465886,10465892,10465893,10463905,10463915,10463916,10463917,10463918,8563339,10464041,10464045,8563415,10466313,10466314,10466315,10466316,10470316,10466317,10466320,10466337,10466338,10466339,10466377,10466393,10466399,10466400,10466425,10466426,10462446,10462456,10462457,10470479,10462484,10462516,10462615,10462680,10462681,10462682,10462683,10462724) 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'