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(10939535,10939596,8068869,8068870,8068871,8068872,10962581,10962582,10962583,10962584,10962585,10939632,10939637,10939642,10939643,10962638,10962639,10962640,10962641,10962642,10962643,10962644,10962645,10962695,10962696,10962697,10962698,10962699,10962700,10962701,10962983,10962984,10943815,7076321,10963045,10963076,10963077,10963078,10963079,10963080,7068485,8569518,10940265,10944076,10944077,10944078,10944079,4970936,4970937,4970938,4970976,4970977,4971027,7068717,7068718,7068719,4971096,10976509,10976510,10976511,10976512,10976513,10976514,10976515,10976516,10976517,10976518,10976519,10976520,10976521,10976538,10976539,8066966,8066967,7073972,7073998,7074035,8067199,8067200,8067206,8067207,8067285,8067286,10437257,8067391,8067392,8067656,8067657,8067658,10437571,7074663,7074675,7074676,7074677,7074678,7074679,7074680,7074681,10938491,10938492,10938493,10437733,7066864,7074867,7074868,7074869,7074870,7074871,7074872,7074873,7074874,8067906,8067910,8067911,8067912,7066967,7074991,7074992,7074993,7074994,7074995,4969606,4969607,4969608,4969609,4969610,4969611,4969612,4969613,4969614,10939199,10939200,10962350,7067746,10962442,10962443,10962444,7071954,7064084,7072084,7072093,10931548,8065208,8065209,8065210,8065211,8065212,8065213,8065214,8065215,8065216,8065217,8065218,8065219,8065220,8065221,10931621,10931622,10931642,10931911,10931912,10931913,10931914,10931915,10931916,10931917,10931918,10931919,7064480,10931920,7064481,10931921,7064482,7064483,10931922,10931923,10931924,10931925,10932076,10932116,10932245,10932251,8065987,8066014,8066015,8066016,8066020,8066120,7065118,10932588,10932589,7073175,7073192,10932869,10932870,10932871,10932872,10932873,10932874,10932875,10932876,7065465,7065466,7065467,7065468,10932917,10932942,10932944,10932945,10932946,10932956,10932958,10932960,7073536,10961271,7073627,7073628,7073677,7073678,10961382,10961383,10961384,10961394,10961395,10961396,8970132,8970133,7070920,7070921,7070922,7070923,7070924,7070951,7070952,7070991,10958676,10958677,10958678,10958679,10958680,10958681,10958682,10958683,10958684,10958685,10958686,10958687,10958688,10958710,10958711,10958712,10942769,10942770,10942771,10942780,10942791,10942792,10942793,8861039,7071196,7071197,7071198,10942963,10942964,10942966,10942967,10942968,10942969,10942970,10942971,10942972,10942973,10942974,10942975,10942976,10942977,10942978,10942981,10942982,10942983,10942984,8861340,10959236,10959237,10959238,10959239,10959240,10959241,5999948,5999949,5999950,5999951,5999952,5999953,5999954,5999955,5999956,5999957,5999958,5999959,5999960,5999961,5999962,5999963,5999964,5999965,5999966,5999967,5999968,5999969,8970209,10931199,6000080,10940550,10940551,10940552,10940553,10940554,10940555,10940556,10940557,10940558,10940743,10940744,10940745,10940762,7069058,7069059,7069060,3655798,3655818,3655819,10944647,10944753,10944772,7069268,8072472,8072494,8072495,8072496,8072506,8072507,8072508,8072521,8072522,8072523,3656375,3656478,8072703,8072704,8072705,8072706,8072707,8072845,8072846,8072847,8072848,8072849,8072850,8072851,8072852,8073084,8073085,8860280,7070651,8860641,8860642,8970131,10617962,10918737,10623324,10918875,10918903,10623418,10968042,10968043,10968044,10968045,10968046,10968047,10968048,10968049,10968050,10968051,10968052,10968053,10968054,10618559,10618560,10618561,10618562,10618563,10618564,10924281,10623789,10924307,10924308,10924309,10924310,10924311,10924312,10924313,10924314,10924315,10924316,10924317,10924318,10924319,10924320,10924321,10924322,10924323,10924324,10618861,10618862,10619063,10619064,10619065,10619066,10619067,10619068,8070834,8070835,8070836,8070837,10619237,8070947,10619347,10919909,8071134,8071135,8071136,10920150,10920151,10619881,10619894,10922496,10922497,10922498,10917500,10922515,10927524,10927576,10622093,10617137,10922685,10922686,10922687,10922688,10922689,10922690,10917956,10917957,10954017,10954018,10967026,10918032,10918033,10617524,10954097,10954098,10954099,10617571,10954112,10923268,10614989,10964603,10620076,10620121,10920653,10920654,10920655,10620178,10620179,10620243,10915800,10915801,10915802,10915803,10915804,10915805,10915806,10915807,10915808,10915809,10915810,10915811,10915812,10915813,10915814,10915815,10615383,10615384,8570401,10926232,10620859,10620860,10620861,10620862,10620863,10620864,10615989,10616018,10930851,10930852,10930860,10921666,10921667,10926717,10926718,10921874,10921875,10921876,10921877,10921878,10921879,10921880,10921881,10921882,10921883,10921884,10921885,10921886,10921887,10921888,10921889,10921890,10921891,10921892,10952921,10616474,10621571,10917134,10922191,10922192,10616699,10616700,10922362,10922363,10922364,10922365,10922366,10922367,10922368,10922436,10922437,10922441,10922443,10922444,10922445,10922446,10922447,10922448,10922449,10922450,10610963,10610965,10565153,10565338,10565339,10565340,10565341,10565342,7059739,10565608,10565609,10565610,10565611,10565612,10565613,10565648,10614538,10614588,10614641,8864532,10611698,8864670,10614828,10611878,10611925,10611926,10611927,10611928,10611929,10611930,10611931,10611932,10611933,10611934,10611935,10611936,10611937,10611938,10611939,10611940,10611973,10611981,10612006,10612007,10612009,10612070,10612071,10612072,10612073,10612077,10612226,10563382,10563383,8862156,8862157,8862158,8862159,8862160,8862161,8862162,7057862,10557513,10563515,10563516,7057904,10612552,10612554,10612566,10612567,10557718,7058094,10612625,10612639,10563789,10563790,10609670,10609671,10609672,7058264,10612844,7058473,10613122,8863082,10613234,7058822,7058823,7059285,7059286,7059287,7059288,7059289,7059290,7059291,7059292,7059293,7059294,7059295,7059296,7059297,7059298,7059299,7059300,7059301,7059302,7059303,7059304,7059305,7059306,10610868,10513144,10513145,10513146,10513147,10513148,10513149,10513150,10513151,10513152,10513153,10513154,10513155,10513156,10513157,10513158,10513159,10513160,10513161,10513162,10513163,7055722,4974460,10515423,4974473,10515440,10515441,10515442,10515443,10515444,10515445,10515446,10515447,10515448,10515449,10515450,10515451,10515452,10515453,10515454,10515455,10515456,10515457,10515458,7055823,10515523,10515524,10515525,10515526,10515527,10515528,10515529,10515530,10515531,10515532,10515533,10515534,10515535,10515536,10515537,10515538,10515539,10515543,10515544,10515545,4974715,4974716,4974719,4974720,4974721,4974722,4974723,4974724,4974726,4974727,4974730,4974731,4974732,4974733,4974739,10513731,4974790,4974791,4974792,4974793,4974916,4974917,4974918,7056312,7056313,7056314,7056315,7056316,7056317,7056318,7056319,7056320,7056321,4975125,7056480,10516223,10516224,10516244,10516245,10516246,10516247,10516248,10516249,10516250,10516251,10516252,10516253,10516254,10516255,10516256,10516257,10516258,10516259,10516260,10516261,10516262,10516263,10516264,10516265,7056774,7056775,7056776,7056777,7056778,7056779,7056780,7056781,7056782,7056783,7056784,7056785,7056786,7056787,7056788,7056789,7056790,7056791,7056792,7056793,10516462,10516463,10516464,10516465,10516466,10516467,10516468,10516469,10516470,10516665,10516666,10516667,10516668,10516669,10516670,10516671,10516672,10516673,10516674,10516675,10512743,10512744,10512745,10512746,10512747,10512748,10512749,10512789,10512790,10512791,10513091,10513092,10513093,10513094,10418282,10415627,10415628,10415629,4973571,4973572,4973609,4973670,4973671,4973766,4973943,10420063,10420064,10420071,10420102,10420103,10420104,10420105,10420108,10420109,10420110,10420111,10420113,10420117,10420118,10420126,10420127,10420149,4971442,4971443,10469744,10469823,10463834,10463835,10469854,8563385,8563386,8563387,8563388,8563389,8563390,8563391,8563550,10466507,10466508,10466509,10466510,10466511,10466512,10466513,10466514,10466515,10466516,10466517,10466518,4973064,10628407,10628830,10627193,10627960,10625139,10625140,10625141,10625142,10625143,10625144,10625145,10625146,10626116,10626117,10626118,10626119,10626120,10626121,10626122,10568938,10568939,10568940,10568941,10568942,10568943,10568944,10568945,10568946,10568947,10568948,10568949,10568950,10568951,10568952,10568953,10568954,10568955,10568956,10568957,10568958,10568959,10568960,10568961,10568962,10568963,10568964,10568965,10568966,10568967,10568968,10568969,10568970,10568971,10568972,10568973,10568974,10568975,10568976,10568977,10568978,10568979,10568980,10568981,10568982,10568983,10568984,10568985,10568986,10568987,10568988,10568989,10568990,10568991,10568992,10566123,10566124,10567480,10567481,10567482,10567547,10567548,10567549,10567550,10567680,10567681,10567682,10567683,10567684,10519320,10519321,10519322,10520822,10520955,10420283,10420341,10420541,10421018,10421020,10421021,10473237,10473238,10473239,10473240) 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'