Untitled query #16759

SQL

USE plwiki_p;
SELECT CONCAT(page_title) as page_title
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND ((el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=639:komunikat-spolki-phl&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=632:spolka-powolana&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=688:dzikie-karty-nowego-targu-krynicy&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=691:trzy-kluby-hl-licencje&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=605:prezes-zarzadzie-pkol&catid=7:template&Itemid=143&lang=pl%'))
GROUP BY page_title
ORDER BY page_title;
SELECT CONCAT('# ',el_to) as el_to#, COUNT(*) AS counting
FROM page
JOIN externallinks
ON page_id = el_from
WHERE page_namespace = 0
AND ((el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=639:komunikat-spolki-phl&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=632:spolka-powolana&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=688:dzikie-karty-nowego-targu-krynicy&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=691:trzy-kluby-hl-licencje&catid=7&Itemid=186&lang=pl%') OR 
(el_to LIKE 'http://www.pzhl.org.pl/index.php?option=com_content&view=article&id=605:prezes-zarzadzie-pkol&catid=7:template&Itemid=143&lang=pl%'))
GROUP BY el_to
ORDER BY /*counting DESC,*/ el_to;
SQL

Checking query status...
