Beiträge zu Commonscat Stolpersteine und Unterkategorien (2)

SQL

USE commonswiki_p;

SELECT /* SLOW_OK */ DISTINCT actor_name AS user, COUNT(image.img_name) as img_count 
    FROM actor, revision, image, page, categorylinks 
    WHERE page.page_id=categorylinks.cl_from
        AND actor.actor_id = revision.rev_actor
        AND image.img_name = page.page_title
        and revision.rev_page = page.page_id
        and revision.rev_parent_id = 0
        AND (categorylinks.cl_to in 
             (
"Stolperstein_für_Ernst_Selbiger_(Düsseldorf)"
,"Stolperstein_für_Willi_Schneider_(Düsseldorf)"
,"Stolperstein_für_Karl_Jung_(Düsseldorf)"
,"Stolperstein_für_David_Arom_(Düsseldorf)"
,"Stolperstein_für_Liebe_Arom_(Düsseldorf)"
,"Stolperstein_für_Antonie_Felsenthal_(Düsseldorf)"
,"Stolperstein_für_Erich_Felsenthal_(Düsseldorf)"
,"Stolperstein_für_Auguste_Gitta_Atlas_(Düsseldorf)"
,"Stolperstein_für_Szaje_Oswald_Atlas_(Düsseldorf)"
,"Stolperstein_für_Flora_Müller_(Düsseldorf)"
,"Stolperstein_für_Simon_
SQL

Checking query status...
