Manual:PageSelectQueryBuilder.php

MediaWiki file: PageSelectQueryBuilder.php
Location:	includes/page/ (includes/Page/ in 1.46 or later)
Source code:	master • 1.46.0 • 1.45.4 • 1.43.9
Classes:	MediaWiki\Page\PageSelectQueryBuilder

Class for building queries on wiki pages and fetching their results. Extends SelectQueryBuilder. Available since MW 1.36.

Public methods

WHERE:

• wherePageIds() - find pages by provided page ids.
• whereNamespace()
• whereTitlePrefix()
• whereTitles()

ORDER BY:

• orderByTitle() - order by page_namespace, then page_title in ascending or descending order.
• There is no dedicated method for ordering by display title (part of page_props), or observe the collation algorithm.
• orderByPageId()

Run and fetch:

• fetchPageRecord()
• fetchPageRecords()
• fetchPageRecordArray()
• fetchPageIds()