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(4970717,10989324,7065981,7065994,7065995,7065996,7065997,7065998,7065999,7066000,7066001,7066002,8583491,8583532,8583533,8583535,10950703,10950704,10950705,10950706,10950707,10950708,10950709,7066086,10950726,7066126,7066173,7066183,7066254,8573257,8573258,8573271,8573329,8573330,8573334,8573340,4969569,10939403,10939404,8911744,8911951,8911954,8911961,8911962,7065342,8910075,8910239,8910240,8910253,10958953,10958954,10959113,10959114,10959115,10959116,10959117,10959259,8910661,8910671,8910672,8910673,8910674,8910675,8910676,8910677,8908422,8908434,8909072,10101485,10101497,10101498,8860342,8860343,8860394,8860401,8860402,8860403,8860436,8905953,8905963,8905964,8905965,8905973,10623063,8905974,8905975,8905976,8906014,8906015,8906016,8906017,8906018,10618300,10618301,10623505,11046047,8906780,8906933,8906936,8906937,8906941,8906945,8906946,8906952,8070774,8070776,8070777,8070778,10619177,10927510,8905201,8905267,8905292,8905293,8905294,8905295,8905296,8905341,8905366,8905367,8905368,8905369,8905370,10622460,8905371,8905372,8905373,8905374,8905375,8905376,8905377,8905378,8905379,8905380,8905381,8905382,8905383,8905384,8905385,10954391,8905869,10615001,10615046,10615048,10615202,10615264,10615265,10615266,10615267,10615287,10615371,10615398,10615401,10615403,10615518,10615519,10615520,10615521,10615522,10615523,10615524,10615525,10615526,10615537,10615571,10616173,10616538,10616539,10616540,10616541,10616655,10616656,10616657,10616716,10616840,10616841,10616842,10616860,9165375,10611064,10611106,10611108,10611109,10611126,10611151,10611152,10611153,10611154,10611155,10611156,10611157,10611158,10611159,10611160,10611161,10611162,10611163,10611164,10611165,10611166,10611167,10611168,10611169,10611170,10611171,10611172,10611173,10611174,10611175,10611176,10611179,9165547,10614274,10614275,10614276,10614277,10614278,10614279,10614280,10614281,10614282,10614283,10614629,10614637,10611708,10614732,10614733,10614734,10611775,10611776,10611777,10611819,10611820,10611848,10614855,10614856,7016953,7016954,7016955,7016956,7016957,7016958,7016959,7016960,7016961,7016962,7016963,7016964,7016965,7016966,7016967,7016968,7016969,7016970,7016971,7016972,7016973,7016974,7016975,7016976,7016977,7016978,7016979,7016980,7016981,7016982,7016983,7016984,7016985,7016986,7016987,7016988,7016989,7016990,7016991,7016992,7016993,7016994,7016995,7016996,7016997,7016998,7016999,7017000,7017001,7017002,7017003,10612013,7017004,7017005,10612014,7017006,10612015,10612016,7017007,10612017,7017008,7017009,10612018,7017010,10612019,10612020,7017011,7017012,10612021,7017013,10612022,10612023,7017014,7017015,10612024,7017016,10612025,10612026,7017017,7017018,10612027,10612028,7017019,7017020,10612029,10612030,7017021,7017022,10612031,10612032,7017023,7017024,10612033,7017025,10612034,7017026,10612035,7017027,10612036,7017028,10612037,10612038,7017029,10612039,7017030,10612040,7017031,10612041,7017032,10612042,10612043,10612044,10612045,10612046,10612047,10612048,10612049,10612050,10612051,10612052,10612053,10612054,10612055,10612056,10612057,10612058,10612059,10612060,10612061,10612062,10612063,10612064,10612065,10612066,10612067,10612068,10612069,10612070,10612071,10612072,10612073,10612074,10612075,10612076,10612077,10612078,10612079,10612080,10612081,10612082,10612083,10612084,10612085,10612086,10612087,10612088,10612089,10612090,10612091,10612092,10612093,10612094,10612095,10612096,10612097,10612098,10612099,10612100,10612101,10612102,10612103,10612104,10612105,10612106,10612107,10612168,10612169,10612206,10609264,10612289,10609328,10612343,10612344,10609348,10609350,10609351,10609352,10609357,10609358,10609359,10609362,10609363,10609364,10609367,10609376,10609377,10609378,10609385,10609386,10609393,8862511,8862512,10609710,10609711,10609712,10609817,10612972,10610006,10613021,10613022,10613034,10613056,10613080,10610090,9172534,10610260,10610271,10610289,10610300,10610301,10613350,10613351,10613352,10613353,10613354,10613376,10613377,10610503,10610505,10610614,10613643,10610653,10610682,10610692,10613751,10613804,10610836,10610837,7055496,7055497,7055498,7055499,9169376,9169377,9169433,9169529,9169530,9169531,9169532,9169533,9169534,9169538,9169543,9169648,9169752,9169753,9169754,9169755,9169756,9169757,9169758,9169759,9169777,9161891,9161892,9161893,9169904,10514037,10514038,9178414,10415221,10415222,10415223,10415224,10415225,10415226,10415227,10415228,10415229,10415230,10415231,10415232,10415233,10415234,10415235,10415236,10415237,10415238,10415239,10415240,10415241,10415242,10415243,10415244,10415245,10415246,10415247,10415248,10415249,10415250,10415251,10415252,10415253,10415254,10415255,10416256,10415256,10415257,10415258,10415259,10415260,10415261,10415262,10415263,10415264,9168343,10415265,9168344,10415266,10415267,10415268,10415269,10415270,10415271,10415272,10415273,10415274,10415275,10415276,10419277,10415277,10415278,10415279,10415280,10415281,10415282,10415283,10419283,10419284,10415284,10415285,10415286,10415287,10415288,10415289,10417289,10415290,9168369,10415291,10415292,9168370,9168371,10415293,9168372,10415294,10415295,9168373,9168374,10415296,10415297,9168375,9168376,10415298,10415299,9168377,10415300,9168378,10415301,9168379,10415302,9168380,10415303,9168381,10415304,9168382,10415305,9168383,9168384,10415306,10415307,9168385,10415308,9168386,10415309,9168387,9168388,10415310,9168389,9168390,9168391,9168392,9168393,9168394,10418317,10418318,10418319,10418320,10418322,10417336,10417337,10419367,10419368,10419369,10419370,10416375,10416378,10416381,9168460,9168475,9168511,10416457,10416458,10416459,10416460,10416461,10416462,10416463,10416464,10416465,10416466,10416467,10416468,10416469,10416470,10416471,10416472,10416473,10416474,10416475,10416476,10416477,10416478,10416479,10416480,10416481,10417494,10415545,10416549,10415550,10415551,10415554,10415555,10415556,10415558,10415560,10417560,10415562,10415565,10415568,10415571,10415572,10417572,10417574,10417575,10415577,10417583,10417585,9168666,9168667,10419604,10419608,10416609,10416610,10415610,10416611,10419611,10416612,10416613,10416614,10416615,10419615,10416616,10416617,10416618,10416619,10416620,10416621,10416622,10416623,10416624,10419624,10416625,10416626,10416627,10416628,10416629,10419630,10416630,10416631,10416632,10416633,10419634,10416634,10416635,10416636,10416637,10419638,10416638,10416639,10419643,10419648,10419656,10419660,10419663,10416667,10416668,10415675,10415676,10415677,10415678,10415680,9168764,9168765,9168875,9168876,9168988,9169033,10416065,10416066,10416067,10416068,10416069,10416070,10416071,10416072,10416073,10416074,10416075,10416076,10416077,10416078,10416079,10416080,10416081,10416082,10416083,10416084,10416085,10416086,10416087,10416088,10416089,10416090,10416091,10416092,10416093,10416094,10416095,10416096,10416097,10416098,10416099,10416100,9169179,10416101,10416102,10416103,10416104,10416105,10416106,10416107,10416108,10416109,10416110,10416111,10416112,10416113,10416114,10416115,10416116,10416117,10416118,10416119,10416120,10416121,10416122,10416123,10416124,10416125,10416126,10416127,10416128,10416129,10416130,10416131,10416132,10416133,10416134,10416135,10416136,10416137,10416138,10416139,10416140,10416141,10416142,10416143,10416144,10416145,10416146,10416147,10416148,10416149,10416150,10416151,10416152,10416153,10416154,10416155,10416156,10416157,10416158,10416159,10416160,10416161,10416162,10417162,10416163,10416164,10416165,10416166,10416167,10416168,10416169,10416170,10416171,10416172,10416173,10416174,10416175,10416176,10416177,10416178,10416179,10416180,10416181,7055463,10471027,10471028,10471069,10467468,10469517,10469520,10467774,10468014,10468015,10468016,10468017,10468018,10468019,10468020,10468021,10468022,10468023,10468024,10468025,10468026,10468027,10468028,10468029,10468030,10468031,10468032,10468033,10468034,10468035,10468036,10468037,9183485,10470110,10470111,9167633,10468259,10468260,10468261,10468262,10468263,10468264,10468265,10468266,10468267,10468437,10468438,10468439,10468440,10468441,10468442,9167914,10468501,9167926,9167938,10468522,9167994,9168085,9168086,10470703,9168154,10468769,10468774,10468777,10468839,10468843,10468846,10468849,10628154,10628845,10628847,10628849,10174093,10627724,10627725,10627726,10161772,10161842,10161843,10161917,10161959,10161960,10161961,10161962,10161963,10161964,10161965,10162031,10162033,10162051,10162052,10162053,10631403,10631404,10631405,10631406,10631407,10631408,10631409,10631410,10631411,10626473,10163108,10591726,10591727,10522597,10527002,10424409,10424419,10424430,10424435,10421506,10421507,10423926,10423927,10423928,10423929,10423930,10423931,10488267,10488268,10488269,10488270,10488271,10488272,10488273,10488274,10488275) 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'