SELECT

    p.page_id,

    p.page_namespace,

    p.page_title,

    rev.rev_timestamp AS creation_date

FROM page AS p

JOIN revision AS rev ON p.page_id = rev.rev_page

JOIN actor ON rev.rev_actor = actor.actor_id

LEFT JOIN pagelinks AS pl ON p.page_id = pl.pl_from

LEFT JOIN templatelinks AS tl ON p.page_id = tl.tl_from  -- Added missing JOIN

WHERE

    actor.actor_name = 'Kasyap'  -- Corrected quotation

    AND rev.rev_parent_id = 0  -- Only the first revision (article creation)

    AND pl.pl_from IS NULL  -- No links pointing to the page

    AND p.page_namespace = 0  -- Only main namespace articles

    AND page_id not in (select pp_page from page_props where pp_propname="Orphan")

GROUP BY p.page_id, p.page_namespace, p.page_title, rev.rev_timestamp  -- Ensuring correct grouping

ORDER BY rev.rev_timestamp DESC;

​

​