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,10939946,10939947,10939948,10939949,10939950,10939951,10939952,10939953,10939954,10939955,10939956,10939957,10939958,10939959,10939960,10939961,10939962,10939963,10939964,10939965,10939966,10939967,10939968,10939969,10939970,10939971,10939972,10939973,10939974,10939975,10939976,10939977,10939978,10939979,10939980,10939981,10939982,10939983,10939984,10939985,10939986,10939987,10939988,10939989,10939990,10939991,10939992,10939993,10939994,10939995,10939996,10939997,10939998,10939999,10940000,10940001,10963093,4970860,8569735,8569736,8569737,8569738,8569739,7068795,7068796,7068797,7068798,7068799,10976487,10933290,7065903,10933357,7074009,7074363,10437331,8067486,10437541,10437542,10964354,10977433,10977434,10977435,10977436,10977437,10977438,10977439,10977440,10977441,10977442,10938725,10938726,10938727,10938728,8068065,8068066,7067170,7075319,7067672,7067813,10959534,7072092,7064336,7064337,7064338,10960054,7064474,7064475,7064476,10931941,10932250,10932303,10932322,8066138,8066139,10932604,10932621,7073183,7073190,10932662,10932740,7073645,7073646,4968037,4968038,4968039,4968040,4968041,4968042,4968043,4968044,4968045,4968046,4968047,10942635,10942636,8861257,8861375,8861378,7071576,10969500,10969501,10969502,10969503,10969504,10969505,10969506,10969507,10969508,10969509,10969510,10969511,10969512,10969513,10969514,10969515,10969516,10969517,10969518,10969519,10969520,10969521,10969522,10969523,10969524,10969525,10969526,10969527,10969528,10969529,10969530,10969531,10969532,10969533,10969534,10969535,10969536,10969537,10969538,10969539,10969540,10969541,10969542,10969543,3655549,10969544,10969545,10969546,10969547,10969548,10969549,10969550,10969551,10969552,10969553,10969554,10969555,10969556,10969557,10969558,10969559,10969560,10969561,10969562,10969563,10969564,10969565,10969566,10969567,10969568,10969569,10969570,10969571,10969572,10969573,10969574,10969575,10969576,10969577,10969578,10969579,10969580,10969581,10969582,10969583,10969584,10969585,10969586,10969587,10969588,10969589,10969590,10969591,10969592,10969593,10969594,10969595,10969596,10969597,10969598,10969599,10969600,10969601,10969602,10969603,10944450,10944451,10940728,10940729,10940730,10940731,10940732,10940733,10940734,10940735,10940736,10940737,10940738,10940739,10940740,10940741,10940742,3655910,3655911,3655912,3655913,3655914,3655915,3655916,3655917,3655918,3655921,3655922,3655923,10944744,3655924,3655925,3655926,7069257,7069258,7069259,7069260,7069261,7069262,7069263,7069264,7069265,7069266,7069267,10940989,8072678,8072679,8072680,8072681,8072682,3656591,3656592,3656593,3656594,3656595,3656596,10941751,10941752,10941753,10941754,10941755,10941756,10941757,10941758,10941759,10941760,10942137,8860331,8860332,8073438,8073441,8073442,8073444,7070758,8860679,8860680,8860681,10918581,10918582,10623303,10623319,10918845,10623413,10623490,10623504,10955120,10919251,10618835,10618836,10618837,10618838,10618839,10619031,10619032,8070855,8070856,8070857,8070858,10919843,10619342,8071120,8071121,8071122,8071123,10920097,10920098,10953507,10953508,10953509,10953510,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,10917876,10917877,10917878,10622369,10917879,10622370,10954035,10954036,10954037,10954038,10954039,10954040,10954041,10954042,10954043,10954044,10954045,10954046,10954047,10954048,10954049,10954050,10954051,10954052,10954053,10954054,10954055,10954056,10954057,10954058,10954059,10954060,10954061,10617523,10954062,10954063,10954064,10954065,10928110,10615036,10915670,10915671,10915672,10915673,10915674,10915675,10915676,10915677,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,10952816,10621278,10621279,10952817,10621280,10621281,10621282,10621283,10926843,10926844,10926845,10926846,10926847,10921851,10921852,10927245,10565159,10614346,10614348,10614349,10611358,10611475,10565648,8864377,8864554,10609332,10612414,10557633,10557634,10557635,10557636,10557637,10557638,10612502,10612503,10612650,10612840,10612860,8862791,10612961,8862984,10610167,10610168,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,10610671,10610773,8863706,8863707,8863708,8863709,8863710,8863711,8863712,8863713,8863714,10610952,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,10415869,10415870,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,10463696,10463697,10463698,10463699,10463700,10463701,10463702,10463703,10463704,10463705,10463706,10463707,10463708,10463709,10463710,10463711,10463712,10463713,10463714,10463715,10463716,10463717,10469733,10469734,10469735,10469810,10469811,10469812,8563460,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'