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(10939561,10939983,10940106,10940108,4970749,4970750,4970899,4970916,4970936,4970937,4970939,4970976,4971073,4971074,4971075,4971076,8066911,8066938,8066953,8067160,8067161,8067199,8067200,8067230,8067471,8067472,8067473,8067474,8067475,8067476,8067477,8067478,8067479,8067480,8067481,8067482,8067483,8067504,8067505,8067509,8067691,8067696,8067712,8067804,8075337,8075338,4967031,4967032,4967033,8065981,8065982,8065983,8065984,8066014,8066015,8066016,8066218,8066483,8066507,8066558,8066565,8066575,8066630,8066661,8066662,8066692,8066713,8066714,4967996,8066758,8066774,8066775,8066789,8066790,8066800,8066838,8066850,8066851,8066852,8066853,3655506,3655507,3656209,3656210,3656211,3656212,3656217,3656218,3656219,3656260,3656261,3656262,3656270,3656331,3656592,3656998,3656999,3657000,8970007,10918475,10918476,10918477,10918478,10918479,10918480,10918481,10918482,10918483,10918484,10918485,10918486,10918487,10918488,10918489,10918651,10918652,10918653,10918697,10918698,10918737,10918747,10918748,10918749,10918750,10918751,10918752,10918753,10918754,10918755,10918756,10918757,10918758,10918759,10918760,10918761,10918762,10918763,10918764,10918765,10918766,10918767,10918768,10918769,10918770,10918771,10918772,10918773,10918774,10918775,10918776,10918777,10918778,10918779,10918780,10918781,10918782,10918783,10623504,10919188,10919189,10919190,10919191,10919192,10919193,10919194,10919195,10919196,10919197,10919198,10919199,10919200,10919201,10919202,10919203,10919204,10919205,10919206,10919207,10919208,10919209,10919210,10919211,10919212,10919213,10919214,10919215,10919216,10919217,10919218,10919219,10919220,10919495,10919496,10919497,10919498,10919499,10919500,10919501,10919502,10919503,10919504,10919505,10919506,10919507,10919508,10919509,10919510,10919511,10919512,10919513,10624056,10624057,10919824,10919825,10919826,10919827,10919828,10919829,10919830,10919909,10919950,10919951,10919952,10919953,10919954,10919955,10919956,10919957,10919958,10919959,10919960,10919961,10919962,10919963,10919964,10919965,10919966,10919967,10919968,10919969,10919970,10919971,10919972,10919973,10919974,10919975,10919976,10919977,10919978,10919979,10919980,10919981,10919982,10919983,10919984,10919985,10919986,10919987,10919988,10919989,10919990,10919991,10919992,10919993,10919994,10919995,10919996,10919997,10919998,10919999,10920000,10920001,10920002,10920003,10920004,10920005,10920006,10917472,10917473,10917474,10917475,10917476,10917477,10917478,10917480,10917481,10917482,10917483,10917484,10917485,10917486,10917487,10917488,10917489,10917490,10917491,10917492,10917493,10917494,10917495,10621985,10917496,10917497,10917498,10917499,10917500,10917501,10917502,10917503,10917504,10917505,10917507,10917508,10917509,10917510,10917511,10917512,10917513,10917514,10917515,10917516,10917517,10917518,10917519,10917520,10622011,10917521,10917522,10917523,10622014,10917525,10917526,10917527,10917528,10917529,10917530,10917531,10917532,10917533,10917534,10917535,10917536,10917537,10917538,10917539,10917540,10917541,10917542,10917543,10917544,10917545,10917546,10917547,10917548,10917549,10917550,10917551,10917552,10917554,10917555,10917556,10917557,10917558,10917559,10917560,10917561,10917562,10917563,10917564,10622055,10917565,10917567,10622060,10917570,10917571,10917572,10917576,10917577,10917578,10917579,10917580,10622071,10917581,10917582,10917583,10917584,10917585,10917587,10917588,10917589,10917590,10917595,10917596,10917597,10917598,10917599,10917600,10917601,10917602,10917603,10917604,10917605,10917606,10917607,10917608,10917609,10917610,10917611,10917612,10917613,10917622,10917623,10917624,10622115,10917625,10917626,10917628,10917629,10917630,10917631,10917632,10917633,10917634,10917635,10917636,10917637,10917638,10917639,10917640,10917641,10917642,10917643,10917644,10917645,10917647,10917650,10917651,10917652,10917653,10917654,10917655,10917656,10917657,10917658,10917659,10917660,10917661,10917662,10917663,10917664,10917665,10917666,10917667,10917668,10917669,10917670,10917671,10917672,10917673,10917674,10917675,10917676,10917677,10917678,10917679,10917680,10917681,10917682,10917683,10917684,10917685,10917686,10917687,10917688,10917692,10917693,10917694,10917695,10917696,10917697,10917698,10917699,10917700,10917701,10917702,10917703,10917704,10917705,10917706,10917707,10917708,10917709,10917710,10917711,10917712,10917713,10917714,10917715,10917716,10917717,10917718,10917719,10917720,10917721,10917722,10917723,10917724,10917725,10917726,10917727,10917728,10917729,10917730,10917731,10917732,10917733,10917734,10917735,10917736,10917737,10917738,10917739,10917740,10917741,10917742,10917743,10917744,10917745,10917749,10917750,10917751,10917752,10917753,10917754,10917755,10917756,10917757,10917758,10917759,10917760,10917761,10917762,10917763,10917764,10917765,10917766,10622257,10917767,10917768,10917769,10917770,10917771,10917772,10917773,10917774,10917775,10917776,10917777,10917778,10917779,10917780,10917781,10917782,10917783,10917784,10917785,10917786,10917787,10917788,10917789,10917790,10917791,10917792,10917793,10917794,10917795,10917796,10917797,10917798,10917799,10917800,10917802,10917803,10917804,10917805,10917806,10917807,10917808,10917809,10917810,10917811,10917812,10917813,10917814,10917815,10917816,10917817,10917818,10917819,10917820,10917821,10917822,10917823,10917824,10917825,10917826,10917827,10917828,10917829,10917830,10917831,10917832,10917833,10917834,10917835,10917836,10917837,10917838,10917839,10917840,10917841,10917842,10917843,10917844,10917845,10917846,10917847,10917848,10917849,10917850,10917851,10917852,10917853,10917854,10917855,10917856,10917857,10917858,10917859,10917860,10917861,10917862,10917863,10917864,10917865,10917866,10917867,10917868,10917869,10917870,10917871,10917872,10917873,10917874,10917875,10917876,10917877,10917878,10917879,10917880,10917881,10917882,10917883,10917884,10917885,10917886,10917887,10917888,10917889,10917890,10917891,10917892,10917893,10917894,10917895,10917896,10917897,10917898,10917899,10917900,10917901,10917902,10917903,10917904,10917905,10917906,10917907,10917908,10917909,10917910,10917911,10917912,10917913,10917914,10917915,10917916,10917917,10917918,10917919,10917920,10917921,10917922,10917923,10917924,10917925,10917926,10917927,10917928,10917929,10917930,10917931,10917932,10917933,10917934,10917935,10917936,10917937,10917938,10917939,10917940,10917941,10917942,10917943,10917944,10917945,10917946,10917947,10917948,10917949,10917950,10917951,10917952,10917953,10917954,10917955,10917956,10917957,10917958,10917959,10917960,10917961,10917962,10917963,10917965,10917966,10917967,10917968,10917969,10917970,10917971,10917972,10917974,10917975,10917976,10917977,10917981,10917983,10917984,10917985,10917986,10917987,10917988,10917992,10917993,10917994,10917995,10917996,10917997,10917998,10917999,10918000,10918001,10918002,10918116,10918117,10918118,10918119,10918120,10918121,10918122,10918123,10918124,10918125,10918126,10918127,10918128,10918129,10918130,10918272,10918273,10918274,10918275,10918276,10918277,10918278,10918279,10918280,10918281,10918282,10918283,10918284,10918285,10918286,10918287,10918288,10622902,10622914,10622915,10622916,10915472,10915473,10915474,10915475,10915476,10915477,10915478,10915479,10915480,10915481,10915482,10915483,10620307,10620353,10620354,10620381,10620382,10620488,10620491,10620654,10620655,10620656,10620657,10620658,10620659,10620660,10621323,10621381,10621382,10621422,10621428,10621429,10621445,10621446,10621447,10621456,10621529,10621615,10621649,10621658,10621668,10621675,10621732,10565148,10565149,10565159,10565320,10565321,10565349,10565445,10565446,10565447,10565448,10565449,10565843,10565844,10565845,10565846,10565847,10565848,10565849,10565850,10565851,10565852,10565853,10565854,10565855,10565856,10565857,10565858,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565875,10565876,10565954,10565955,10566059,10566073,10566074,10566075,10566109,10517306,10517307,10517308,10517309,10517310,10517311,10517312,10517634,10517635,10517725,10517726,10517727,10517728,10517729,10517730,10517731,10517732,10517733,10517734,10517735,10517736,10517737,10517738,10517739,10517740,10517741,10517742,10517743,10517744,10517745,10517746,10517747,10517748,10519089,10419241,10419242,10419271,10419272,10419274,10419275,10419276,10419278,10419279,10419280,10419281,10419282,10419284,10419293,10419294,10419299,10419339,10419340,10419341,10419370,10419539,10419540,10419543,10419544,10419545,10419546,10419547,10419548,10419549,10419550,10419555,10419556,10419557,10419562,10419563,10420064,10420102,10420110,10471128,10471129,10471278,10471482,10471483,10471490,10471493,10471494,10471499,10471500,10469911,10469920,10470212,10470213,10470384,10470385,10470487,10470489,10470490,10470491,10470592,10470593,10470666,10470667) 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'