najaru 971 Posted January 2, 2011 Share Posted January 2, 2011 (edited) Questa query, da eseguire direttamente nel database, permette di ricercare chi ha postato il 100000esimo messaggioil codice si riferisce al caso in cui le tabelle hanno un prefisso come ibf_SELECT m.member_id, m.members_display_name, p.pid AS post_id, t.tid as topic_id, t.title AS topic_title, f.id AS forum_id, f.name AS forum_nameFROM ibf_posts pLEFT JOIN ibf_topics t ON (t.tid=p.topic_id)LEFT JOIN ibf_forums f ON (f.id=t.forum_id)LEFT JOIN ibf_members m ON (m.member_id=p.author_id)ORDER BY pid ASCLIMIT 99999,1 Edited December 23, 2012 by Skillman_92 Link to post Share on other sites
Admin
Moderators
Vip
Utenti Attivi
Utenti Inattivi
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now