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(7076128,3229049,3229304,10862745,10862746,10862760,10862761,10862780,10862789,10862798,8573288,8617990,10858623,10858626,10858628,10858631,10858635,10858638,10859368,5654681,7202651,7065856,10863274,10863280,10863282,10863289,10863340,10855527,7198491,8625110,8625116,8625117,8625118,7199022,7199023,7199024,7199381,10837943,10618268,10618277,10618278,10618279,10618280,10618281,10618286,10618287,10618289,10618291,10618296,10618316,10618317,10618318,10618321,10618322,10618324,7196549,7196554,8906634,7197081,8907065,8907068,8907069,7197480,7197526,10617332,3232907,10852889,10852890,10425484,10615178,10615179,10615580,10615825,10615826,10615828,10615829,10615830,10615831,10615832,10615833,10615834,10615835,10615836,10615837,10615838,10615839,10615840,10615841,10615842,10615843,10615844,10615845,10615846,10615847,10615848,10615849,10615850,10615851,10615852,10615853,10615854,10615855,10615856,10615857,10615858,10615870,7155306,7155307,10616840,10616841,10616859,7059524,10611104,10611758,8851387,8851388,7017924,7017925,8852314,10610295,10613633,9911585,9169428,9169430,9169588,9161592,9169641,9169642,9169643,9169645,9169648,9911900,10118128,6674185,6674188,9169982,6674189,9912201,9912966,9913161,8565543,9160361,10416344,10416352,10416361,10416801,10416807,10416808,10416810,10416814,10416818,10416873,10416874,6673172,6673173,10467812,10470217,10470218,10470219,10470220,10470221,10470222,10470223,10470224,10470225,10468225,10470226,10470227,10470228,10470229,10470230,10470231,10470232,10470233,10470234,10470235,10470236,10470237,10470238,10470239,10470240,10470241,10470242,10470243,10470244,10470245,10470246,10470247,10470248,10470249,10470250,10470251,10470252,10470253,10470254,10470255,10470256,10470257,10470258,10470259,10470260,10470261,10470262,10470263,10470264,10470265,10470266,10470267,10470268,10470269,10470270,10470271,10470272,10470273,10470274,10470275,10470276,10470277,10470278,10470279,10470280,10470281,10470282,10470283,10470284,10470285,10470286,10470287,10470288,10470289,10470290,10470291,10470292,10470293,10470294,10470295,10470296,10470297,10470298,10470299,10470300,10470301,10470302,10470303,10470304,10470305,10470306,10470307,10470308,10470309,10470310,10470311,10470312,10470313,10470314,976516,10470315,976517,10470316,10470317,10470318,10470319,10470320,10470321,10470322,10470323,10470324,10470325,10470326,10470327,10470328,10470329,10470330,10470331,10470332,10470333,10470334,10470335,10470336,10470337,10470338,10470339,10470340,10470341,10470342,10470343,10470344,10470345,10470346,10470347,10470348,10470349,10470350,10470351,10470352,10470353,10470354,10470355,10470356,10470357,10470358,10470359,10470360,10470361,10470362,10470363,10470364,10470365,10470366,10470367,10470368,10470369,10470370,10470371,10470372,10470373,10470374,10470375,10470376,10470377,10470378,10470379,10470380,10470381,10470382,10470383,10470384,10470385,10470386,10470387,10470388,10470389,10470390,10470391,10470392,10470393,10470394,10470395,10470396,10470397,10470398,10470399,10470400,10470401,10470402,10470403,10470404,10470405,10470406,10470407,10470408,10470409,10470410,10470411,10470412,10470413,10470414,10470415,10470416,10470417,10470418,10470419,10470420,10470421,10470422,10470423,10470424,10470425,10470426,10470427,10470428,10470429,10470430,10470431,10470432,10470433,10470434,10470435,10470436,10470437,10470438,10470439,10470440,10470441,10470442,10470443,10470444,10470445,10470446,10470447,10470448,10470449,10470450,6672079,10470451,10470452,10470453,10470454,10470455,10470456,10470457,10470458,10470459,10470460,10470461,10470462,10470463,10470464,10470465,10470466,10470467,10470468,10470469,10470470,10470471,10470472,10470473,10470474,10470475,10470476,10470477,10470478,10470479,10470480,10470481,10470482,10470483,10470484,10470485,10470486,10470487,10470488,10470489,10470490,10470491,10470492,10470493,10470494,10470495,10470496,10470497,10470498,10470499,10470500,10470501,10470502,10470503,10470504,10470505,10470506,10470507,10470508,10470509,10470510,10470511,10470512,10470513,10470514,10470515,10470516,10470517,10470518,10470519,10470520,10470521,10470522,10470523,10470524,10470525,10470526,10470527,10470528,10470529,10470530,10470531,10470532,10470533,10470534,10470535,10470536,10470537,10470538,10470539,10470540,10470541,10470542,10470543,10470544,10470545,10470546,10470547,10470548,10470549,10470550,10470551,10470552,10470553,10470554,10470555,10470556,10470557,10470558,10470559,10470560,10470561,10470562,10470563,10470564,10470565,10470566,10470567,10470568,10470569,10470570,10470571,10470572,10470573,10470574,10470575,10470576,10470577,10470578,10470579,10470580,10470581,10470582,10470583,10470584,10470585,10470586,10470587,10470588,10470589,10470590,10470591,10470592,10470593,10470594,10470595,10470596,10470597,10470598,10470599,10470600,10470601,10470602,10470603,10470604,10470605,10470606,10470607,10470608,10470609,10470610,10470611,10470612,10470613,10470614,10470615,10470616,10470617,10470618,10470619,10470620,10470621,10470622,10470623,9168089,10427672,10427673,10888856,10910055,10885398,10888004,10888007,10883435,10883436,10883439,10883440,10883441,10883442,10647389,10607653,10525330,10508300,10507625,10506786,10507948,10507949,10507950,10507951,10507952,10507953,10507954,10507955,10486320,10486321,10413819,10412297,10410693,10413162,10413165,10413167,10413170,10413174,10413177) 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'