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(10447836,10447880,10448056,11002041,11002220,11002221,11002222,11002466,11002467,8569899,8569900,11002609,11002610,8583454,7074161,11002921,11002922,10847005,11003018,8575605,8575606,11003136,11003288,11003289,11003290,11029388,11003496,8576068,11003593,7066919,7074951,10961636,8067930,10961818,10961819,10961820,8619982,10961843,8620060,11013954,11013955,11013956,10929580,8620162,8837861,8837862,8837863,11040119,11040120,8838048,11027392,11027393,11027394,11027395,11027396,11027397,11027398,11027399,11027400,11027401,11027402,11027403,11027404,11027405,11027406,11027407,11027408,11027409,11027410,11027411,11027412,11027413,11027414,11027415,11001501,11001502,11001503,11001504,8574047,10972722,10972856,11024882,11024883,11024884,11024885,11024886,11024887,11024888,11024889,11024890,11024891,11024892,11024893,11024894,8835736,8835748,8835798,7201782,8559507,7072610,10999350,10999351,10999352,7072670,7072712,10859063,10859064,10859065,10859066,10859067,10859068,10859069,10859070,10859071,7072811,7072969,7202219,7202220,7202223,7202385,8836651,8595822,8595850,8595858,8619224,8596134,8596236,10961308,10961309,10961310,8619509,8619581,8619582,8619583,10961502,10961503,10961504,10961505,10961506,10961507,8619675,10942738,11023854,11023855,11023856,11049124,11049128,11049140,11024031,8617205,8617258,8910525,8910550,8617369,8617463,8617464,10985328,10985329,10985330,4430315,10985376,7071706,8064692,8617561,4430395,7071777,7071778,10985475,4430442,10858120,10985586,11021699,11021700,11021701,11021702,11021703,3925573,3925675,10970003,10970004,3925712,3925794,3925795,11035109,11035135,7069457,8615312,3925888,11035209,8615391,3925972,3925973,11035285,3926049,3656233,3926226,11022540,11022541,11022542,11022543,11022544,11022545,11022546,11022547,11022548,11022549,11022550,11022551,11022552,11022553,11022554,11022555,11022556,8625531,8625532,10996606,10996747,11022781,11022782,11022783,11022784,11022785,3926504,8909173,8909305,8909306,8909307,10101457,10101458,8557282,11023124,11023125,11023126,11023127,11023128,11023129,11023130,8909562,8909563,10997204,10971214,10971215,10997374,8909771,3927121,3927154,8073519,11023524,11023525,11023526,10942482,8626518,8626519,8626520,8909932,8626521,11023578,10617988,10617989,10617990,10918521,10918522,10918523,10918524,8906067,11032785,8906185,8906186,8906187,10918704,7156756,7156758,7156759,7156760,11019935,8906363,8906364,7156864,7156865,10918876,10918877,10918878,10918879,10918880,10918881,10918882,10918883,11020190,10919268,10919269,10919270,10919271,10919272,10919273,10919274,11033454,11033455,11033456,11033457,11033458,10994680,10994681,7157572,11020735,11020736,11020737,11020738,11020739,11020740,11033740,11020741,11020742,11020743,11033744,11020744,11020745,11020746,11020747,10919601,10919602,7157752,7157753,7157754,7157755,10919851,10919914,10919915,7157954,7157955,7197714,10969157,10969158,10969159,10969160,10969161,10969162,11034215,10839332,10854927,11034357,11031650,11031651,11031652,10622035,11005718,11032050,11032051,11032052,11032053,10918029,10918160,10918161,7156255,11006496,10622907,10622908,11029705,11029706,11029707,11029708,11029709,11029710,11029711,11029712,11029713,11029714,11029715,11029716,11029717,11029718,11029719,11029720,11029721,11029722,11029723,11029724,11029725,11029726,11029727,11029728,11029729,11029730,11029731,11029732,11029733,11029734,11029735,11029736,8632785,10920762,10920763,8576617,8576618,11004180,8576790,11004317,11004318,11004319,8576866,10921267,11004538,8577040,8577041,8577042,10426249,11004634,8577153,10921548,8577245,10426468,10921642,11004813,8904230,10921767,10921768,10921769,10921770,10921771,8577419,8577420,8577421,11030954,8904362,10921898,10921899,10921900,11005249,11005251,11005252,11005253,11005254,11005255,8577750,11031258,11031259,11031260,11031261,11031262,11031263,11031264,11031265,11031266,11031267,11031268,11031269,11005496,11005556,11005558,11005559,11005560,11005561,8904984,8904985,6677768,9189683,6677911,9190005,9190006,9190054,8853930,8853931,9190192,9190193,8854119,8854120,9203377,9203378,9203379,9203380,9195384,9195385,9195386,9195387,9195388,7057623,7057631,10557346,10557347,10557348,10557349,9187621,10557511,9187803,9203816,9203817,9203818,10612506,9187908,10612583,9187996,9914207,9204005,9204006,9196039,9196097,9914333,9914334,9204127,9204181,10609859,10609860,10609861,10609862,10609863,10609864,10609867,10609868,10609869,10609870,10609874,9204237,10609914,10609915,8852090,8852102,8566790,9204387,9204388,9204389,9204554,10558562,10558563,10610657,9189064,10117508,6673539,9911811,9911813,10555493,8849525,8849526,8849595,8849596,9193783,8593008,8593009,9193910,9193911,9193912,9193913,7023573,9201988,10555836,7056195,9194119,9202134,10555997,10555998,10555999,10556000,10556001,10556002,10556003,10556004,10556005,10556006,10556007,10556008,10556009,10556010,6674404,10556011,10556012,10556013,10556014,10556015,9202265,8850106,8850107,9194343,9194344,9202429,9194481,9194482,9202602,6674818,9194622,9194623,9194727,10118926,9202746,6675013,9202867,9194867,9202868,9194868,9194869,9194870,9194871,9171152,10516983,9195276,9195277,6675498,9200468,9200469,9200470,9200471,9200472,6680684,8848356,8848357,8848358,8848360,6680768,9200612,9200841,9208938,8848837,6673218,10428404,10428437,8849058,8849060,8849061,6678508,6678509,8568829,9916559,6678568,9916662,8854291,9916719,10122755,9916778,9916779,4971490,8854471,8854472,8549938,9182850,10469532,10467609,10467610,10467611,10467612,9199035,10467623,10467624,10467625,10463678,10123335,10123371,8550485,10115579,8847296,8847379,10468221,8847547,6679948,6679949,6679950,6679951,6679952,9191749,6680019,6680020,9167831,8847741,8847742,10124138,10124212,9200026,9200027,9200028,6680253,6680254,9168066,10470670,10124309,10124409,9200233,8848110,10174486,10174757,10883764,10174824,10174825,10908909,10908923,10179935,10883927,10179962,10908969,10909029,10909030,10909031,10909032,10180158,10180159,10180160,10909161,10909162,10909163,10165209,10904204,10904329,10904330,8594457,10904467,10914468,10904468,10904469,10904470,10904471,10904472,10180560,10180561,10180562,10180563,10909626,10914643,10914644,10904711,10904712,10904713,10904714,10904715,10904716,10909829,10904910,10904911,10904912,10904913,10904914,10904915,10904916,10180943,10180944,10180945,10905012,10905013,10905014,10905015,10905063,10905064,10166184,10166185,10181223,10900360,10629926,10629927,10183628,10183629,10183630,10183631,10183632,10183633,10183634,10183635,10183636,10183637,10183638,10882905,10882906,10882910,10882983,10882984,10888184,10174380,10181493,10181494,10629979,10630062,10630102,10181705,10166867,10166868,10166869,10890870,10890871,10890946,10890955,10182045,10182212,10177317,10906360,10182374,10182375,10172382,10172383,10177401,10177402,10177403,10906465,10162545,10162595,10182620,10182621,10182622,10182623,10906627,10906628,10906794,10906795,10182807,10906796,10182808,10906797,10906798,10172842,10907041,10907042,10907043,10907110,10907111,10907112,10907113,10183143,10183144,10887300,10183326,10577220,10571440,10577474,10577475,10568653,10568654,10568655,10568656,10568657,10568658,10568659,10568660,10568661,10568662,10602559,10574739,10571850,10571851,10571852,10571853,10571854,10571855,10571856,10571857,10571858,10571859,10652945,10577899,10577900,10577901,10568904,10568905,10574913,10574914,10574915,10574916,10574917,10568925,10653166,10575177,10575178,10575179,10578257,10647350,10572308,10572309,10572310,10650389,10578343,10578344,10578345,10578346,10578347,10578348,10578349,10578350,10578351,10575436,10578646,10578647,10578648,10578649,10578793,10578794,10578795,10578796,10578797,10581828,10578876,10581884,10581925,10581926,10579098,10579099,10604182,10654414,10654415,10651535,10601555,10601556,10601557,10576968,10576969,10576970,10576971,10601860,10601861,10601866,10601867,10535409,10525562,10551591,10551592,10551593,10551594,10551595,10551596,10551597,10551598,10539706,10539707,10539708,10527798,10535998,10535999,10536000,10536001,10536002,10536003,10536004,10536005,10536006,10536007,10536008,10536009,10536010,10536011,10536012,10536013,10536014,10536410,10536411,10534479,10534480,10534481,10534482,10552483,10534483,10550547,10550548,10550549,10550550,10550551,10550552,10550553,10550554,10550555,10550556,10550557,10550558,10550559,10550560,10550561,10550562,10534647,10540769,10540820,10540821,10548899,10548913,10548914,10548915,10534928,10508311,10508312,10508358,10507940,10487930,10493935,10480996,10488013,10494020,10494021,10494132,10413564,10413565,10413566,10413567,10413568,10413569,10413570,10413571,10481226,10413572,10481227,10481228,10494265,10481448,10481449,10478123,10497246,10497329,10495517,10495518,10495519,10493745,10493845,10487856) 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'