Toggle navigation
Home
New Query
Recent Queries
Discuss
Database tables
Database names
MediaWiki
Wikibase
Replicas browser and optimizer
Login
History
Fork
This query is marked as a draft
This query has been published
by
Mahir256
.
Toggle Highlighting
SQL
SELECT DISTINCT pl_title#, COUNT(*) FROM pagelinks LEFT JOIN page ON pl_title = page_title AND pl_namespace = page_namespace WHERE pl_from_namespace IN (0, 120, 146) AND pl_namespace IN (0, 120, 146) AND pl_title in ("Q119972923","Q119973701","Q36961503","Q36969603","Q36969914","Q36962216","Q36962432","Q36962587","Q36962705","Q36970523","Q36970621","Q36970793","Q36971087","Q36963135","Q36963555","Q36958396","Q36965102","Q36965325","Q36965950","Q36959093","Q36966851","Q36967214","Q36967471","Q36967475","Q36968040","Q36968049","Q36968349","Q36968400","Q36960883","Q36968547","Q36968611","Q36968755","Q36968918","Q36969073","Q36969097","Q36969222","Q33667354","Q33676106","Q33675499","Q33675240","Q33675228","Q33665196","Q33302876","Q33302717","Q33299692","Q33294478","Q33674612","Q33664220","Q33664010","Q33291663","Q33270276","Q33269619","Q33245654","Q33674245","Q33662604","Q33662355","Q33662337","Q33662316","Q33662209","Q33662181","Q33673574","Q33661581","Q33660314","Q33145565","Q33659720","Q33659612","Q33659607","Q33658773","Q33658766","Q33141149","Q33658698","Q33658690","Q33658688","Q33658676","Q33670549","Q33670299","Q33668296","Q66088515","Q66010768","Q42328669","Q51320629","Q33039076","Q33058258","Q33058259","Q33302373","Q33302775","Q33602648","Q33139018","Q39407150","Q33302975","Q33305244","Q33306218","Q33678138","Q33678250","Q33678355","Q33308951","Q33678963","Q33678984","Q44215133") AND pl_from NOT IN ( select page_id from page where page_title in ("Q119972923","Q119973701","Q36961503","Q36969603","Q36969914","Q36962216","Q36962432","Q36962587","Q36962705","Q36970523","Q36970621","Q36970793","Q36971087","Q36963135","Q36963555","Q36958396","Q36965102","Q36965325","Q36965950","Q36959093","Q36966851","Q36967214","Q36967471","Q36967475","Q36968040","Q36968049","Q36968349","Q36968400","Q36960883","Q36968547","Q36968611","Q36968755","Q36968918","Q36969073","Q36969097","Q36969222","Q33667354","Q33676106","Q33675499","Q33675240","Q33675228","Q33665196","Q33302876","Q33302717","Q33299692","Q33294478","Q33674612","Q33664220","Q33664010","Q33291663","Q33270276","Q33269619","Q33245654","Q33674245","Q33662604","Q33662355","Q33662337","Q33662316","Q33662209","Q33662181","Q33673574","Q33661581","Q33660314","Q33145565","Q33659720","Q33659612","Q33659607","Q33658773","Q33658766","Q33141149","Q33658698","Q33658690","Q33658688","Q33658676","Q33670549","Q33670299","Q33668296","Q66088515","Q66010768","Q42328669","Q51320629","Q33039076","Q33058258","Q33058259","Q33302373","Q33302775","Q33602648","Q33139018","Q39407150","Q33302975","Q33305244","Q33306218","Q33678138","Q33678250","Q33678355","Q33308951","Q33678963","Q33678984","Q44215133") ) #GROUP BY pl_title #ORDER BY COUNT(*) DESC, pl_namespace, pl_title;
By running queries you agree to the
Cloud Services Terms of Use
and you irrevocably agree to release your SQL under
CC0 License
.
Submit Query
Stop Query
All SQL code is licensed under
CC0 License
.
Checking query status...
