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;
SQL

Checking query status...
