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