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(7075945,3228402,3228403,3228418,10930421,8838677,8838678,8838679,10448376,10870903,8569644,8569645,8621684,8621685,8621686,8621687,8621688,8621689,8621690,10933374,10933375,10963730,10963731,10847226,10847227,10847228,10847232,9216150,11042259,11042260,11042261,11042262,11042263,11042264,11042265,11042266,11042267,11042268,11042269,11042270,11042271,3230069,10868964,10868965,10868966,3230109,3230110,3230111,3230112,3230113,3230114,3230115,3230116,3230117,7066768,7066769,7066771,10437741,10437742,3227664,3227666,7075431,7075432,7075433,7075434,7075435,7075436,10860979,10962406,10962407,10962408,10962415,10962416,10962417,10962418,10962419,10962420,10962421,10962429,10962430,8838236,7067816,3238378,3238453,10103176,10103177,7072072,8617922,10103387,10103388,10103389,10103390,10103391,10103392,8594947,8911575,10858826,10858827,10858828,10858829,10858830,10858831,10858832,8075320,10866876,10866877,10866878,10866879,10866880,8911775,10932089,8559848,3899414,3899415,8559870,8628637,3899516,3899543,10867340,3899564,7073174,7073175,7073176,7073177,7073178,7073179,10843982,10843983,10843986,8596068,8596069,8560540,8560541,10844511,10844512,10844514,8910218,11049418,11049419,10998415,10998416,10998417,10998418,10998419,10998420,10998421,10998422,10998423,10998424,10998425,10998426,10998427,10998428,10998429,10998430,10998433,10998434,10998435,10998436,10998437,10998438,10998439,10998440,10998441,10998442,10858193,10858194,10858195,10858196,10858197,10858198,10839947,10839948,10839949,3235760,3235761,3235762,10944869,10944870,3926355,3926356,3926357,3926358,3926359,8616001,8616002,11048466,11048467,11048468,11048469,11048470,11048471,11048472,11048473,8557546,8565329,11048530,11048531,8557577,8557686,8557687,8557688,8557689,3237318,3237319,3237320,3237321,3237322,3237323,3237324,3237325,3237326,3237327,3237328,3237329,3237330,3237331,3237332,10618246,3923748,8554317,3923770,11007146,11007147,11007148,11007152,11007153,11007154,11007155,11007156,11007157,11007158,11007160,11007161,11007162,11007163,11007164,8554591,8554594,8554595,8554596,8554599,8906885,8906886,8906887,8906888,8906889,3234308,3234309,8555301,3235022,3235023,11047355,10855075,10855076,10855077,10839640,8611880,8611887,8611888,8611889,8611899,10617472,8553691,10853160,10951822,10616050,8610867,10926749,10926750,10926751,10926752,10926753,10926754,8611454,7059763,6666009,6666010,9214030,9214032,8864754,8542713,7057722,8542802,9172008,9172009,9172010,9172011,9172012,9172013,9172014,9172029,9172030,9172032,9172033,9172034,9172035,9172036,9172037,9172038,9172073,9172074,9172075,9172076,8862685,8862686,9172266,9172267,3653546,7018030,7018031,7018032,7018033,7018034,7018035,7018036,7018037,7018038,7018039,7018040,7018041,7018042,7018043,7018044,7018045,7018046,7018047,7018048,7018049,7018050,7018051,7018052,7018053,7018054,7018055,7018056,7018057,7018058,7018059,7018060,7018061,7018062,7018063,7018064,7018065,7018066,7018067,7018068,7018069,7018070,9169995,10513917,10513918,10513919,10513920,10513921,10513922,10513923,10513924,10513925,9162123,10513949,10513950,10513951,10513952,10513953,10513954,10513955,10513956,10513957,10513958,10513959,10513960,10513961,9170163,8918069,4973670,4973671,4973672,4973673,4973674,4973675,4973676,10419757,10419758,10419759,10419760,10419761,9208867,9208868,9208869,9208870,9208871,9208872,9208873,9208875,9182430,8865076,8569234,8549962,9166896,8916639,9191133,9191134,9191135,9191136,9191137,9191138,9191139,9191140,9191141,9191142,9191143,9191144,9191145,9191146,9191147,9191148,9191149,9191150,8916798,8916886,10123511,3963653,9167557,9167558,9167559,8917499,6474272,9175987,9175988,10883680,8069252,10890103,10890104,10890207,10877722,10907790,10907791,10907792,10907794,10907795,10907796,10161835,10891235,10891236,10891252,10891253,10891254,10891255,10891256,10891257,10891262,10949349,10881593,10187693,10631355,10631356,10631357,10631358,10631359,10631360,10631361,10631362,10631363,10631364,10631365,10173358,10648015,10648016,10591007,10591008,10591009,10654118,10654119,10654120,10654121,10654122,10651838,10651839,10585970,10585971,10601093,10542368,10542369,10542370,10542371,10542372,10542373,10542374,10542375,10542376,10542377,10542378,10542379,10542380,10542381,10542382,10542383,10542384,10542446,10542447,10542448,10542449,10542450,10542451,10542452,10542453,10542454,10542455,10542456,10542457,10542458,10542459,10542460,10542461,10542462,10542463,10542464,10542465,10542466,10542467,10542468,10542469,10542470,10542471,10542472,10542473,10542474,10542475,10542476,10542477,10542478,10542479,10542480,10542481,10542482,10542483,10542484,10542485,10542486,10542487,10542488,10542489,10542490,10542491,10542492,10542493,10542494,10542495,10542496,10542497,10542498,10542499,10542500,10542501,10542502,10542503,10542504,10542505,10542506,10542507,10542508,10542509,10542510,10542511,10542512,10542513,10542514,10542515,10542516,10542517,10542518,10542519,10542520,10542521,10542522,10542523,10542524,10542525,10542526,10542527,10542528,10542531,10542532,10542533,10542534,10542535,10542536,10542537,10542538,10542539,10542540,10542541,10542542,10542543,10542544,10542545,10542546,10542547,10542548,10542549,10542550,10542551,10542552,10542553,10542554,10542555,10542556,10542557,10542558,10542559,10421256,10421257,10421258,10422538,10507497,10508585,10508604,10508605,10409363,10412764,10412765,10412766,10412767,10412768,10415003) 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'