ويكيبيديا:مصادر موثوقة/معاجم وقواميس وأطالس/إحصائيات

SQL

#select * from page where page_id = 9107986;
#select iwl_title from iwlinks  where iwl_from = 9107986;
/*
select * from templatelinks
inner join linktarget on lt_id = tl_target_id
where lt_title in (
  "استشهاد_بويكي_بيانات"
)
and  tl_from = 9107986; 
*/
/*
select * from iwlinks where iwl_title in  (
	"Q112315598","Q108408025","Q116176016"
);
*/


#select page.page_id,page.page_namespace,page.page_title,iwlinks.iwl_title from page
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  (
	"Q112315598" ,"Q108408025","Q116176016"
) and lt_title in (
  "استشهاد_بويكي_بيانات",
  "Citeq",
  "Cite_Q"
)
and page.page_namespace = 0
GROUP BY q_iwl_title;

SQL

Checking query status...