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(10250152,10103768,10103769,7201898,10237394,10237395,10237468,10843580,10843582,8618679,10104055,8618811,8618812,10843797,7202371,7202448,7202449,7202450,7202451,7202452,7202453,10250931,10250932,10250934,10844178,7202672,10844179,10844180,10104578,10104579,7202770,10238405,10238430,10238598,10238599,10238600,10238603,10238604,10238605,10238606,10238607,10238608,10238609,10238610,10238611,10238612,10238613,10238614,10238622,10225630,10238633,10238634,3227401,10844749,10238726,10238727,10238895,10212901,10238974,7200599,7200606,7200609,10223208,10223209,10223210,8910574,7200779,10197275,10197276,10102901,7067298,7201199,7201273,7201386,7201387,10842980,8618066,10842998,10843025,7067767,10250016,10250017,10250018,10250019,10250020,10250021,10250022,10250023,10250024,10250025,10250026,10250027,10250028,10250029,10250030,10250031,10250032,10250033,10250034,10250035,10250036,10250037,7198678,8615274,6000196,6000197,7198695,7198713,7198721,7198725,7198742,7198744,7198745,7198747,7198748,7198749,7198751,7198757,7198763,7198765,10234505,8615755,10931902,10840883,10840884,10234896,7199768,8565245,8565255,8565256,10101770,10274460,10274461,10274462,10274467,10274468,10274472,10274473,10274474,10274475,10274482,10235589,10235590,10235600,10235601,10235602,10235603,10235604,10235605,10235606,10235607,10235608,10235635,10102055,10235636,10932979,10933000,7073622,10235923,10235924,7065694,8834762,7197622,7197677,7197700,7197701,7197743,7197744,7197746,7197747,7197795,7197798,7197799,7197812,7197813,7197814,7197815,8907668,10233358,10233366,10233367,10233373,10233376,10233377,10233378,10285543,8563610,10943257,7198383,7198390,10100300,10100301,10233978,8612196,8612197,8612198,8612448,8542233,8542253,8542369,8612733,8612734,7196183,8579115,7196184,7196187,7196188,7196211,7196212,7196214,7196216,7196224,7196225,7196226,7196228,7196231,10837777,8612935,8612937,8612938,7196411,7196412,7196414,7196415,7196416,7196418,7196419,7196448,7196470,7196475,10283942,10941716,10941719,10941757,10941763,10941767,10941773,10941782,10941809,7196893,7196903,7196908,7196914,7196916,7196917,7196920,7196921,7196931,7196932,7196933,7196936,7196960,7196973,7196975,7196978,7196983,7196984,7196985,10838528,8613644,8906884,8860265,8907030,7070497,8860418,10838833,10838968,10838970,10838972,10838975,10838982,10838985,10838988,10838990,8907300,8860633,10839015,10839016,7197589,10281160,10190164,10281188,10281204,10281205,10229372,10433255,10433256,10433258,10433259,10433260,10426204,8540352,10229580,10229602,10229603,10229604,10433521,8540530,8540541,8540542,8540568,8540613,8540614,10623731,8611003,8611004,8904273,8611086,8611087,8611088,8611089,10229999,10230000,8904364,10191042,8540849,10230085,8541013,10204251,8578018,8578023,10282623,10282651,10282652,10282653,10282654,8541578,8905258,8905259,8905261,8905262,8905263,10922518,10922520,8575581,10432046,8575768,8609570,8609571,8609572,8609573,10617378,10617394,10617407,10617419,10622428,10617440,10617441,10617442,10617454,10928029,10425356,10432595,10432596,10228805,10928326,8576393,10189935,10189936,10189937,10189938,10848003,10615167,10845422,10845423,10845424,10845425,10845426,10615472,10447778,10447794,10447801,10447803,8574287,10620765,10620766,10620767,10620768,8574476,8574477,8574479,8574481,8574482,8574486,8574487,8574488,8574490,8574491,8574492,8574493,8574494,8574507,8574508,8574509,8574510,8574511,8574516,8574517,8574518,8574519,8574520,8574529,8574530,8574531,8574532,8574533,10616118,10616119,10930951,10931016,8621465,10188385,10240407,10188490,8583479,8583481,8583482,10201792,10922282,10431781,10431783,10616905,9205389,7019061,7019096,7019134,10565324,10565325,10565326,10565327,7059757,7019289,7019323,7019355,10122122,10714438,10714444,9174059,9174060,9174061,9174073,9174082,9174085,9174086,9174208,9190244,9190245,9190246,7019948,10611969,10612059,9187499,10119704,10119705,10119724,9187551,9187552,9211555,10612292,10612293,9211926,9211936,9172154,7017938,9220272,7017958,7017978,8862865,8862873,9196360,9188363,9188381,9188395,10613137,7018177,10613393,8863271,7018513,7018547,7018581,7018615,7018649,9173136,7018821,10564992,10564993,7018855,7018889,9169317,9177367,9185607,7015282,7015302,9209652,7015322,9185725,9185726,9169727,9185730,9185737,9185738,9185744,7055923,9185856,9185866,9185879,9185896,9185897,9169943,9185944,9185945,9185946,9169982,7056303,7056304,10118374,10118375,10514021,10514023,10516164,9178498,9186790,10119044,10516787,10516913,10516917,10119392,10119416,4973195,9192346,4973424,10419497,10419498,10124801,9168790,10419712,10419724,10419741,10419742,9193120,10417087,10417088,10417089,10417090,10417091,10417092,10417093,10417094,10417095,10417096,10417097,10417098,10417099,10417100,10417101,10417102,10417103,10417104,10417105,10417106,10417107,10417108,10417109,10417110,10417111,10417112,10418141,9169232,10419189,7019976,7020004,7020032,7020060,8549563,10467095,10467098,10467099,7020185,10467102,10122731,10467114,7020213,10467144,10467148,7020241,10471175,10467224,8549882,8549902,8549918,8549919,7020468,7020492,7020516,9190866,7020540,7020564,7020588,8550097,7020612,7020636,9198994,9199023,9199024,9199025,9199026,9199027,9199028,9199029,7020685,9199040,9199041,8916698,7020738,7020763,10465684,10465685,10465686,10465687,10465688,10465690,10465695,10465698,10465699,10465700,7020788,10465705,10465706,10465707,10465709,10465710,7020809,7020829,7020850,10465788,7020872,10465801,10465802,10465806,10465808,7020893,10465809,10465810,10465811,10465825,7020913,9175273,10465848,7020933,8916928,8916929,8916930,9175288,10465859,10465860,10465861,10465869,9175300,10465870,10465871,10465872,10465873,10463877,10463879,10465881,10465882,10463883,10465883,10463884,10465888,10463889,10465889,10465890,7020979,10463896,10463898,10463899,10465899,10463900,10463901,10465901,10465903,10463907,10463908,10465908,10463909,10463910,10465915,10465917,10463923,10463924,10463925,10463929,7021083,7021103,7021136,8550648,10466208,10466209,10466211,10466212,10466214,10466215,10466216,10466219,10466221,10466222,10466227,10466228,10466230,10466237,10466238,10466240,10466242,8550898,10466330,8550922,8550924,10466347,10466349,10466351,10466361,10466362,10466395,10466397,10466405,10466406,10466407,10466408,8550994,8550995,8550996,10466413,10466415,10466427,10466428,10466436,10466446,10466448,10466449,9175881,10466451,10466453,10466457,10466458,9175893,9192014,9168100,9192226,9192227,9192228,9192229,9160272,10888839,10884075,10884077,10884080,10884081,10884629,10884653,10884725,10890149,10890155,10890171,10156210,10890258,10887484,10887485,10887486,10163533,7000845,10163785,10632300,10632301,10632302,10153871,10173958,7001165,10184047,10184048,10883044,10184049,10184381,10184382,10184383,10184384,10888381,10184386,10184396,10184400,10184401,10184402,10184403,10184404,10184405,10184406,10184407,10184408,10184409,10184410,10184411,10883421,10885564,10885867,10172016,10172019,10172076,10886071,10886072,10886073,10886074,10886075,10886076,10886077,10162248,10167560,10626131,10626132,10626235,10626258,10167914,10631414,10631415,10631416,10631417,10631418,10167943,10167954,10626439,10167971,10167972,10167973,10167988,10167995,10168001,10168012,10168015,10168019,10168043,10168046,10168047,10168056,10882061,10173113,10173114,10173115,10887190,10659590,10659663,10887464,10568116,10568117,10568118,10568119,10568120,10568121,10568122,10568123,10568124,10568125,10643482,10580477,10580478,10566188,10590298,10590673,10579479,10591802,10539113,10539114,10541367,10541368,10541369,10521609,10539811,10539812,10527840,10528142,10528146,10528162,10528176,10522303,10522315,10522341,10522357,10522358,10524426,10522889,10520893,10539094,10422280,10422383,10421398,10421400,10421401,10421402,10421406,10421407,10420434,10420441,10420442,10498369,10498370,10422536,10422537,10422562,10421574,10422595,10422596,10422597,10423661,10423662,10423667,10423668,10423669,10423672,10423673,10423674,10423675,10423676,10423677,10423678,10423680,10423681,10423682,10423683,10420849,10423151,10489982,10477100,10483158,10483159,10483161,10483162,10483163,10483164,10483165,10483166,10483167,10483168,10483169,10483173,10483174,10483175,10483176,10473265,10473270,10488299,10490356,10490357,10490358,10490359,10490360,10490361,10490362,10490363,10490364,10490365,10490366,10490367,10477385,10483453,10496616,10490721,10490723,10490725,10490726,10490727,10490728,10490729,10486951,10478007,10493046,10474090,10474091,10474092,10474093,10474094,10474095,10474096,10474097,10474098,10474099,10474100,10474101,10474102,10474103,10474104,10474105,10474106,10476537,10487541,10487542,10406985,10406990,10407052,10407058,10472755,10487786,10478842) 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'