ofelix03 · November 4, 2022 13:08 · ofelix03 · Nov 4, 2022
diff --git a/readable-query-with-lateral.sql b/readable-query-with-lateral.sql
 select u.*, last_visited 
 from users u,
 lateral(
 select concat(date, ' ', time) "last_visited" from site_visits 
 where user_id = u.id
 order by id desc 
 limit 1
 ) last_visited
 where u.email = 'myuryichev2@guardian.co.uk'
	select u.*, last_visited
	from users u,
	lateral(
	select concat(date, ' ', time) "last_visited" from site_visits
	where user_id = u.id
	order by id desc
	limit 1
	) last_visited
	where u.email = 'myuryichev2@guardian.co.uk'
No results found