Board Logo
Go To Bottom

Forum Rules
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.

  • Printable Version  
    [ Total Views: 3329 | Total Replies: 0 | Thread Id: 104530 ]
    Author: Subject:  5 speed complete transmissions
    MemberSubarugears
    Officially Full-On Dubber
    ***


    Avatar


    Posts: 236
    Threads: 17
    Registered: December 24th, 2011
    Member Is Offline

    Location: Sydney, Australia
    Theme: UltimaBB Pro Blue ( Default )

    posted on December 30th, 2013 at 08:06 AM
    5 speed complete transmissions


    With the removal of banner ads and the introduction of weekly deals, Subarugears would like to offer Aussieveedubbers members an additional 5% discount through the Weekly Deals forum.

    Subarugears now has a range of remanufactured, reversed Subaru 5 speeds in stock from $3,500 + GST with a range of final drive ratios from 3.9:1 to 4.86:1 Mention your Aussieveedubbers user name and receive a 5% discount on remanufactured transmissions or our Subaru 5 speed conversion kit.




    http://i221.photobucket.com/albums/dd163/ttriebler/Samba-banner-ad.gif


      Go To Top


    Powered by GaiaBB, © 2011 The GaiaBB Group


    [ Queries: 40 ] [ PHP: 37.6% - SQL: 62.4% ]
    #Duration:Query:
    1.0.00032210SELECT * FROM ubb_settings
    2.0.00024700SELECT moderator FROM ubb_forums WHERE moderator != ''
    3.0.00020409SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
    4.0.00025988SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
    5.0.00018096SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
    6.0.00014281SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
    7.0.00013804SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
    8.0.00013804SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
    9.0.00017405SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
    10.0.00013995SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
    11.0.00012016SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
    12.0.00015092SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
    13.0.00011683SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
    14.0.00016713SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
    15.0.00060487SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC
    16.0.00022101SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '104530'
    17.0.00028396DELETE FROM ubb_whosonline WHERE ip = '3.236.98.69' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1624107744'
    18.0.00015593INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.236.98.69', LPAD('1624108344', '15', '0'), '/viewtopic.php?tid=104530', '0', '')
    19.0.00015211DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.236.98.69') OR (onlinetime < '1624021944'))
    20.0.00010180DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.236.98.69') OR (onlinetime < '1624021944'))
    21.0.00009799INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.236.98.69', '1624108344')
    22.0.00018096SELECT * FROM ubb_themes WHERE themeid = '1'
    23.0.00011110SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
    24.0.00012898SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '236' OR ip2 = '-1') AND (ip3 = '98' OR ip3 = '-1') AND (ip4 = '69' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
    25.0.00044107SELECT 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
    26.0.00014400SELECT themeid, name FROM ubb_themes
    27.0.00086999SELECT name, template FROM ubb_templates WHERE name IN ('functions_bbcode', 'functions_bbcodeinsert', 'functions_smilieinsert_smilie', 'functions_smilieinsert', 'viewtopic_reply', 'viewtopic_quickreply', 'viewtopic', 'viewtopic_invalid', 'viewtopic_modoptions', 'viewtopic_newpoll', 'viewtopic_newtopic', 'viewtopic_poll_options_view', 'viewtopic_poll_options', 'viewtopic_poll_submitbutton', 'viewtopic_poll', 'viewtopic_post', 'viewtopic_post_email', 'viewtopic_post_site', 'viewtopic_post_icq', 'viewtopic_post_aim', 'viewtopic_post_msn', 'viewtopic_post_yahoo', 'viewtopic_post_search', 'viewtopic_post_profile', 'viewtopic_post_pm', 'viewtopic_post_ip', 'viewtopic_post_repquote', 'viewtopic_post_report', 'viewtopic_post_edit', 'viewtopic_post_delete', 'viewtopic_post_attachmentimage', 'viewtopic_post_attachment', 'viewtopic_post_attach_noborder', 'viewtopic_post_attimg_noborder', 'viewtopic_post_sig', 'viewtopic_post_nosig', 'viewtopic_printable', 'viewtopic_printable_row', 'viewtopic_multipage', 'viewtopic_post_attachment_none', 'viewforum_rules', 'viewtopic_post_blog', 'viewtopic_post_rpg', 'viewforum_mpn_info', 'viewtopic_next_prev_links', 'viewtopic_captcha', 'css', 'error', 'footer', 'footer_querynum', 'footer_load', 'footer_phpsql', 'footer_totaltime', 'header', 'message', 'meta_tags', 'shadow', 'shadow2')
    28.0.00028706SELECT 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 = '104530'
    29.0.00019383SELECT * FROM ubb_forums WHERE fid='106' AND status='on'
    30.0.00013900SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
    31.0.00007701SELECT find, replace1 FROM ubb_words
    32.0.00013113SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
    33.0.00018096UPDATE ubb_threads SET views = views+1 WHERE tid = '104530' LIMIT 1
    34.0.00015402SELECT COUNT(pid) FROM ubb_posts WHERE tid = '104530'
    35.0.00053096SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 104530 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.00043297SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 104530 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.00018120SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '104530'
    38.0.00019097SELECT pid FROM ubb_posts WHERE tid = '104530' ORDER BY pid LIMIT 0, 30
    39.0.00015092SELECT * FROM ubb_attachments WHERE pid IN('979043')
    40.0.00036311SELECT 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 = '104530' ORDER BY p.pid ASC LIMIT 0, 30