Infobox weather event adoption

SQL

SELECT
  lt_title,
  COUNT(*)
FROM templatelinks
LEFT JOIN linktarget ON tl_target_id = lt_id
WHERE tl_target_id IN (
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_weather_event"),
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_tropical_cyclone"),
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_flood"),
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_storm"),
  (SELECT lt_id FROM linktarget WHERE lt_namespace = 10 AND lt_title = "Infobox_tropical_cyclone_current")
) AND tl_from_namespace = 0
GROUP BY lt_title
SQL

Checking query status...
