The Arcive of Official vBulletin Modifications Site.
It is not a VB3 engine, just a parsed copy!
Archives
Graphics
Styles
Mods
Articles
Forums
VBSupport
vb.org Archive
>
vBulletin 3 Discussion
>
vB3 Programming Discussions
SELECT DISTINCT problems
User Name
Remember Me?
Password
FAQ
Members List
Calendar
Search
Today's Posts
Mark Forums Read
Thread Tools
Display Modes
Prev
Next
#
4
03-08-2007, 04:26 AM
Mistah Roth
Join Date: Jul 2003
Location: Ottawa, Ontario
Posts: 70
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
MySQL version 4.1.18
If I run the following Query, here are my results (I increase the limit number to show)
SELECT distinct threadid FROM post WHERE userid = 1 ORDER BY postid DESC LIMIT 15
Gives me the following:
threadid
1355
140
1321
1338
140
1334
1333
1311
1332
1319
1311
1284
1312
1311
1308
Those are my actual last 15 posts. Now if I add distinct, this is what I get:
SELECT distinct threadid FROM post WHERE userid = 1 ORDER BY postid DESC LIMIT 15
threadid
1355
1321
1338
1334
1333
1332
1319
1284
1312
1311
1310
1309
1308
1300
1288
Notice all the lower threadid's are not included.
Any ideas?
Mistah Roth
View Public Profile
Visit Mistah Roth's homepage!
Find all posts by Mistah Roth
«
Previous Thread
|
Next Thread
»
Thread Tools
Show Printable Version
Email this Page
Display Modes
Switch to Linear Mode
Switch to Hybrid Mode
Threaded Mode
Posting Rules
You
may not
post new threads
You
may not
post replies
You
may not
post attachments
You
may not
edit your posts
BB code
is
On
Smilies
are
On
[IMG]
code is
On
HTML code is
Off
Forum Rules
Forum Jump
User Control Panel
Private Messages
Subscriptions
Who's Online
Search Forums
Forums Home
News and Announcements
News and Announcements
Mod of the Month
Official vB.com Announcements
vBulletin Pre-Sales Questions
vBulletin Styles and Graphics
vBulletin Styles
vBulletin 5.x Styles
vBulletin 3.8 Styles
vBulletin 3.8 Admin CP Styles
vBulletin 4.x Styles
vBulletin Graphic Sets
vBulletin Button Sets
vBulletin Smilie Sets
Miscellaneous Images
vBulletin Rank Sets
vBulletin Avatar Sets
vBulletin Status Icon Sets
vBulletin Article Depository
Read An Article
vBulletin 3 Articles
Programming Articles
General Articles
Management Articles
Graphics Articles
vBulletin Tips & Tricks
vBulletin 4 Articles
vBulletin 5 Connect Articles
Article Submissions
Submit New Article
vBulletin Modifications
vBulletin 5.x Modifications
vBulletin 5.x Products & Extensions
vBulletin 5.x Template Modifications
vBulletin 4.x Modifications
vBulletin 4.x Add-ons
vBulletin 4.x Template Modifications
vBulletin 3.8 Modifications
vBulletin 3.8 Add-ons
vBulletin 3.8 Template Modifications
Premium Modifications
vBulletin Open Source Products
Sphinx
Project Tools
ibProArcade
Archive
vB.org Archives
General
vB1 Hacks
Testing Zone
Board of the Month
Big Board Discussions
General Hosting/Server Discussions
Member Archives
vBulletin 2.x
vBulletin 2.x Full Releases
vBulletin 2.x Beta Releases
vBulletin 2.x Template Modifications
vBulletin 2.x Styles
vBulletin 2.x Admin CP Styles
vBulletin 3.0
vBulletin 3.0 Full Releases
vBulletin 3.0 Beta Releases
vBulletin 3.0 Template Modifications
vBulletin 3.0 Styles
vBulletin 3.0 Admin CP Styles
vBulletin 3.5
vBulletin 3.5 Add-ons
vBulletin 3.5 Template Modifications
vBulletin 3.5 Styles
vBulletin 3.5 Admin CP Styles
vBulletin 3.6
vBulletin 3.6 Template Modifications
vBulletin 3.6 Add-ons
vBulletin 3.6 Styles
vBulletin 3.6 Admin CP Styles
vBulletin 3.7
vBulletin 3.7 Add-ons
vBulletin 3.7 Template Modifications
vBulletin 3.7 Styles
vBulletin 3.7 Admin CP Styles
Premium Archives
uCash & uShop
vBadvanced CMPS
RPG Integration Hack
vBindex
vBgarage
Advanced Warning System (AWS)
vbArticles
vB Chat
vbBux / vbPlaza
ibProArcade Archive
vRewrite - SEOed URLs for vBulletin
Modification Graveyard
vBulletin 5 Connect Discussion
vB5 General Discussions
vB5 Programming Discussions
vB5 Design and Graphics Discussions
vBulletin 4 Discussion
vB4 General Discussions
vB4 Programming Discussions
vB4 Design and Graphics Discussions
vBulletin 3 Discussion
vB3 Programming Discussions
vB3 General Discussions
vB3 Design and Graphics Discussions
Community Discussions
Modification Requests/Questions (Unpaid)
Style and Graphics Requests (Unpaid)
Forum and Server Management
Community Central
vBulletin.org Site Feedback
Community Lounge
Community Reviews
All times are GMT. The time now is
07:25 AM
.
-- Default Style
---- Blue
------ Red
------ Green
------ Purple
Contact Us
-
Archive
-
Top
Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X
vBulletin 3.8.12 by vBS Debug Information
Page Generation
0.07458 seconds
Memory Usage
2,717KB
Queries Executed
12
(?)
More Information
Template Usage:
(1)
SHOWTHREAD
(1)
ad_footer_end
(1)
ad_footer_start
(1)
ad_header_end
(1)
ad_header_logo
(1)
ad_navbar_below
(1)
ad_showthread_beforeqr
(3)
bbcode_code
(5)
bbcode_quote
(1)
footer
(1)
forumjump
(1)
forumrules
(1)
gobutton
(1)
header
(1)
headinclude
(1)
navbar
(3)
navbar_link
(120)
option
(17)
post_thanks_box
(17)
post_thanks_button
(1)
post_thanks_javascript
(1)
post_thanks_navbar_search
(17)
post_thanks_postbit_info
(17)
postbit
(17)
postbit_onlinestatus
(17)
postbit_wrapper
(1)
showthread_list
(1)
spacer_close
(1)
spacer_open
(1)
tagbit_wrapper
Phrase Groups Available:
global
inlinemod
postbit
posting
reputationlevel
showthread
Included Files:
./
showthread.php
./
global.php
./includes/
init.php
./includes/
class_core.php
./includes/
config.php
./includes/
functions.php
./includes/
class_hook.php
./includes/
modsystem_functions.php
./includes/
functions_bigthree.php
./includes/
class_postbit.php
./includes/
class_bbcode.php
./includes/
functions_reputation.php
./includes/
functions_threadedmode.php
./includes/
functions_post_thanks.php
Hooks Called:
init_startup
init_startup_session_setup_start
init_startup_session_setup_complete
cache_permissions
fetch_postinfo_query
fetch_postinfo
fetch_threadinfo_query
fetch_threadinfo
fetch_foruminfo
style_fetch
cache_templates
global_start
parse_templates
global_setup_complete
showthread_start
showthread_getinfo
forumjump
showthread_post_start
showthread_query_postids_threaded
showthread_threaded_construct_link
showthread_query
bbcode_fetch_tags
bbcode_create
showthread_postbit_create
postbit_factory
postbit_display_start
post_thanks_function_post_thanks_off_start
post_thanks_function_post_thanks_off_end
post_thanks_function_fetch_thanks_start
post_thanks_function_fetch_thanks_end
post_thanks_function_thanked_already_start
post_thanks_function_thanked_already_end
fetch_musername
postbit_imicons
bbcode_parse_start
bbcode_parse_complete_precache
bbcode_parse_complete
postbit_display_complete
post_thanks_function_can_thank_this_post_start
tag_fetchbit_complete
forumrules
navbits
navbits_complete
showthread_complete
Messages:
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
ignored users:
threadinfo[vote] =
returning smilies from the datastore
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
(unspecified) fetch_permissions(15, 0, 1,''); -> cached fperms for forum 15
php_sapi_name(): fpm-fcgi
03-08-2007, 04:26 AM
Threaded Mode