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(10962687,10962688,10962689,8620854,10939888,10939919,10939920,11028168,11028169,11028170,11028171,11028172,11028173,11028174,11028175,8839005,8569617,8569618,8569619,8621625,10963724,10963725,8622096,8622097,10950971,8622223,8622224,8622225,10847235,7066485,10437411,7066564,7066565,7066566,7066567,7066568,7066569,8575761,7074613,7074809,10990603,10990604,10990605,10990606,10990607,10990608,10990609,7074962,7075009,8067904,8573613,8573614,8573615,10962187,7067548,10988246,11014271,11014272,11014273,7067656,10447618,10962455,7067797,7067798,7067799,7067839,7067911,10842701,8617973,8617974,10999086,10931769,11012204,10843311,10960441,10960442,10960453,10960454,11025676,11025677,11025678,11025679,11025680,11025681,11025682,11025683,11025684,11025685,11025686,10960838,7073237,7073238,7065394,7065395,10961087,10961088,10961089,8619522,8619523,8619524,8619595,8619596,8619597,8619631,7073902,7070942,7071152,11023931,8910473,10985254,10985255,10985256,10985257,10985258,10985259,10985260,10985261,10985262,10985263,10985264,10985265,10985266,10985267,10985268,10985269,10985270,10985271,10985272,10985273,10985274,10985275,10985276,10985277,10985278,10985279,10985280,10985281,10985282,10985283,10102863,8835319,8835320,8835321,8835322,8614817,8908217,7069267,3656538,3656539,3656540,3656541,3656542,3656543,3656544,3656549,3656550,3656551,3656552,3656553,3656554,3656555,3656556,3656557,3656558,3656559,3656560,8564728,8909338,10941989,10942062,8616280,11023431,7070833,7070835,10958563,10958564,10622976,10622990,10622991,10622993,10622994,10622995,10622996,10622997,10622998,10622999,10623002,8612819,10918540,10623062,10623063,10918615,10918616,11045835,11045839,10967988,10967989,10967990,11045995,8906389,10618366,10618369,10918956,10918957,10918958,10918959,11007121,11007122,10919315,11007627,11007628,11007629,10994721,8070824,8070825,11007798,11007799,11007800,11007801,10919659,10919660,10919661,10919662,11021039,11021040,11008051,8907490,8614347,11044632,11044669,11044670,11044671,8905241,8612026,10622434,10918044,10918045,10918046,10993353,10993354,10617745,10918375,10622953,10622954,10620113,10620138,10964891,10964892,11042929,10615277,10615278,10615279,10615282,10615283,8576812,8576813,10952282,10616002,8610879,10926764,10926765,10616463,10616892,9165539,9165541,9165549,10714177,9165823,8864466,10614633,10614634,10614638,9214195,9190196,9174207,10611974,10611975,10611977,10611998,9187423,9187424,9187425,9187554,10612229,9211683,9187741,9187742,9211819,9211905,9211906,9211907,9188003,9172087,9172088,9172089,9172090,9172091,9196370,9212466,10558290,10558291,10613142,10613145,10613146,10613149,10613155,9172494,9172502,10613168,10613169,10613171,10613172,10613174,9172512,10613177,10613178,10613251,10613254,10613259,10613265,10564434,10564435,10564436,10564437,10564438,10564439,10564440,10564441,10564442,10564443,10613364,9204793,9173132,10559032,10559033,10511157,10511158,10511159,10511160,10511161,10511162,10511163,10511164,10511165,10511166,10511167,10511281,10511282,10511283,9161515,10511462,10511464,7055921,7056008,10511766,10511767,10511768,10511769,10511770,10511771,10511772,10511773,10511774,10511775,10511776,10511777,10511778,10511779,10511780,10511781,10511782,10511783,10511784,10511785,10511786,10511787,10511788,10511789,10511790,10511791,10511792,10511793,10511794,10511795,10511796,10511797,10511798,10511799,10511800,10511801,10511802,10511803,10511804,10511805,10511806,10511807,10511808,10511809,10511810,10511811,10511812,10511813,10511814,10511815,10511816,9202004,10511817,10511818,10511819,10511820,10511821,10511822,10511823,10511824,10511825,10511826,7056179,10511827,10511828,9186015,10511829,10511830,10511831,10511832,10511833,10511834,10511835,10511836,10511837,10511838,10511839,10511840,10511841,10511842,10511843,10511844,10511845,10511846,10511847,10511848,10511849,10511850,10511851,10511852,10511853,10511854,10511855,10511856,10511857,10511858,10511859,10511860,10511861,10511862,10511863,10511864,10511865,10511866,10511867,10511868,10511869,10511870,10511871,10511872,10511873,10511874,10511875,10511876,10511877,10511878,10511879,10511880,10511881,10511882,10511883,10511884,10511885,10511886,10511887,10511888,10511889,10511890,10511891,10511892,10511893,10511894,10511895,10511896,10511897,10511898,10511899,10511900,10511901,10511902,10511903,10511904,10511905,10511906,10515907,10511907,10511908,10511909,10511910,10511911,10511912,10511913,10511914,10511915,10511916,10511917,10515918,10511918,10515919,10511919,10515920,10511920,10515921,10511921,10515922,10511922,10515923,10511923,10515924,10511924,10515925,10511925,10511926,10511927,10511928,10511929,10511930,10511931,10511932,10511933,10511934,10511935,10511936,10511937,10511938,10511939,10511940,10511941,10511942,10511943,10511944,10511945,10511946,10511947,10511948,10511949,10511950,10511951,10511952,10511953,10511954,10511955,10511956,10511957,10511958,10511959,10511960,10511961,10511962,10511963,10511964,10511965,10511966,10511967,10511968,10511969,10511970,10511971,10511972,10511973,10511974,10511975,10511976,10511977,10511978,10511979,10511980,10511981,10511982,10511983,10511984,10511985,10511986,10511987,10511988,10511989,10511990,10511991,10511992,10511993,10511994,10511995,10511996,10511997,10511998,10511999,10512000,10512001,10512002,10512003,10512004,10512005,10512006,10512007,10512008,10512009,10512010,10512011,10512012,10512013,10512014,10512015,10512016,10512017,10512018,10512019,10512020,10512021,10512022,10512023,10512024,10512025,10512026,10512027,10512028,10512029,10512030,10512031,10512032,10512033,10512034,10512035,10512036,10512037,10512038,10512039,10512040,10512041,10512042,10512043,10512044,10512045,10512046,10512047,10512048,10512049,10512050,10512051,10512052,10512053,10512054,10512055,10516055,10512056,10512057,10512058,10512059,10512060,10512061,10512062,10512063,10512064,10512065,10512066,10512067,10512068,10512069,10512070,10512071,10512072,10512073,10512074,10512075,10512076,10512077,10512078,10512079,10512080,10512081,10512082,10512083,10512084,9202294,10512214,10512215,10512216,10512217,10512218,10512219,10512220,10512221,10512222,10512223,10512224,9202446,9170647,9170648,9170649,9170650,9170651,9170652,9170653,9170654,9170655,9170656,9170657,9170658,9170659,10516488,10516489,10516490,10516491,10516492,9170703,9170704,9170705,9170706,9170707,9170708,9170709,9170710,9170711,9170712,9170713,9170714,9170715,9170716,9170717,9170718,9186832,9170962,9170963,9170964,10419226,10417280,10418320,10418321,10417395,10417397,10417400,10417407,10419411,10417411,10419412,10417414,10417416,9192495,10417418,10417423,10416447,10416452,10416457,10416458,10416471,10416472,10416473,10416474,10416475,10416476,10416478,10416479,10416480,8918208,10416484,8918209,10416485,8918210,10416486,10416487,10416488,10415540,10419541,10419551,10419552,9200632,10419932,10419933,10419934,10419935,10419936,10419937,10419938,10416985,10418987,7055284,9182601,9182602,9182603,9182604,9182605,9182606,9182607,9182608,9182609,9182610,9182611,9182612,9182613,9182614,9182615,9182616,9182617,9182618,9182619,9182620,9182621,9182622,9182623,9182624,9182625,10467224,9182830,10465857,10465858,10465859,10465860,10465861,10465862,10465863,10465864,10465865,10465866,10465867,10465868,10465869,10465870,10465871,10465872,10465873,10465874,10465875,10465876,10465877,10465878,10465879,10465880,10465881,10465882,10465883,10465884,10465885,10465886,10465887,10465888,10465889,10465890,10465891,10465892,10465893,10465894,10465895,10465896,10465897,10465898,10465899,10465900,10465901,10465902,10465903,10465904,10465905,10465906,10465907,10465908,10469954,6667438,10468027,10468066,10468079,10468091,10468092,9191533,9207576,8917441,9176126,6668236,6668237,10174769,10174770,10180211,10180212,10180624,10181252,10632208,10164041,10164042,10627875,10627876,10627877,10627878,10627879,10627880,10627881,10627882,10627883,10627884,10627894,10627895,10630106,10630107,10630108,10630109,10172298,10163111,10571492,10571493,10589632,10589633,10589640,10589667,10571943,10571944,10571945,10590226,10590227,10579908,10579970,10521192,10521214,10521215,10521216,10521217,10521218,10521219,10521220,10521221,10521222,10521223,10521224,10521225,10521226,10521227,10521228,10521229,10521230,10529334,10529585,10525606,10525607,10525608,10525609,10529620,10529621,10529622,10529623,10529624,10529625,10529626,10529627,10529685,10529686,10533827,10529975,10532218,10534278,10534279,10522637,10522638,10524844,10524845,10526910,10520955,10531043,10421223,10420451,10422690,10422691,10422693,10422694,10422696,10422697,10420832,10420833,10420834,10420835,10423001,10423002,10423003,10423004,10423005,10424055,10424059,10477569,10482009,10493677,10478748,10478749,10478750,10478751,10478752,10478753,10478754,10478755,10478756,10478757,10478758) 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'