error 1064 using music filter search?

[ooakllc]

Music filter search gives the following error code (which is beyond my level of understanding). Can someone explain this for me and maybe offer a remedy?

By the way, this seems to happen only when one does the following search sequence music genrea sidebox->choose genrea->filter results by->choose value->result is error code as follows:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' zen_product_music_extra pme on pme.music_genre_id = m.music_genre_id, zen_produ' at line 2
in:
[select p.products_id, p.products_type, p.master_categories_id, m.music_genre_id, p.products_price, p.products_tax_class_id, pd.products_description, IF(s.status = 1, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status = 1, s.specials_new_products_price, p.products_price) as final_price, p.products_sort_order, p.product_is_call, p.product_is_always_free_shipping, p.products_qty_box_status from zen_products_description pd, zen_products p left join zen_music_genre m, zen_product_music_extra pme on pme.music_genre_id = m.music_genre_id, zen_products_to_categories p2c left join zen_specials s on p2c.products_id = s.products_id where p.products_status = 1 and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1']

zen138,acornvitaminsdotcom
Thanks

[ooakllc]

I have spent all night trying to solve this problem and zen threads don't seem to have a remedy. I have disabled the search on the product pages. If someone would like to lead me in the right direction I'm all ears!
thanks

[chuck]

I think your SQL query is missing an "ON" clause in the left join syntax.

[ooakllc]

Thanks for the reply Chuck. My understanding of this is very limited and so I don't know what your reply is explaining. Could you "show" me how to remedy the left join syntax?
I appreciate your help.