100 random articles w/{{Infobox company}}

100 mainspace pages chosen sort-of-randomly from those transcluding {{Infobox company}}.  Returns a different sent each time it's rerun.

page_random is constant for a given page and not terribly uniform.  ORDER BY (page_random + @base) MOD 1 is sufficient for a single query, if you only care that it looks randomish; but when repeated, pages listed will always be in the same order, hence mangling it with SHA1().

{{Infobox company}} has roughly 85000 transclusions, which is few enough that the ORDER BY RAND() antipattern works reasonably well, but I just refuse.  (Yes, I'm aware mariadb can deal with it; I'm still scarred by bad experiences with sql server.)

For [[WP:VPM#Performing a random pages test on business articles]] circa 23 July 2024.

SQL

SET @base=RAND();
SELECT REPLACE(page_title, '_', ' ')
FROM page
JOIN templatelinks ON tl_from = page_id
JOIN linktarget ON lt_id = tl_target_id
WHERE lt_namespace = 10
  AND lt_title = 'Infobox_company'
  AND page_namespace = 0
ORDER BY SHA1(page_random + @base) LIMIT 100;

AخA
 
SET @base=RAND();SELECT REPLACE(page_title, '_', ' ')FROM pageJOIN templatelinks ON tl_from = page_idJOIN linktarget ON lt_id = tl_target_idWHERE lt_namespace = 10  AND lt_title = 'Infobox_company'  AND page_namespace = 0ORDER BY SHA1(page_random + @base) LIMIT 100;

SQL

Checking query status...