Hi Renoirb, can you explain why someone would want to do this? Thanks. Leucosticte (talk) 04:38, 26 November 2013 (UTC)
The idea was to be able to delete pages from a parent with its children. I made all this documentation while trying to follow database relationships to achieve that goal. I did not complete the research on the idea when people told me it was not a good idea. You can revert my proposal. Just adjust the note saying to look at text,revision,pages that it goes even deeper and should not be done by raw database queries. This is what triggered me to try :)
- One could also use Special:PrefixIndex to get the list of pages and then Extension:DeleteBatch (or the maintenance script Manual:DeleteBatch.php) to delete them. There are probably other ways too.
- Sometimes it's good to post raw database queries if there isn't yet an extension or maintenance script that lets you perform a particular action; in that case, the query is better than nothing. A better option, for those who have the time, is to write a sample extension that uses wrapper functions to implement those queries, kinda like what was done at Manual:Page_props table#Example_of_a_simple_extension_that_uses_this_table. That gives people a better starting place for writing their own extensions. Leucosticte (talk) 18:17, 27 November 2013 (UTC)