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(7067855,10943461,7076012,10943535,7076095,10943666,7068159,10943687,10943724,7068284,7068285,7068286,7068287,7068288,7068289,7068290,7068291,7068292,7076369,10198632,4970745,8569404,10198674,10944017,10944068,10944071,10944072,10944073,10944074,10944075,4970916,4970917,4970918,4970919,4970920,4970921,4970922,4970923,8569564,4970924,4970925,4970926,4970927,4970928,4970929,10198941,10198942,10198943,10198944,10198945,10198946,10198947,10198948,10198949,10198950,10198951,10198952,10198953,10198954,4971143,10933292,7065967,7073981,7073982,7073983,7073984,7073985,7073986,4968323,7073987,4968333,4968334,7074051,7074052,7074053,7074054,7074055,7074056,7066180,10437195,4968607,4968608,4968609,4968610,4968611,4968612,4968613,4968614,10437250,10437407,7074488,10437435,7066524,7074604,7074634,7074658,7074681,7066855,7074861,7074867,7074868,7074869,8067910,8067911,8067912,7074964,10197295,10197296,10197297,10197298,10197299,10197300,10197301,10197302,10197303,7075142,10197388,10197389,7075163,7075186,7067223,7075245,7067247,7067253,4969592,4969593,4969594,4969595,4969596,4969597,4969598,4969599,4969600,4969601,7067265,4969602,4969603,7067268,4969604,4969605,7067272,7075276,7067278,7067281,7075290,10197579,10197580,10197581,7075532,7067646,7071829,7071831,10195136,10195137,10195138,10195139,10195140,10195141,7071969,7071970,7064075,10931666,10931681,10931714,10931715,10931716,7064298,7072484,10195886,10932258,10932302,10932323,7064941,10932469,10932496,10932497,10932498,10932499,10932500,10932501,7065152,10932600,7073223,10932672,10932678,10932687,7073278,7073279,7073280,10932738,7073302,10932756,10932759,10932762,7073381,7073382,10932847,10932852,10932853,7065462,7065463,7065464,10932907,10932945,10932946,10932951,10932955,10196847,10196857,10196859,7073643,10942544,7070869,7070870,7070905,7070906,7070907,7070908,7070950,7071011,7071012,10194258,10194357,10194358,10194359,10942912,10942913,10942914,10942915,10942916,10942917,10942918,10942919,10942920,10942921,10942922,10942923,10942924,10942925,10942972,10942973,8861192,10194704,10194705,8861410,8861411,8861413,7071572,7071583,10194893,10194894,8970223,6000087,7071813,10944353,10944388,10944395,10944398,10944400,10944412,10944443,10944535,7069027,7069028,7069029,7069030,7069031,7069032,7069033,10944716,10944719,10944725,10944728,10944729,10944730,10944732,10944735,10944736,10944738,7069232,10944847,10944920,8072307,10944969,10944986,10945013,10945014,10945018,10945025,10945026,10945028,10945029,8072373,8072374,10945036,10945039,10945041,10945044,10945048,10945050,10945058,8072451,8072465,8072466,7069691,8072663,8072664,8072665,8072666,8072667,7069849,10941737,10941738,10941739,10941740,10941741,8072998,8072999,8073001,10193411,10942142,10942145,10942185,10942186,8860374,8860484,8860490,8073457,10942318,8860506,8860560,8860567,8860604,10190054,10190055,10190056,10190057,10618002,10618003,10190129,10618050,10618066,10923623,10923624,10923625,10923626,10923627,10923628,10923629,10923630,10923631,10923632,10923633,10923634,10618240,10618241,10618242,10618243,10618244,10618245,10618250,10618251,10618253,10618254,10623296,10623297,10623298,10623299,10623300,10623301,10623302,10623316,10923849,10923850,10623410,10618477,10618478,10618479,10618480,10618481,10618482,10618483,10618484,10618485,10618486,10623493,10190613,10924086,10924087,10924088,10924089,10618830,10618831,10618889,10924513,10924514,10924515,10924516,10924517,10924518,10924519,10924520,10924521,10924522,10924523,10924524,10924525,10619016,10619017,10619018,10619019,10619020,10619021,10924701,10924702,10924703,10924704,10924705,10924706,10619341,10619351,10619356,10619357,10619358,10619359,8071112,8071113,10619458,10925175,10619875,10619880,10619923,10619927,10619928,10617052,10622305,10622306,10622307,10622308,10622309,10622310,10622311,10622312,10622313,10622314,10622315,10622316,10622317,10622318,10622319,10622320,10622321,10622322,10622323,10622324,10622325,10622326,10622327,10622328,10622329,10622330,10622331,10622332,10622333,10622334,10622335,10622336,10622337,10622338,10622339,10622340,10622341,10622342,10622343,10189435,10922930,10617426,10622536,10622539,10617803,10928355,10928356,10928357,10190009,10190053,10920520,10920521,10920522,10920523,10920524,10920525,10920526,10920527,10920528,10920529,10920530,10920531,10920532,10920533,10920534,10920535,10920536,10920537,10920538,10920539,10920540,10920541,10920542,10920543,10920544,10920545,10920546,10920547,10920548,10920549,10920550,10920551,10920552,10920553,10920554,10920555,10920556,10920557,10920558,10920559,10920560,10920561,10920562,10920563,10920564,10920565,10920566,10920567,10920568,10920569,10920570,10920571,10920572,10920573,10920574,10920575,10920576,10920577,10920578,10920579,10920580,10920581,10920582,10920583,10920584,10920585,10920586,10920587,10920588,10920589,10920590,10920591,10920592,10920593,10615091,8569933,10615170,10615171,10615172,8570039,10615225,10615226,10615227,10615228,8570101,8570174,10615364,10615365,10615366,10615367,10615368,10615369,8570279,8570280,8570281,8570282,8570283,8570284,8570285,8570286,8570287,8570288,8570289,8570290,8570291,8570292,8570293,8570294,10615521,8570401,10926093,10926111,10926112,10926113,10926114,10926115,10926116,10926117,10926118,10926119,10926120,10620637,10620638,10620639,10620640,10620641,10620642,10620643,10620644,10620645,10620646,10620647,10620648,10620649,10620650,10926161,10926162,10926163,10926164,10926206,10930515,10926277,10926334,10926335,10926336,10930637,10926337,10615941,10930766,10930854,10616048,10616049,10930893,10930894,10930904,10930905,10921656,10930970,10921810,10921811,10921812,10188466,10188467,10188468,10621432,10621433,10621434,10188579,10188580,10188581,10188582,10188583,10188584,10188585,10188586,10188587,10188588,10188589,10188590,10188591,10188592,10188593,10188636,10188649,10922218,10922219,10927278,10927280,10927282,10927283,10927284,10927285,10927286,10927287,10922460,10559215,10559216,10559217,10559324,10559325,10559326,8864290,8864291,8864313,8864314,8864320,8864321,10559632,8864590,10614765,8864666,8864776,10563136,10563137,8861898,10612040,10612166,10612167,8862152,8862153,8862154,8862155,10557614,10557615,10557616,10612565,10612618,10612642,10612646,10612658,8862822,8862837,8862847,8862854,8862868,8862874,10613017,8862956,8862958,8862960,8863079,10558400,10558401,10558402,10558403,10558404,10558405,10558406,10558407,10558408,10613367,10613368,10561527,10561528,10561529,10561530,10561554,10558598,10558618,10558619,10558620,10558621,10558622,10558623,10558624,10558625,10558626,10558627,10558628,10558629,10558630,10558631,10558632,10558633,10558634,10558635,10558636,10558637,10558638,10558639,10558640,10558641,10558642,10558643,10558644,10558645,10558646,10558647,10558648,10558649,10558650,10558651,10558652,10558653,10558654,10558655,10558656,10558657,10558658,10558659,10558660,10558661,10558662,10558663,10558664,10558683,10564687,10564712,10564820,10564821,10564822,10564823,10564824,10613721,8863588,8863589,8863590,8863591,8863592,8863593,8863594,8863595,8863596,8863597,8863598,8863599,8863600,8863601,8863602,8863603,8863604,8863605,8863606,8863607,8863608,8863609,8863610,8863611,8863612,8863613,8863614,8863615,8863616,8863617,8863618,8863619,4974168,4974169,4974173,4974174,10515146,10513150,10513176,10513205,10513206,4974280,4974281,4974282,4974433,4974434,10511446,10517609,10517610,10517611,4974831,10513909,10513910,10513913,10513914,10513915,10513948,10513984,10513989,10513998,4975085,4975086,4975087,4975173,10518142,10518143,10514166,10514167,10514168,10514169,10514170,10514171,10514172,10514173,10514174,10514175,10514176,10514177,10514178,10514179,10514180,10514181,10514182,10514183,10514184,10514185,10514186,10514187,10514188,10514189,10514190,10514191,10514192,10514193,10514194,10514195,10514196,10514197,10514198,10514199,10514200,10514201,10516202,10514202,10516203,10514203,10516204,10514204,10516205,10514205,10516206,10514206,10516207,10514207,10514208,2809241,10518553,10518554,10518555,2809396,2809397,2809398,10514899,10514900,10514901,10514902,10514903,10514904,10514905,10514906,10514907,10514908,10514909,10514910,10514911,10514912,10514913,10514914,10514915,10514916,10514917,10514918,10514919,10514920,10514921,10514922,10514923,10514924,10514925,10514926,10514927,10514928,10514929,10514930,10514931,8861685,10519004,10513089,10419303,4973236,4973237,4973238,10417362,10417370,10417380,10417388,10419436,10419493,10416515,10416540,10416556,10419581,10418625,10418626,10418649,10418650,10418677,10418678,10418679,10419719,10417009,10417143,10471129,10469530,10469723,10469724,10469725,10469800,10469801,10469802,10467973,10467984,10468001,10468018,10468043,10470077,10468370,10468371,10466500,10468769,10468770) 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'