Finding duplicate title codes

23/08/11

Permalink 12:16:00 pm, by mholmes, 65 words, 170 views   English (CA)
Categories: Activity log; Mins. worked: 30

Finding duplicate title codes

There are 117. Here's how I found them, for future reference:

SELECT a.`ttl_title_id`, b.`ttl_title_id`, a.`ttl_title_code`
FROM `titles` a, `titles` b
WHERE a.`ttl_title_code` = b.`ttl_title_code`
AND a.`ttl_title_id` <> b.`ttl_title_id`
AND a.`ttl_title_id` < b.`ttl_title_id`
ORDER BY a.`ttl_title_id`
LIMIT 0, 1000

Pingbacks:

No Pingbacks for this post yet...

Properties

A database project to collect historical data on properties and titles.

Reports

Categories

July 2014
Sun Mon Tue Wed Thu Fri Sat
 << <   > >>
    1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30 31    

XML Feeds