You have an error in your SQL syntax near 'AND t.showTitlePageName = 'Burghley_Game__Country___Angling_Fair'' at line 1
SQL:- SELECT p.tradingName, p.shtDesc, p.longDesc, p.photo FROM demonstrators p, link_demos s, shows t WHERE t.showID = s.showID AND s.demoID = p.ID AND p.genID = AND t.showTitlePageName = 'Burghley_Game__Country___Angling_Fair'