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(7201629,7201661,7201662,7201663,7201664,5654581,7202735,3927798,7201041,8627795,8627796,8627797,7201558,7201559,7201560,8625508,8625509,8625510,8625511,8625512,8625513,8625514,8625515,8625516,8625517,8625518,7200135,7200154,8614615,7198165,8905981,8905982,8905983,8905984,8905985,8905986,3923440,3923441,3923488,3923638,8633202,8633203,8633204,8633205,8633206,8633207,8633208,8633209,8633210,8633211,8633212,8633213,8633214,8633215,8633216,8633217,8633218,8633272,8633273,8633274,8633280,8633281,8633286,8633287,8633288,8633290,8633291,8633295,8633296,8634156,8634157,10427114,8632507,8632508,8632509,8632510,8632511,8632512,8632513,8632516,8632517,8632518,8632519,8632520,10615242,8630424,10615450,8630692,8630693,8630694,8630695,8630696,8630697,8630743,8630746,8630992,8631014,8631015,10616080,8583474,10614204,8853441,8853442,8853443,8853444,8853445,8853446,8853447,8853448,8853449,8853450,8853451,8853452,8853453,8853454,8853455,8853456,8853457,8853458,8853459,8853460,8853461,8853462,8853463,8853464,8853465,8853466,10714120,8853468,8853469,8853470,8853471,8853472,8853473,8853474,8853475,8853476,8853477,8853478,8853479,8853480,8853481,8853483,8853484,8853485,8853486,8853487,8853488,8853489,8853490,8853491,8853492,8853493,8853495,8853496,8853497,8853498,8853499,8853500,8853501,8853502,8853503,8853504,8853505,8853506,8853507,8853508,8853509,8853511,8853512,8853513,8853514,8853515,8853516,8853517,8853518,8853519,8853520,8853521,8853522,8853523,8853525,8853526,8853529,8853530,8853532,8853533,8853535,8853538,8853539,8853540,8853542,8853543,8853544,8853545,8853547,8853549,8853550,8853551,8853552,8853553,8853554,8853555,8853556,8853557,8853558,8853559,8853560,8853561,8853562,8853563,8853564,8853565,8853566,8853567,8853568,8853569,8853570,8853571,10612299,10612300,10612301,10612302,10612303,10612304,10612305,10612306,10612307,10612308,10612309,10612310,10612311,10612312,10612313,10612314,8566576,8566577,8566727,8566728,8566729,10613079,10613080,8852344,8852345,8852346,8852347,8852348,8852349,8852350,8852351,8852352,10613193,8567402,8567403,8567404,8567405,8567406,8567407,8567408,8567409,8567410,8567411,8567412,8567414,8567415,8567416,8567445,8567446,6673520,10117656,10117657,10117658,10117659,10117660,10117661,10117662,10117663,10117664,8849316,8849317,8849318,8849324,8849325,8849327,8849328,8849331,8849333,9169509,9169510,9169511,9169512,9177901,6674149,6674150,9161951,10118524,10118525,8850428,8850429,8850430,8850431,8850432,8850433,8850434,8850435,8850436,8850437,8850438,8850439,8850440,8850441,8850442,8850443,8850444,8850445,8850446,8850447,8850448,8850449,8850450,8850451,8850452,8850453,8850454,8850455,8850456,8850457,8850458,8850459,8850460,8850461,8850462,8850463,8850464,8850465,8850466,8850467,8850468,8850469,8850470,8850471,8850472,8850473,8850474,8850475,8850476,8850477,8850478,8850479,8850480,8850481,8850482,8850483,8850484,8850485,8850486,8850487,8850488,8850489,8850490,8850491,8850492,8850493,8850494,8850495,8850496,8850497,8850498,8850499,8850500,8850501,8848131,8848132,8848134,8848135,8848136,8848137,8848139,8848140,8848142,8848144,8848145,8848146,8848147,8848148,8848149,8848151,8848152,8848153,8848154,8848155,8848160,8848161,8848162,8848163,8848166,8848167,8848169,8848170,8848172,8848173,8848174,8848175,8848176,8848177,8848179,8848180,8848181,8848182,8848183,8848184,8848185,8848186,8848188,8848189,8848190,8848191,8848192,8848194,8848196,8848197,8848198,8848199,8848200,8848201,8848202,8848204,8848206,10417356,10417357,10417358,10417359,10417360,9168496,9168497,9168498,10419442,10416553,10416554,10416555,10416556,10416557,10416558,10416559,10416560,10416561,10416562,10416563,10416564,10416565,6672914,6672915,6672916,6672917,6672918,6672919,6672920,6672921,6672922,6672923,6672924,6672925,6672926,6672927,6672928,6672929,6672930,6672931,6672932,6672933,6672934,6672935,6672936,6672937,6672938,6672939,6672940,6672941,6672942,6672943,6672944,6672945,6672946,6672947,6672948,6672949,6672950,6672951,6672952,6672953,6672954,6672955,6672956,6672957,6672958,6672959,6672960,6672961,6672962,6672963,6672964,6672965,6672966,6672967,6672968,6672969,6672970,6672971,6672972,6672973,6672974,6672975,6672976,6672977,6672978,6672979,6672980,6672981,6672982,6672983,6672984,6672985,6672986,6672987,6672988,6672989,6672990,6672991,6672992,6672993,6672994,6672995,6672996,6672997,6672998,6672999,6673000,6673001,6673002,6673003,6673004,6673005,6673006,6673007,6673008,6673009,6673010,6673011,6673012,6673013,8848716,8848720,8848721,8848722,8848723,8848727,8848729,8848732,8848733,8848737,8848739,8848742,8848743,8848745,8848748,8848750,8848751,8848752,8848754,8848759,8848763,8848764,8848766,8848768,8848773,8848774,8848775,8848776,8848778,8848779,8848780,8848781,8848783,8848787,8848788,8848792,8848793,8848794,8848797,8848798,8848799,8848802,8848803,8848805,8848806,8848808,8848809,8848811,8848812,8848814,8848816,8848818,8848820,8848823,8848826,8848827,8848828,8848830,8848831,8848832,8848833,8848836,8848837,8848839,8848841,8848842,8848844,8848846,8848849,8848850,8848853,8848857,8848858,8848859,8848860,8848862,8848864,8848865,8848867,8848868,8848870,8848871,8848872,8848873,8848876,8848878,8848880,8848884,8848887,8848890,8848891,8848892,8848893,8848895,8848898,8848899,8848901,8848904,8848907,8848908,8848910,8848912,8848913,8848915,8848917,8848921,6673340,8550179,8847266,8847267,8847269,8847270,8847271,8847272,8847275,8847276,8847277,8847278,8847279,8847280,8847281,8847282,8847283,8847286,8847287,8847288,8847289,8847291,8847292,8847293,8847294,8847295,8847296,8847297,8847298,8847299,8847300,8847301,8847302,8847303,8847304,8847305,8847306,8847307,8847308,8847309,8847311,8847312,8847313,8847314,8847315,8847316,8847317,10470062,8847318,10470063,8847319,10470064,10470065,8847320,8847321,10470066,8847322,10470067,8847323,10470068,8847324,10470069,8847325,10470070,8847326,10470071,8847327,10470072,8847328,8847329,8847330,8847331,8847332,8847333,8847334,10468179,10468180,10468181,10468182,10468183,10468184,10468185,10468186,10468187,10468188,10468189,10468190,10468191,10468192,10468193,10468194,10468195,10468196,10468197,10468198,10468199,10468200,10468201,10468202,10468203,10468204,10468205,10468206,10468207,10468208,10468209,10468210,10468211,10468212,8847468,10468213,8847469,10468214,8847470,10468215,10468216,8847472,10468217,8847473,10468218,8847474,10468219,8847475,10468220,10468221,8847477,10468222,10468223,8847479,10468224,10468225,8847481,8847482,8847483,8847484,8847485,8847488,8847489,8847490,8847491,8847492,8847494,8847495,8847497,8847498,8847499,8847502,8847503,8847504,8847506,8847507,8847508,8847509,8847510,8847512,8847515,8847517,8847519,8847520,8847522,8847523,8847524,8847527,8847530,8847532,8847533,8847535,8847536,8847537,8847539,8847540,8847544,8847545,8847546,8847547,8847548,8847549,8847550,8847551,8847552,8847554,8847555,8847559,8847560,8847562,8847563,8847564,8847565,8847567,8847568,8847569,8847570,8847571,8847572,8847574,8847575,8847576,8847577,8847578,8847580,8847581,8847582,8847583,8847585,8847586,8847587,8847588,8847589,8847590,8847591,8847593,8847595,8847596,8847597,8847599,8847600,8847601,8847602,8847604,8847605,8847606,8847607,8847608,8847609,8847610,8847611,8847612,8847614,8847615,8847616,8847617,10468525,9168074,9168075,9168076,8847997,8847999,8848001,8848004,8848005,8848007,8848008,8848009,8848010,8848012,8848013,8848015,8848017,8848019,8848020,8848023,8848026,8848031,8848032,8848035,8848038,8848040,8848041,8848042,8848044,8848045,8848047,8848049,8848051,8848053,10888482,10888483,10888484,10888485,10888486,10888487,10888488,10888489,10888490,10888491,10888492,10888605,10883946,10883947,10883948,10883949,10883950,10883951,10883952,10883953,10883954,10883955,10883956,10883957,10889261,10889262,10884500,10884501,10899565,10155732,10885081,10885082,10885083,10885084,10885085,10885086,10885087,10885088,10885089,10885090,10885091,10885092,10885093,10885094,10885095,10885096,10885097,10885098,10877479,10887741,10627776,10888294,10888327,10161865,10161982,10882025,10882026,10647428,10647466,10647467,10647491,10588686,10546441,10546518,10546539,10546562,10546567,10507666,10507722,10507723,10508031,10410710,10406881,10406882,10406884,10406885,10406886,10406887,10406995) 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'