SELECT CONCAT('[[',

              CASE log_namespace

                WHEN 1 THEN 'Talk:'

                WHEN 4 THEN 'WP:'

                WHEN 5 THEN 'WT:'

                WHEN 6 THEN ':File:'

                WHEN 14 THEN ':Category:'

                WHEN 10 THEN 'Template:'

                WHEN 118 THEN 'Draft:'

                ELSE CONCAT('{{ns:', log_namespace, '}}:')

              END,

              log_title,

              ']]') AS page,

    log_timestamp,

    comment_text

FROM logging_userindex

JOIN comment

    ON comment_id=log_comment_id

WHERE log_user_text='Cryptic'

    AND log_type='delete' AND log_action='delete'

    AND (comment_text LIKE '%[[WP:CSD#A%' OR comment_text LIKE '%[[WP:A%')

    AND comment_text NOT LIKE '%[[WP:CSD#G1%'

    AND log_namespace != 0

ORDER BY log_timestamp ASC;