Untitled query #73924

SQL

select count(page.page_id) as "count_of_cites",iwlinks.iwl_title as "q_iwl_title" from page

inner join templatelinks on page.page_id = templatelinks.tl_from
inner join linktarget on lt_id = tl_target_id

inner join iwlinks on page.page_id = iwlinks.iwl_from
where iwlinks.iwl_title in  (select iwl_title from iwlinks  where iwl_from = 9120840) and lt_title in (
  "استشهاد_بويكي_بيانات",
  "Citeq",
  "Cite_Q"
)
and page.page_namespace = 0 and  lt_namespace = 10;
#GROUP BY q_iwl_title;


select page.page_title as "count_of_cites",iwlinks.iwl_title as "q_iwl_title" from page

inner join templatelinks on page.page_id = templatelinks.tl_from
inner join linktarget on lt_id = tl_target_id

inner join iwlinks on page.page_id = iwlinks.iwl_from
where iwlinks.iwl_title in  (select iwl_title from iwlinks  where iwl_from = 9120840) and lt_title in (
  "استشهاد_بويكي_بيانات",
  "Citeq",
  "Cite_Q"
)
and page.page_namespace = 0 and  lt_namespace = 10
and page.page_title like "نظام_تشغيل"
limit 10;
#GROUP BY q_iwl_title;


SELECT actor_name,
       (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id AND rev_timestamp) AS total_edits
FROM actor
where
#SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id AND rev_timestamp < 20221201000000) < 500
#ND (SELECT COUNT(*) FROM revision WHERE rev_actor = actor_id AND rev_timestamp <= 20230131235959) >= 500
#and
actor_name not in (select REPLACE(pl_title, '_', ' ') from pagelinks where  pl_from = 7519882)
and actor_name in (
	"لوقا"
)
SQL

Checking query status...
