• Good day ladies and gentlemen.
    After hours of research I found what I’ve been looking for all along. A query to delete tags that contain certain number of posts.
    The query was written by moderator Mark / t31os .
    Here it is bellow:

    DELETE a,c
    FROM
    	database.prefix_terms AS a
    	LEFT JOIN database.prefix_term_taxonomy AS c ON a.term_id = c.term_id
    	LEFT JOIN database.prefix_term_relationships AS b ON b.term_taxonomy_id = c.term_taxonomy_id
    WHERE (
    	c.taxonomy = 'post_tag' AND
    	c.count = 0
    	)

    What I am trying to do is set the range ,say for example from 1 to 230 c.count 1-230
    Problem is I don’t know if it’s possible and I can’t seem to find anything related to ranges in this meaning…
    Perhaps someone or maybe Mark could help?

    Thank you

Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘Yet another question about tags ,MySQL and deleting’ is closed to new replies.