We were delighted to host the University of Glasgow and Virginia University Women’s teams after their match at Old Anniesland. The two teams watched Scotland make hard work of a win against Italy in the comfort of the clubhouse with a pie and a pint.
Virginia University have been touring Scotland for ten days and return home having played some great rugby and made a few transatlantic friendships at the same time. Great to see!
We wish them well on their journey home and they are always welcome back!
SELECT * FROM (SELECT a.*, l.image as team2_logo
FROM (
SELECT r.id as fixture_id, r.competition_name, r.date, r.time, r.team1, r.team2, r.season, l.image as team1_logo
FROM wp_e1b349da27_fixtures r LEFT JOIN wp_e1b349da27_team_logo l on LOWER(r.team1) = LOWER(l.name)
) as a LEFT JOIN wp_e1b349da27_team_logo l on LOWER(a.team2) = LOWER(l.name)
WHERE (LOWER(team1) like 'ghk %' or LOWER(team2) like 'ghk %') and competition_name not like '%(Women\'s)%' and competition_name like '%National League Division 2%' and season='2024-2025') tb, wp_e1b349da27_crawler_index ci WHERE tb.fixture_id >= ci.start_id and tb.fixture_id <= ci.end_id and table_name = "wp_e1b349da27_fixtures" and STR_TO_DATE(ci.crawl_date, "%Y-%m-%dT%T") in (SELECT MAX(STR_TO_DATE(crawl_date, "%Y-%m-%dT%T")) FROM wp_e1b349da27_crawler_index WHERE start_id > 0 AND end_id > 0) order by fixture_id asc limit 1