Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+1 vote
1.3k views
in Q2A Core by
Hello,

I had used this mysql query to show the duplicated question  :

 

SELECT title, COUNT(*) c FROM posts  GROUP BY title HAVING c > 1;

 

the CMD returns 1K of deplicated question at least count 2  for each question

 

I need to hide/remove all those question programmatically using a question2answer script

 

to get the best SEO results

 

Regards.
Q2A version: latest

2 Answers

0 votes
by
by
Actually, I need to run this  automatically
by
So, just modify the plugin to have it run through your list of posts.  Sorry, I don't provide custom support like this (as per your pm).
by
I don't get it, if q2a-post-merge can solve the problem how can I use it !!
for example I have 4K question :
 I mean 2K is unique and 1K is duplicated

so how can I fix this issue with this plugin ! I can see just 2 TEXT BOXES  :
"from" and "to"

in my case should I put from:1 , to:4000 and the plugin will find and remove automatically all 1K  of duplicated posts !!??
by
No, but you could modify the php code directly to loop through your list.
by
can you write me a code to delete or hide all duplicated posts to run as script "php script.php"
I am not a programmer so I can't do this by myself
thanks.
0 votes
by
I need to hide automatically if any post (question) had count > 1 (that's mean the post is duplicated)

so I need kinda script and execute it like this "#php HideDuplicated.php" from the Terminal

I think the script will do a select like this : SELECT title, COUNT(*) c FROM posts  GROUP BY title HAVING c > 1;

and hide/remove the duplicated posts automatically using a q2a hide function.
...