SQL query: select duplicate posts – but using duplicate meta [duplicate]

look at http://www.mysqltutorial.org/mysql-find-duplicate-values/

to get meta values, you need to assign :

wp_postmeta.meta_key = 'syndication_permalink' AND wp_postmeta.meta_value="$yourvalue"

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)