|
|
|
|
Joined: Jan 2003
Posts: 263
Member
|
|
Member
Joined: Jan 2003
Posts: 263 |
Hello, I need a query which will output a list of members that have posted only one message and haven't returned/logged in since then. Also I would like to see their loginname, email address and the date of their message. Anyone know how to do this ?  Thanks!
|
|
|
|
|
Joined: Aug 2000
Posts: 1,609
Addict
|
|
Addict
Joined: Aug 2000
Posts: 1,609 |
<br />SELECT U_LoginName, U_Email, U_LastPostTime<br />FROM w3t_Users<br />WHERE U_LastPostTime = U_Laston<br />AND U_Totalposts = '1'<br />
|
|
|
Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.
Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
|
|
|
Posts: 5,834
Joined: January 2000
|
|
|
Forums63
Topics37,575
Posts293,931
Members13,824
| |
Most Online6,139
Sep 21st, 2024
|
|
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
|
|
|
|
|
|
