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(10845604,10939601,10939649,11040660,11040661,10962687,10962688,10962689,4970399,10943633,10943634,10943635,10943636,10943637,10943638,10943639,7076288,7076291,7076294,4970652,4970653,4970654,4970655,4970656,4970657,4970658,7076353,7068365,4970724,3228805,3228806,10846227,3228905,10846254,10846288,8569544,8569552,11041317,10963319,10976328,10976329,8583211,8583212,8569758,4971129,4971130,4968152,4968153,4968154,4968155,4968156,4968157,4968158,4968159,4968160,4968161,4968162,4968163,4968164,4968165,4968166,4968167,8621895,10950695,7074191,8575750,8067862,8067863,7066898,3227359,3227360,3227395,3227396,3227398,3227399,8573187,8573228,8573229,7075066,10929539,10929540,3227728,8573544,8573604,7067428,7075437,7067470,7067560,11001275,11001276,10939339,10939395,10939397,8838177,8838178,8838179,10975398,10962448,3238456,10959856,7064299,7201608,7201609,7201610,7201611,7201612,7201613,7201614,7201615,7201616,7201617,7201618,7201619,7201620,7201621,10986173,3899075,10960286,10960287,10960288,10960289,10960290,10960291,10960292,10960293,10960294,10960295,10960296,10960297,10960298,7201869,7201870,7201871,7201872,10103929,8618654,8618655,10103951,10103952,10103953,10103954,10103955,8065973,8065977,8066080,11012768,7202567,10974163,7065548,7073573,7073574,7065593,4968144,4968145,4968146,4968147,4968148,4968149,4968150,4968151,7070839,7070846,7070847,7070848,7071534,8064694,8064695,8064696,8064697,8064698,8064699,8064700,8064701,8064702,8064703,8064704,8064705,8064706,8064707,8064708,8064709,10998410,10102916,3235262,10839813,10839830,3235519,10100318,10100319,10100320,10100321,8563950,8564016,7198756,7198773,8615478,8615479,8615480,8615673,3236286,3236287,3236288,3236289,3236290,3236291,3236292,3236293,3236294,10840964,10840965,11035906,11035907,11035908,11035909,11035910,11035911,11035912,11035913,11035914,10941949,10941951,10101407,10101408,10101409,10101410,7199532,10841175,8834247,8834248,8834249,8542334,8542335,10837703,10837704,10967664,10967665,10967666,7196258,7196267,7196271,7196275,7196289,7196295,7196296,7196299,7196302,7196304,7196305,7196311,7196315,7196319,7196322,7196327,7196336,7196340,7196342,7196347,7196352,7196354,10837869,10967834,8613014,10837936,10837970,10618369,10618370,10623372,7196522,7196529,10623463,10623478,10623479,8613285,8613288,10838221,10981243,10981244,10981245,10981246,10981247,10981248,10981249,10981250,10981251,10968252,10981252,10981253,10981254,10981255,10981256,10981257,10981258,10981259,10981260,10981261,10981262,10981263,10981264,10981265,10981266,10981267,10981268,10981269,10981270,10981271,10981272,10981273,7197041,10838637,10838638,11046637,10619150,11046783,11046937,11046959,11046960,11046961,11046962,11046963,10839034,11046967,11046969,11047098,11047099,11047100,11047101,11047102,11047103,11047104,11047105,11047106,11047107,11047108,11047109,11047290,11047485,10617198,10427424,10966847,8612026,8612027,8541736,8612075,8541920,10954266,10954267,10954268,10954269,10954270,10954271,10954272,10954273,10954274,10954275,10954276,10954277,10993401,10993402,10993407,11045463,11045464,10620055,10615353,10615354,10615415,10615709,10930538,10930539,10926272,10848444,10848445,11043389,11043390,10848466,8576932,8576933,10848513,10615927,10426158,10426159,10426160,10426161,10426162,10426163,10426164,10426165,10426166,10426167,10426168,10426169,10426170,10426171,10426172,10426173,10426174,10426175,10426176,10426177,10426178,10426179,10426180,10426181,10426182,10426183,10426184,10426185,10426186,10426187,8540427,10426280,10930933,10930934,10916686,10952689,10921961,10616474,8540861,10616533,10616534,11018094,11018095,8577646,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621660,10621661,10621662,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621673,10621674,10621675,10621676,10621677,10621678,10621679,10621680,10621681,10621682,10621683,10621684,10621685,10621686,10621687,10621688,8611402,10427047,10427048,10427049,10427050,8541207,8541208,10966428,10966429,10966430,8541289,8541290,7059546,7059859,10714171,9213722,10714236,9173798,9173800,10611570,9213939,9213940,9213941,9213942,9166033,7019766,7019770,10614819,3962535,3962536,8861869,8861870,8542599,8542601,10609119,10609120,10609121,10609122,10609123,10609124,10609125,10609126,10609127,10609128,10609129,10609130,10609131,10612267,9171656,10609339,10609340,10609341,10609342,10609438,9211780,9211781,9211782,9179836,9195848,10612539,10120079,10612587,10612588,9195933,9195958,7017800,10612879,7017900,7017901,7017902,7017903,7017904,7017905,7017906,7017907,7017908,7017909,9212314,10120563,10120564,10120565,10120566,10120567,10120568,10120569,10120570,10120571,9172387,9172404,10613112,10610178,7058774,7058775,10610318,10610319,10610334,9204739,9172944,9205064,9205065,9189212,7014960,10515125,7014972,7015009,10517179,7015021,10517180,10517181,10517182,10517183,10517184,10517185,10517186,10517187,10517188,10517189,10517190,10517191,10517192,10517193,10517194,10517195,10517196,10517197,10517198,10517199,10517200,10517201,7015075,7015087,7015120,7015132,7055922,9161799,9161800,9161801,9161802,9161803,9161804,9161805,9161806,9161807,9161808,9161809,9161810,9161811,9161812,9161813,9161814,9161815,9161816,9161817,9161818,9161819,9161820,9161821,9161822,9161823,9161824,9161825,9161826,9161827,9161828,9161829,9161830,9161831,9161832,9161833,9161834,9161835,10126119,10126123,7056293,10516055,9186752,9186797,9186798,9178849,9178850,9178851,9203019,10116499,9160415,10419692,10116982,10116983,10117031,10117032,10117033,10117075,10419814,10419833,10419842,10117119,10419845,10117151,10117232,10125261,7014777,7014789,9169178,10117377,10416113,7014863,7014882,7014905,7014917,10466951,10466952,10466953,9166709,8549919,10467365,10467366,10467367,10467368,10467369,10467370,10467371,10467372,10467373,10467374,10467375,10467376,9174799,10467377,10467378,10467379,10467380,10467381,10467382,10467383,10467384,9174844,9174845,10469662,10463762,10469769,8550393,9183249,9207266,3963596,3963598,9175406,9175421,10464016,10464017,10464018,10464019,10464020,10464021,10464022,9175445,10464023,10464024,10464025,10464026,10464027,10464028,10464029,10464030,10464031,10464032,10464033,10464034,10464035,10464036,10464037,10464038,8917118,9167473,9167474,9167475,9167476,9167477,9167478,9167479,9167480,10468057,9167481,9167482,9167483,9167484,9167485,9207485,9167486,9167487,9167488,9167489,9167490,9167491,9167492,9167493,9167494,9167495,9167496,9167497,9167498,9167499,9167500,9167501,9191542,10123780,9167639,8917340,9207864,10116189,10116190,10116191,8917641,10174534,10179595,10179596,10169840,10169841,10169842,10169843,10169844,10169845,10169846,10169847,10169848,10169849,10169850,10169851,10169852,10169853,10169854,10169855,10169856,10169857,10169858,10169859,10169860,10169861,10169862,10169863,10169864,10169865,10169866,10169867,10169868,10169869,10169870,10169871,10169872,10169873,10889043,10879054,10884437,10884593,10884656,10155692,10155693,10155694,10161338,10161339,10156476,10163612,10627326,10163892,10163893,10163904,10163920,10163922,10179047,10179048,10179049,10179050,7001388,10161720,10161721,10161722,10161723,10881363,10631235,10187812,10187813,10882193,10882194,10882195,10882196,10882197,10882198,10882199,10882200,10882201,10882202,10882203,10882204,10882205,10882206,10882207,10882208,10882209,10882210,10882211,10882212,10882213,10882214,10882215,10882216,10882217,10882218,10882219,10882220,10882221,10882222,10882223,10882224,10882225,10882226,10882227,10882228,10882229,10882230,10882231,10882232,10882233,10631747,10631748,10877294,10877295,10877296,10877297,10877298,10877299,10877300,10877301,10877302,10877303,10877304,10877305,10586163,10574235,10598855,10598856,10598857,10587072,10587073,10587074,10587075,10587076,10599115,10587236,10644457,10644458,10644459,10644460,10644461,10644462,10644463,10644464,10644465,10644466,10644467,10644468,10644469,10644470,10644471,10644472,10644473,10644474,10644475,10644476,10644477,10644478,10644479,10644480,10644481,10585265,10585266,10585267,10585268,10585269,10585270,10585271,10585272,10585273,10579456,10579457,10579458,10591758,10527168,10523236,10521332,10521333,10521334,10521335,10527534,10527535,10527536,10520352,10520353,10520354,10544437,10544438,10544439,10528630,10528631,10528632,10528633,10528634,10528635,10528638,10528639,10528640,10528641,10540720,10424319,10424325,10424456,10424507,10424554,10498487,10498488,10498489,10498490,10498491,10498492,10498493,10498494,10498495,10498496,10498497,10498498,10425048,10425078,10476878,10482194,10482195,10495497,10495586,10495587,10495787,10495788,10476844) 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'