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(7075872,7076289,7076309,7068347,7068353,7068355,4970700,7068366,10940171,11002174,10963250,10963251,10963252,10976347,7068707,7068708,7068709,7068710,10963400,10963401,10940466,11002440,10963466,10963482,10963483,10963484,11002577,8066976,11041606,11002736,7066260,11042206,11042207,11042208,11042209,11042210,11042211,11042212,11042213,11003280,11029288,11003331,7074738,7066783,11029496,7066826,7074881,7074953,7074967,11039661,11039662,11039663,11039664,8067968,8067969,8067970,8067971,8067972,8067973,8067974,8067975,8067976,8067977,11026728,11026729,11026730,11026731,11026732,11026733,7067237,7075277,7075289,7075290,11027047,11027048,11027049,11027050,11040079,11001080,11040080,11040081,11040082,11040083,11040084,11001085,11040085,11040086,11040087,11040088,11040089,11040090,11040091,11040092,11040093,11040094,11040095,11040096,11040097,11040099,11040100,11040101,11040102,11040103,11040148,11040149,11040189,11040190,11040198,11014198,8068509,8068510,8068511,8068512,8068513,8068514,8068515,8068516,8068517,8068518,8068519,8068520,8068521,8068522,8068523,10939415,7075726,7075727,7075728,10962449,7075765,6000140,10959554,10959555,11037593,11037594,11037595,11037596,11037597,11037598,11037599,11037617,11037618,11037685,11012183,10932191,8066011,8066233,8066234,8066235,8066236,8066237,8066238,8066239,8066240,8066241,11000108,8066507,7073742,11010515,11010516,11010546,11010639,11010640,7071097,7071098,10984942,10984943,10984944,10984945,10984946,10984947,10984948,10984949,10984950,10984951,10984952,10984953,10984994,10984995,10984996,10984997,11024018,11024019,11024020,10985050,10985051,10985052,10985053,10943109,10943147,10943148,10943149,10943180,8861400,10943229,10943230,11024443,11024444,11024445,11024446,11024447,11024448,11024449,11024450,11024451,11024452,11024453,11024454,7069416,7069422,11022467,3656661,3656835,3656836,3656837,3656838,3656839,3656840,3656841,3656842,10942031,10942032,10997046,10997047,11023074,10997188,10958290,10958351,10967816,10967871,10967872,10967873,10994338,10994339,10618830,10618831,10618973,10618974,10618975,10994558,10619063,10619064,10619065,10619066,10619067,10619068,10619090,10619091,10619092,10619093,10619094,10619095,11020642,11020643,10619124,10619354,10619355,11007924,11007925,11007926,10982072,10982073,10982074,10982075,10982076,10982077,10982078,10995204,11021424,10619959,11005504,10927479,10927481,10927482,10927483,10927484,10927485,10927486,10927487,10927488,10927489,10927490,10966576,10966577,10966578,10966579,10966580,10966581,10966582,10966583,10966584,10966585,10966586,11005683,10922688,11005741,11005742,10966795,10966796,10966803,10966819,10622427,10622429,10622430,10923114,10923117,10923118,10923119,10923121,10923122,10923124,10923145,10923149,10923152,10923154,10923157,10923158,10923162,10923163,10923166,10923167,10923168,10923170,10923172,10923173,10923177,10923178,10923179,10923180,10923181,10923194,10923195,10923197,10923202,10923203,11006418,11006432,11006433,11006434,11006435,10923415,10923416,10923418,10923421,10923427,10923435,10923436,10923437,10923438,10923439,10619999,10620000,10620001,10615019,10620029,10964580,10620106,10615202,10615520,11004170,11004171,10926184,10926185,10926236,10615860,10615870,11004521,10616044,10616045,10965603,10965604,10965605,10965606,10965607,10965608,10965609,10965610,10965611,10965612,10965613,10965614,10965615,10965616,10965617,10965618,10965619,10965620,10965621,10965622,10965623,10965624,10965625,10965626,10965627,10965628,10965629,10965630,10965631,10965632,10965633,10965634,10965635,10965636,10965637,10965638,10965639,10965640,10965641,10965642,10965643,10965644,11004661,11004662,10926705,10926706,10926707,10926708,10621247,10621248,10621249,10621250,10621251,10978854,10978855,10978856,10978857,10978901,10621381,10621382,10621383,10621384,10621385,10616464,10616485,10979027,10616490,10616494,10616495,10966081,10966082,10966083,10966084,10966085,10966086,10966087,10966088,10966089,10966090,10966091,10966092,10966093,10966094,10966095,10966096,10966097,10966098,10966099,10966100,10966101,10966102,10966103,10966104,10966105,10966106,10966107,11005140,10922117,10922118,10922119,11005188,10966227,10966228,10966229,10966230,10927437,10927438,10927439,10927440,10927441,10927442,10927443,10927444,10927445,10927446,10927447,10927448,9189341,10611140,10611363,10611399,10614447,6665783,10614449,9173857,10565700,9173907,9173908,8864442,9173980,9173989,9174009,9174010,9174011,9174012,10611702,10611707,10565859,10565860,10565861,10565862,10565863,10565864,10565865,10565866,10565867,10565868,10565869,10565870,10565871,10565872,10565873,10565874,10565877,10611800,10611802,10566006,10566013,10566064,10566065,10566073,10566074,10566075,7057607,10612203,10557611,10557612,10557613,10612500,10612542,10609559,7058177,10609769,10609770,10609824,10609841,10609843,9172239,10612987,10612988,10612989,10609992,10609993,10610012,9172435,10613101,10610295,7058848,7058854,7058858,7058933,8863314,8863315,8863316,10610466,10610469,7059075,7059089,7059097,7059098,7059100,7059101,7059102,7059111,8863528,8863529,8863530,8863531,9177311,10513140,10513141,10517256,10517257,10517258,10517309,10517310,10517325,10513386,10511471,10511496,10511511,9169698,10511512,10511513,10511514,10511515,10511516,10511517,10515517,10511518,10515518,10515519,10511578,10511579,10511580,10511598,10511599,10511600,10511601,10511602,10511603,9177795,7055963,9169870,9169871,10511704,10511705,10511706,10511707,10511708,7056078,7056079,7056085,7056086,10511766,10511767,7056127,7056142,7056143,7056144,7056163,10511851,10511852,10511853,10511854,10511855,10511856,10511857,10511858,10511859,10511860,10511861,10511862,10511863,10511864,10511865,10511893,9162150,9186201,10512056,9170290,9170300,4975159,4975160,4975161,4975162,4975163,4975164,4975165,4975166,4975167,4975168,4975169,10514129,4975170,10514130,4975171,9170326,9170338,10514156,10514172,10514173,9170383,9170384,9170400,9170420,10514241,10514354,10514355,10514507,10514511,10516512,9170699,10514512,10514513,10514532,10514647,9178909,9178910,9178911,9178912,10512747,10512748,10512756,10514767,10514768,10514816,10514817,10514818,10514826,10514837,10514838,9171078,9171080,10516906,10514979,10514990,10514991,10514992,10514993,10514994,10514995,9171195,10515082,10418259,9160351,10418333,9160470,9160471,7054876,10418819,10420039,10420171,10420172,10417184,9169264,8864923,8864924,8864925,8864926,8864927,8864928,4971344,4971355,4971356,8865034,8865035,8865036,8865037,8865067,10471128,8865130,8865131,8865132,8865147,8865148,8865149,8865150,8865151,8865162,8916386,8916387,4972038,4972039,4972040,6667205,9175225,9167300,9175313,9175314,9175315,9175316,9175317,9175318,9175376,9175377,9175378,9175379,9175380,8917028,9175396,9175397,9175474,9175475,9175476,9175523,9175594,9175611,9167672,6667791,10462395,9175899,9175979,9168119,6668123,9168169,9176234,9168282,10159848,10159849,10159850,10159851,10171140,10171141,10163798,10163799,10163839,10163840,10163841,10163842,10163843,10163844,10163859,10163889,10163890,10163891,10163925,10163973,10627631,10627712,10627724,10627731,10174357,10174358,10174359,10161773,10630314,10162266,10162267,10630848,10631014,10631015,10631016,10631017,10626267,10631325,10631326,10631327,10626440,10626441,10631669,10631670,10631671,10631672,10631707,10631708,10626723,10168286,10168287,10168288,10168289,10168290,10168291,10626831,10583836,10583837,10583838,10583839,10583840,10583841,10583879,10583880,10583881,10583999,10584000,10584001,10584002,10584003,10584004,10584005,10584006,10584007,10584008,10584009,10584010,10584011,10584012,10584013,10584014,10584015,10584016,10584017,10584018,10584019,10582552,10525160,10525161,10525162,10525163,10525164,10525165,10525181,10525197,10525206,10525208,10523218,10523235,10525248,10525249,10525250,10525251,10525252,10525284,10527833,10527834,10527835,10527836,10522016,10522017,10528118,10522118,10528119,10528120,10528121,10528122,10528123,10528124,10528125,10528126,10528127,10528128,10528129,10528130,10528131,10528132,10528133,10522211,10522212,10522229,10522235,10522236,10522258,10522259,10522260,10522318,10522319,10522320,10522321,10522322,10522323,10522441,10522442,10522443,10522444,10522445,10522446,10522447,10522448,10522449,10522450,10522452,10522453,10522454,10522456,10522526,10522657,10520835,10524856,10524858,10524859,10524860,10420296,10424345,10420365,10420400,10420583,10498510,10424657,10422676,10424044,10425085,10425086,10425087,10421087,10421088,10423103,10480944,10480945,10480946,10481000,10479135,10479136,10479198,10479199,10479200,10479965,10479966,10479977,10482003,10482085,10482094,10482095,10482098,10482100,10482101,10482102,10482103,10482104,10482105,10482121,10482122,10476165,10476166,10476167,10476218,10476259,10476260,10476292,10476293,10472533,10478683) 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'