have dupe id on smf_members but where i do
this script from sql file:
SELECT
u.user_id AS ID_MEMBER, SUBSTRING(u.user_name, 1, 80) AS memberName,
u.user_join AS dateRegistered, u.user_forums AS posts,
IF (u.user_admin = 1, 1, 0) AS ID_GROUP, u.user_lastvisit AS lastLogin,
SUBSTRING(u.user_name, 1, 255) AS realName,
SUBSTRING(u.user_password, 1, 64) AS passwd,
SUBSTRING(u.user_email, 1, 255) AS emailAddress, 0 AS gender,
ue.user_birthday AS birthdate,
SUBSTRING(REPLACE(ue.user_homepage, 'http://', ''), 1, 255) AS websiteTitle,
SUBSTRING(ue.user_homepage, 1, 255) AS websiteUrl,
SUBSTRING(ue.user_location, 1, 255) AS location,
SUBSTRING(ue.user_icq, 1, 255) AS ICQ,
SUBSTRING(ue.user_aim, 1, 16) AS AIM,
SUBSTRING(ue.user_msn, 1, 255) AS MSN, u.user_hideemail AS hideEmail,
SUBSTRING(u.user_signature, 1, 65534) AS signature,
IF(SUBSTRING(u.user_timezone, 1, 1) = '+', SUBSTRING(u.user_timezone, 2), u.user_timezone) AS timeOffset,
SUBSTRING(u.user_image, 1, 255) AS avatar,
SUBSTRING(u.user_customtitle, 1, 255) AS usertitle,
SUBSTRING(u.user_ip, 1, 255) AS memberIP,
SUBSTRING(u.user_ip, 1, 255) AS memberIP2, '' AS lngfile, '' AS buddy_list,
'' AS pm_ignore_list, '' AS messageLabels, '' AS personalText, '' AS YIM,
'' AS timeFormat, '' AS secretQuestion, '' AS secretAnswer,
'' AS validation_code, '' AS additionalGroups, '' AS smileySet,
'' AS passwordSalt, SUBSTRING(u.user_ip, 1, 255) AS memberIP2
FROM e107_user AS u
LEFT JOIN e107_user_extended AS ue ON (u.user_id = user_extended_id)
WHERE u.user_id > 0
order by u.user_id;
no dupes on result and all 1742 row retuturned.
