Infobox weather event adoption

SQL

SELECT
  COUNT(tl_target_id)
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"),
)
SQL

Checking query status...
