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(7067860,7067861,7067914,7076103,4970860,8569735,8569736,8569737,8569738,8569739,7068795,7068796,7068797,7068798,7068799,10933290,7065903,10933357,10199177,7074009,7074363,10437331,10437541,10437542,10212963,8068065,8068066,7067170,7075319,7067672,7067813,7072092,10195438,7064336,7064337,7064338,7064474,7064475,7064476,10931941,10195948,10932250,10932303,10932322,10932604,10932621,7073183,7073190,10932662,10932740,7073645,7073646,4968037,4968038,4968039,4968040,4968041,4968042,4968043,4968044,4968045,4968046,4968047,10207054,10207055,10207056,10207057,10207058,10207059,10207060,10207061,10207062,10207063,10207064,10207065,10207066,10207067,10207068,10207069,10207070,10207071,10207072,10207073,10207074,10207075,10207076,10207077,10207078,10207079,10207080,10207081,10207082,10207083,10207084,10207085,10207086,10207087,10207088,10207089,10207090,10207091,10207092,10207093,10207094,10207095,10207096,10207097,10207098,10207099,10207100,10207101,10207102,10207103,10207104,10207105,10207106,10207107,10207108,10207109,10207110,10207111,10207112,10207113,10207114,10207115,10207116,10207117,10207118,10207119,10207120,10207121,10207122,10207123,10207124,10207125,10207126,10207127,10207128,10207129,10207130,10207131,10207132,10207133,10207134,10207135,10207136,10207137,10207138,10207139,10207140,10207141,10207142,10207143,10207144,10207145,10207146,10207147,10207148,10207149,10207150,10207151,10207152,10207153,10207154,10207155,10207156,10207157,10942635,10207158,10207159,10942636,10207160,10207161,10207162,10207163,10207164,10207165,10207166,10207167,10207168,10207169,10207170,10207171,10207172,10207173,10207174,10207175,10207176,10207177,10207178,10207179,10207180,10207181,10207182,10207183,10207184,10207185,10207186,10207187,10207188,10207189,10207190,10207191,10207192,10207193,10207194,10207195,10207196,10207197,10207198,10207199,10207200,10207201,10207202,10207203,10207204,10207205,10207206,10207207,10207208,10207209,10207210,10207211,10207212,10207213,10207214,10207215,10207216,10207217,10207218,10207219,10207220,10207221,10207222,10207223,10207224,10207225,10207226,10207227,10207228,10207229,10207230,10207231,10207232,10207233,10207234,10207235,10207236,10207237,10207238,10207239,10207240,10207241,10207242,10207243,10207244,10207245,10207246,10207247,10207248,10207249,10207250,10207251,10207252,10207253,10207254,10207255,10207256,10207257,10207258,10207259,10207260,10207261,10207262,10207263,10207264,10207265,10207266,10207267,10207268,10207269,10207270,10207271,10207272,10207273,10207274,10207275,10207276,10207277,10207278,10207279,10207280,10207281,10207282,10207283,10207284,10207285,10207286,10207287,10207288,10207289,10207290,10207291,10207292,10207293,10207294,10207295,10207296,10207297,10207298,10207299,10207300,10207301,10207302,10207303,10207304,10207305,10207306,8861257,8861375,8861378,7071576,10944450,10944451,10940728,10940729,10940730,10940731,10940732,10940733,10940734,10940735,10940736,10940737,10940738,10940739,10940740,10940741,10940742,10944744,7069257,7069258,7069259,7069260,7069261,7069262,7069263,7069264,7069265,7069266,7069267,10940989,8072678,8072679,8072680,8072681,8072682,10941751,10941752,10941753,10941754,10941755,10941756,10941757,10941758,10941759,10941760,10942137,8860331,8860332,8073438,8073441,8073442,8073444,7070758,8860679,8860680,8860681,10623303,10623319,10623413,10623490,10623504,10618835,10618836,10618837,10618838,10618839,10191058,10619031,10619032,8070855,8070856,8070857,8070858,10619342,8071120,8071121,8071122,8071123,10621986,10622012,10622013,10622014,10622015,10622016,10622017,10622018,10622019,10622020,10622021,10622022,10622023,10622024,10622025,10622026,10622027,10622028,10622029,10622030,10622031,10622032,10622033,10622034,10622035,10622036,10622037,10622038,10622039,10622040,10622041,10622042,10622043,10622044,10622045,10622046,10622047,10622048,10622049,10622050,10622051,10622052,10622055,10622056,10622057,10622058,10622059,10622060,10622061,10622062,10622063,10622064,10622065,10622066,10622067,10622068,10622069,10622070,10622071,10622072,10622073,10622074,10622075,10622076,10622077,10622078,10622079,10622080,10622081,10622082,10622083,10622084,10622085,10622086,10622087,10622088,10622089,10622090,10622091,10622092,10617169,10617170,10189305,10189306,10189307,10189308,10189309,10189310,10622369,10622370,10617523,10928110,10189942,10189943,10189944,10189945,10189946,10189947,10189948,10189949,10189950,10189951,10189952,10189953,10189954,10189955,10189956,10189957,10189958,10189959,10189960,10189961,10189962,10189963,10189964,10189965,10189966,10189967,10189968,10189969,10615036,10920684,10920685,10920686,8570016,10620297,10620298,10620299,10620300,10620301,10620302,10620303,10620304,10620305,10620306,10620307,10620308,10925848,10925849,10925850,10925851,10925852,10925864,10925865,10925866,10925867,10925868,10615465,10930725,10615925,10930777,10616015,10616026,10930890,10930912,10621275,10621276,10621277,10621278,10621279,10621280,10621281,10621282,10621283,10926843,10926844,10926845,10926846,10926847,10921851,10921852,10188495,10188496,10927245,10565159,10614346,10614348,10614349,10565648,8864377,8864554,10612414,10557633,10557634,10557635,10557636,10557637,10557638,10612502,10612503,10612650,10612840,10612860,8862791,10612961,8862984,10558321,10558373,8863102,8863103,8863104,8863105,8863106,8863107,8863108,8863109,8863110,8863111,8863112,8863113,8863114,8863115,8863116,8863117,8863118,8863119,8863120,8863121,8863122,8863123,8863124,8863125,8863126,8863127,8863128,8863129,8863130,8863131,8863132,8863133,8863134,8863135,8863136,8863137,8863138,8863139,8863140,8863141,8863142,8863143,8863144,8863145,8863146,8863147,8863148,8863149,8863150,8863151,8863152,8863153,8863154,8863155,8863156,8863157,8863158,8863159,8863160,8863161,8863162,8863163,8863164,8863165,8863166,8863167,8863168,8863169,8863170,8863171,10564632,10564633,8863706,8863707,8863708,8863709,8863710,8863711,8863712,8863713,8863714,4974446,4974447,4975249,4975294,2809331,2809332,10518640,10518994,10518995,10519099,10519100,10519101,10519102,10519103,10519104,10519105,10519106,10519107,10519108,10519109,10519110,10519111,4973239,10419471,4973428,10416498,4973652,10417188,4971159,4971160,4971466,4971467,4971468,4971469,4971470,4971471,4971472,4971473,4971474,4971475,4971476,4971477,4971478,4971479,4971480,4971481,4971482,4971483,4971484,4971485,4971486,4971487,4971488,4971489,4971490,4971491,4971492,4971493,4971494,4971495,4971496,4971497,4971498,4971499,4971500,4971501,4971502,4971503,4971504,4971505,4971506,4971507,4971508,4971509,4971510,4971511,4971512,4971513,4971514,4971515,4971516,4971517,4971518,4971519,4971520,4971521,4971522,4971523,4971524,4971525,4971526,4971527,4971528,4971529,4971530,4971531,4971532,4971533,4971534,4971535,4971536,4971537,4971538,4971539,4971540,4971541,4971542,4971543,4971544,4971545,4971546,4971547,4971548,4971549,4971550,4971551,4971552,4971553,4971554,4971555,4971556,4971557,4971558,4971559,4971560,4971561,4971562,4971563,4971564,4971565,4971566,4971567,4971568,4971569,4971570,4971571,4971572,4971573,4971574,4971575,4971576,4971577,4971578,4971579,4971580,4971581,4971582,4971583,4971584,4971585,4971586,4971587,4971588,4971589,4971590,4971591,4971592,4971593,4971594,4971595,4971596,4971597,4971598,4971599,4971600,4971601,4971602,4971603,4971604,4971605,4971606,4971607,4971608,4971609,4971610,4971611,4971612,4971613,4971614,4971615,4971616,4971617,4971618,4971619,4971620,4971621,4971622,4971623,4971624,4971625,4971626,4971627,4971628,4971629,4971630,4971631,4971632,4971633,4971634,4971635,4971636,4971637,4971638,4971639,4971640,4971641,4971642,4971838,10469733,10469734,10469735,10469810,10469811,10469812,4972448,4972449,4972450,4972451,4972452,4972453,4972454,4972455,4972456,10628857,10628858,10628859,10628860,10628861,10626231,10626232,10626233,10626234,10626235,10626236,10626237,10566371,10566481,10566482,10566483,10566484,10566485,10566486,10566487,10566488,10566489,10566490,10566491,10566492,10566493,10566494,10566495,10566496,10566497,10566498,10566499,10566500,10566501,10566502,10566503,10566504,10566505,10566506,10566507,10566508,10566509,10566510,10566511,10566512,10566513,10566514,10566515,10566516,10566517,10566518,10566519,10566520,10566521,10566522,10566523,10566524,10566525,10566526,10566527,10566528,10566529,10566530,10566531,10566532,10566533,10567362,10567578,10519112,10519113,10519114,10519115,10519116,10421210,10421211,10421212,10421213,10421214,10421215,10421216,10421217,10421218,10472964,10472965,10472966,10472967,10473332,10473333,10473334,10473351,10473409,10473410,10473447,10473448,10473611,10473628,10473629,10472843) 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'