267

Lyn Horton's Top Releases of 2010

Lyn Horton By

Sign in to view read count

Tags

comments powered by Disqus

Shop for Music

Start your music shopping from All About Jazz and you'll support us in the process. Learn how.

Album Reviews
Read more articles
After Carnival

After Carnival

CDM Records
2012

buy
Live at Vision Festival

Live at Vision...

Re: Konstrukt
2012

buy
So Oder So

So Oder So

Self Produced
2012

buy
To My Surprise

To My Surprise

Consolidated Artists Productions
2012

buy
Leap In The Dark

Leap In The Dark

Intuition
2012

buy
Into The Open

Into The Open

Your Favourite Jazz
2012

buy
Unable to find events.

SELECT e.id, e.person_add, e.on_behalf_of, e.event_type, e.musician_id, e.entity, e.festival, e.house_concert, e.city as ecity, e.state as estate, e.country as ecountry, e.location, e.dt, e.title, e.country_subd, e.state_subd, e.city_subd, e.advertised, e.start, e.price, e.currency, entity.name AS entity_name, entity.city, entity.state, entity.country, entity.country_subd AS entity_country_subd, entity.state_subd AS entity_state_subd, entity.city_subd AS entity_city_subd, country.abbrev AS country_name, currency.name AS currencyname, entity.ticket_url AS ticket_url, musician.thumb_img AS thumb_img, entity.maintained_by vmaint, f.maintained_by fmaint, hcp.maintained_by hcpmaint FROM musician_event me LEFT JOIN event e ON e.id = me.event LEFT JOIN musician ON e.musician_id = musician.id LEFT JOIN entity ON entity.id = e.entity LEFT JOIN entity f ON f.id=e.festival LEFT JOIN entity hcp ON hcp.id=e.house_concert LEFT JOIN country ON country.id = entity.country LEFT JOIN currency ON currency.id = e.currency WHERE e.active <> 0 AND e.is_planned=0 AND e.dt >= CURDATE() AND me.musician = ORDER BY e.dt LIMIT 7

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 'ORDER BY e.dt LIMIT 7' at line 1