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(10943546,10944092,10940504,10940509,10940513,10940515,10940520,10940521,10940522,10940524,10940525,10940526,10940527,10940530,10940531,10940536,10940537,10940548,10940550,10940551,10940555,10940556,8066913,8066914,8066915,8066916,8066917,8066918,8066919,8066920,8067749,8068477,10939214,10939225,4969822,4969823,4969824,4969825,4969826,4969827,4969828,4969829,4969878,4969879,4969880,4969881,4969882,4969883,4969906,4969907,4969908,4969909,8068597,8068600,8068601,8068603,8068604,8068605,8068606,8068608,8068611,8068613,8068614,8068615,8068616,8068617,8068619,8068622,8068623,8068624,8068625,8068626,8068627,8068628,8068629,8068630,8068631,8068632,8068635,8068636,8068637,8068638,8068639,8068640,8068642,8068643,8068645,8068646,8068647,8068648,8068650,8068651,8068652,8068654,8068655,8068656,8068658,8068659,8068660,8068661,8068662,8068664,8068666,8068667,8068669,8068670,8068672,8068673,8068676,8068677,8068678,8068680,8068681,8068683,8068685,8068686,8068687,8068688,8068689,8068691,8068692,8068693,8068694,8068696,8068697,8068700,8068701,8068702,8068703,8068706,8068707,8068709,8068710,8068711,8068712,8068713,8068714,8068715,8068722,8068723,8068727,8068728,8068730,8068731,8068732,4970057,4970058,8068734,8068735,8068737,8068739,8068740,8068741,8068743,8068744,8068746,8068747,8068748,8068749,8068750,8068752,8068753,8068755,8068757,8068758,8068759,8068761,8068762,8068763,8068764,8068765,8068766,8068767,8068768,8068769,8068771,8068772,8065283,8065305,8065306,8065307,8065308,8065309,8065311,8065321,8065374,8065389,8065390,8065399,8065413,8065417,8065418,8065478,4967566,4967567,4967568,4967569,4967570,8066482,8066559,8066561,8066562,8066564,8066565,8066566,8066567,8066568,8066569,8066570,8066572,8066573,8066574,8066575,8066576,8066577,8066578,8066579,8066580,8066581,8066585,8066586,8066587,8066588,8066589,8066591,8066592,8066596,8066598,8066599,8066600,8066601,8066603,8066604,8066607,8066608,8066609,8066610,8066613,8066614,8066615,8066617,8066618,8066619,8066621,8066623,8066624,8066626,8066627,8066628,8066629,8066630,8066631,8066632,8066633,8066634,8066635,8066637,8066639,8066641,8066642,8066643,8066644,8066645,8066646,8066647,8066648,8066650,8066651,8066652,8066653,8066656,8066657,8066658,8066659,8066660,8066661,8066663,8066664,8066665,8066666,8066667,8066669,8066672,8066673,8066674,8066675,8066676,8066677,8066678,8066679,8066681,8066682,8066683,8066684,8066685,8066686,8066687,8066690,8066691,8066692,8066693,8066694,8066695,8066696,8066697,8066698,8066699,8066700,8066704,8066705,8066706,8066707,8066708,8066709,8066712,8066713,8066715,8066716,8066717,8066719,8066721,8066722,8066723,8066724,8066726,8066727,8066730,8066731,8066734,8066736,8066741,8066743,8066744,8066745,8066746,8066750,8066751,8066752,8066755,8066758,8066759,8066760,8066761,8066762,8066767,8066776,8066777,8066778,8066783,8066784,8066785,8066786,8066789,8066790,8066791,8066792,8066795,8066800,8066801,8066802,8066807,8066808,8066809,8066812,8066815,8066816,8066820,8066821,8066823,8066830,8066832,8066838,8066839,8066840,8066844,8066845,8066850,8066851,8066854,8066856,8066857,8066862,8066863,8066864,8066865,8066879,8066880,8066884,8066887,8066889,8066891,8066892,8066893,8066894,8066896,8066897,8066898,8066900,8066901,8066905,8066906,8066907,8066908,8066909,8066910,8066912,10942731,10942744,10942746,8064477,8064478,10943157,10943179,10940559,10940560,10940562,10940564,10940567,10940569,10940570,10940572,10940576,3656206,3656207,3656208,3656209,3656220,3656221,3656222,3656223,3656253,3656265,3656266,3656267,3656270,3656271,3656273,3656278,3656680,3656705,8073495,8073496,8073497,8073498,8073499,8073500,8073501,8073502,8073503,8073504,8073505,8073514,8073517,8073518,8073519,8073520,8073521,8073525,11049765,10622029,10917817,10917827,10917828,10917829,10917830,10917831,10917832,10920740,10920741,10920742,10920743,10920744,10920745,10920746,10920747,10920748,10920749,10920750,10920751,10920752,10920753,10920754,10920755,10920756,10920757,10920758,10920759,10920760,10920761,10920762,10920763,10920764,10920765,10920766,10920767,10920768,10920769,10920770,10920771,10920772,10920773,10920774,10920775,10920776,10920777,10920778,10920779,10920780,10920781,10920782,10920783,10920784,10920785,10920786,10920787,10920788,10920789,10920790,10920791,10920792,10920793,10920794,10920795,10920796,10920797,10920798,10920799,10920800,10920801,10920802,10920803,10920804,10920805,10920806,10920807,10920808,10920809,10920810,10920811,10920812,10920813,10920814,10920815,10920816,10920817,10920818,10920819,10920820,10920821,10920822,10920823,10920824,10920825,10920826,10920827,10920828,10920829,10920830,10920831,10920832,10920833,10920834,10920835,10920836,10920837,10920838,10920839,10920840,10920841,10920842,10920843,10920844,10920845,10920846,10920847,10920848,10920849,10920850,10920851,10920852,10920853,10920854,10920855,10920856,10920857,10920858,10920859,10920860,10920861,10920862,10920863,10920864,10920865,10920866,10920867,10920868,10920869,10920870,10920871,10920872,10920873,10920874,10920875,10920876,10920877,10920878,10920879,10920880,10920881,10920882,10920883,10920884,10920885,10920886,10920887,10920888,10920889,10920890,10920891,10920892,10920893,10920894,10920895,10920896,10920897,10920898,10920899,10920900,10920901,10920902,10920903,10920904,10920905,10920906,10920907,10920908,10920909,10920910,10920911,10920912,10920914,10920918,10920919,10920920,10920933,10920934,10920935,10920938,10920945,10920946,10920947,10920954,10920957,10920964,10920966,10920968,10920972,10920973,10920975,10920976,10920978,10920984,10920989,10920998,10920999,10921000,10921003,10921004,10921005,10921010,10921013,10921018,10921019,10921020,10921027,10921028,10921034,10921035,10921037,10921039,10921040,10921041,10921044,10921045,10921046,10921056,10921057,10921058,10921062,10921067,10921068,10921069,10921072,10921073,10921078,10921079,10921080,10921086,10921087,10921095,10921101,10921106,10921107,10921108,10921117,10921125,10921129,10921130,10921131,10921132,10921133,10921142,10921146,10921147,10921148,10921149,10921150,10921151,10921152,10921153,10921154,10921165,10921166,10921167,10921172,10620663,10921175,10921176,10620667,10921185,10921186,10921187,10921188,10921191,10921192,10921197,10921198,10921200,10921201,10921202,10921203,10921204,10921205,10921206,10921207,10921208,10921209,10921217,10921218,10921220,10921222,10921223,10921224,10921225,10921226,10921231,10921233,10921235,10921236,10921239,10921241,10921242,10921243,10921244,10921246,10921248,10921249,10921250,10921251,10921252,10921253,10921254,10921259,10921260,10921261,10921262,10916445,10916446,10916447,10916448,10916449,10916450,10916451,10916452,10916453,10916532,10916533,10916534,10916535,10916536,10916537,10621421,10621422,10621423,10621427,10621428,10621429,10621430,10621431,10621439,10621440,10621441,10621444,10621445,10621446,10621447,10621448,10621449,10621450,10621451,10621452,10621453,10621454,10621455,10621456,10621457,10621458,10621459,10621460,10621461,10621462,10621463,10621464,10621465,10621466,10621467,10621468,10621469,10621470,10621471,10621472,10621473,10621474,10621475,10621476,10621477,10621478,10621481,10621483,10621486,10621487,10621488,10621489,10621490,10621491,10621492,10621496,10621497,10621500,10621501,10621502,10621503,10621504,10621510,10621511,10621513,10621514,10621516,10621517,10621518,10621521,10621522,10621526,10621529,10621530,10621531,10621532,10621534,10621537,10621538,10621541,10621542,10621543,10621544,10621565,10621571,10621572,10621573,10621575,10621580,10621581,10621582,10621585,10621587,10621588,10621589,10621594,10621596,10621597,10621598,10621599,10621600,10621601,10621602,10621609,10621620,10621630,10621631,10621632,10621633,10621634,10621637,10621640,10621642,10621645,10621647,10621649,10621650,10621651,10621652,10621653,10621654,10621655,10621656,10621657,10621658,10621659,10621661,10621663,10621664,10621665,10621666,10621667,10621668,10621669,10621670,10621671,10621672,10621677,10621678,10621679,10621681,10621682,10621683,10621684,10621685,10621687,10621688,10621689,10621690,10621691,10621692,10621693,10621694,10621695,10621698,10621699,10621701,10621702,10621703,10621704,10621705,10621708,10621710,10621713,10621714,10621715,10621717,10621721,10621724,10621726,10621727,10621728,10621729,10621731,10621732,10621733,10621735,10621736,10621737,10621738,10621739,10621741,10621742,10621743,10621745,10621746,10621747,10621748,10621749,10621750,10917324,10917325,10917326,10917327,10917328,10917329,10565158,10609306,10610290,10463104,10463120,10463121,10463122,10463123,10463124,10463170,10463177,10463183,10463184) 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'