Automotive related businesses can advertise their weekly specials here and any projects they might have under way, or events they might have coming
up.
Please don't hijack anyone else's thread.
Spamming us, particularly if it's not VW related, is a no-no and will result in banning.
Play nice.
[ Total Views: 3194 | Total Replies: 0 | Thread Id: 113363 ]
Posts: 1340
Threads: 109
Registered: August 9th, 2004
Member Is Offline
Location: mullaway nsw nth coast
Theme: UltimaBB Pro Blue
posted on August 29th, 2018 at 10:44 AM
Midcoast Volkswerks
Our mechanic Graham is retiring in a few months, has lot of stuff for sale if anyone is interested have linked his page. http://www.mcvw.com.au/for-sale-.html
SELECT moderator FROM ubb_forums WHERE moderator != ''
3.
0.00011086
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
4.
0.00007510
SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
5.
0.00007391
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
6.
0.00007391
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
7.
0.00006485
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
8.
0.00006986
SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
9.
0.00007010
SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
10.
0.00006509
SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
11.
0.00008011
SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
12.
0.00006580
SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
13.
0.00007105
SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
14.
0.00007200
SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.
0.00032711
SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robotsORDER BY strlen DESC
16.
0.00011492
SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '113363'
17.
0.00015616
DELETE FROM ubb_whosonline WHERE ip = '34.231.147.28' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1653127643'
18.
0.00008607
INSERT INTO ubb_whosonline(username, ip, time, location, invisible, robotname) VALUES ('xguest123', '34.231.147.28', LPAD('1653128243', '15', '0'), '/viewtopic.php?tid=113363&page=1', '0', '')
19.
0.00008011
DELETE FROM ubb_guestcount WHERE ((ipaddress = '34.231.147.28') OR (onlinetime < '1653041843'))
20.
0.00005007
DELETE FROM ubb_robotcount WHERE ((ipaddress = '34.231.147.28') OR (onlinetime < '1653041843'))
21.
0.00004292
INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('34.231.147.28', '1653128243')
22.
0.00009298
SELECT * FROM ubb_themes WHERE themeid = '1'
23.
0.00006008
SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.
0.00006986
SELECT id FROM ubb_banned WHERE ((ip1 = '34' OR ip1 = '-1') AND (ip2 = '231' OR ip2 = '-1') AND (ip3 = '147' OR ip3 = '-1') AND (ip4 = '28' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.
0.00027084
SELECT fid, type, name, fup, status, private, userlist, password FROM ubb_forums WHERE private != '5' AND private != '3' AND private != '2' AND userlist = '' AND password = '' AND status = 'on' ORDER BY displayorder
SELECT t.tid, t.fid, t.subject, t.views, t.replies, t.closed, t.topped, l.uid as lp_uid, l.username as lp_user, l.dateline as lp_dateline, l.pid as lp_pid FROM ubb_threads t LEFT JOIN ubb_lastposts l ON l.tid = t.tid WHERE t.tid = '113363'
29.
0.00009990
SELECT * FROM ubb_forums WHERE fid='106' AND status='on'
30.
0.00007701
SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
31.
0.00004411
SELECT find, replace1 FROM ubb_words
32.
0.00009418
SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
33.
0.00008297
UPDATEubb_threads SET views = views+1 WHERE tid = '113363' LIMIT 1
34.
0.00007200
SELECT COUNT(pid) FROM ubb_posts WHERE tid = '113363'
35.
0.00030184
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 113363 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline < x.dateline AND t.fid = '106' ORDER BY l.dateline DESC LIMIT 1
36.
0.00024581
SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 113363 LEFT JOIN ubb_lastposts l ON l.tid = t.tid LEFT JOIN ubb_lastposts x ON x.tid = o.tid WHERE l.dateline > x.dateline AND t.fid = '106' ORDER BY l.dateline ASC LIMIT 1
37.
0.00007892
SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '113363'
38.
0.00007701
SELECT pid FROM ubb_posts WHERE tid = '113363' ORDER BY pid LIMIT 0, 30
39.
0.00007296
SELECT * FROM ubb_attachments WHERE pid IN('1040937')
40.
0.00024891
SELECT p.*, m.*,w.time FROM ubb_posts p LEFT JOIN ubb_members m ON m.username = p.author LEFT JOIN ubb_whosonline w ON p.author = w.username WHERE p.fid = '106' AND p.tid = '113363' ORDER BY p.pid ASC LIMIT 0, 30
