Mathias Schindler wrote:
Wie sähe
SELECT cur_title FROM cur WHERE cur_text NOT LIKE "%[[Kategorie:%"
aus?
Extrem ineffizient.
Spezial:Lonelypages verwendet dieses SQL:
SELECT 'Lonelypages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value FROM $cur LEFT JOIN $links ON cur_id=l_to WHERE l_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0
Ich würde also vorschlagen:
SELECT 'Uncategorizedpages' as type, cur_namespace AS namespace, cur_title AS title, cur_title AS value FROM $cur LEFT JOIN $categorylinks ON cur_id=cl_to WHERE cl_to IS NULL AND cur_namespace=0 AND cur_is_redirect=0
Ich programmiere das dann gleich mal. Timwi