Here's the full query I'm trying to do:
explain select
users.status,
users.oid as oid,
users.type as type,
users.exclusive as exclusive,
userse.o_initials as exclusive_initials,
users.name_processed as name_processed,
users.o_company as o_company,
unix_timestamp(users.created) as created,
count(distinct notes.oid) as notes_num,
modifiers.o_initials as modified_by_initials,
duplicateusers.oid as duplicate,
duplicateusers.name_processed as duplicate_name,
duplicateusers.o_company as duplicate_company,
unix_timestamp(duplicateusers.created) as duplicate_created,
duplicateusers.modified as duplicate_modified,
count(distinct duplicatenotes.oid) as duplicate_num_notes
fROM users
left join users duplicateusers on (duplicateusers.created < users.created)
left join users userse on users.exclusive=userse.oid
left join notes on notes.parent=users.oid
left join users modifiers on users.modified_by=modifiers.oid
left join notes duplicatenotes on duplicatenotes.parent=duplicateusers.oid
where (users.status='O')
and (((1=1 and users.type='USER')))
and (soundex(users.o_last_name)=soundex(duplicateusers.o_last_name)
or (users.o_email_address=duplicateusers.o_email_address))
group by oid
---
Plus a supplementary question: whether I have 'limit 1' or 'limit 100' doesn't
seem to make any difference. I thought it must be my 'order by' clause, but
I got rid of that & no change.
- this is
Tom Cunningham.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
