You have an error in your SQL syntax near 'AND t.showTitlePageName = '10th_Thame_Country_Show'' 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 = '10th_Thame_Country_Show'