Board Logo
Go To Bottom

Printable Version  
[ Total Views: 13061 | Total Replies: 30 | Thread Id: 27695 ]
 Pages:  1  2
Author: Subject: How to: Electric Windows!
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

cool.gif posted on August 21st, 2004 at 07:18 PM
How to: Electric Windows!


I finally wrote the article;

http://www.offroadvw.net/tech/wes/windows.html




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Memberaggri1
A.k.a.: Aurel Griesser
Insano Dub Head
****


No Avatar


Posts: 823
Threads: 35
Registered: December 3rd, 2003
Member Is Offline

Location: Eastern Melbourne
Theme: UltimaBB Pro Grey
Mood: ska'd for life

posted on August 23rd, 2004 at 02:49 PM


Nice article. Not my kind of equipment though - as little electrical stuff as I can get away with is more my theme.
Super Administratorbarls
A.k.a.: Mr indestructible
Super Administrator
Causer of Chaos and Mayhem
*********

Rank Avatar

No Avatar


Posts: 9385
Threads: 291
Registered: June 22nd, 2004
Member Is Offline

Location: cruising in denistone east
Theme: UltimaBB Streamlined2
Mood: indestructible? and listening to the voices

posted on August 23rd, 2004 at 02:56 PM


thanks for the article i may do something similar to this with the new bug



“We all pay for life with death, so everything in between should be free.” Bill Hicks
the chaos project - click me

http://www.goats.com/store/images/banner_destroy.png
Memberwacked1
Custom Title Time!
*****


Avatar


Posts: 1508
Threads: 302
Registered: July 8th, 2003
Member Is Offline

Location: western Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: naked

posted on August 23rd, 2004 at 06:17 PM


how hard would this be to do on a bus



YOU HAVE JUST BEEN DAKED
don't worry it's a VW thing
MemberKruizinKombi
A.k.a.: Col
Bishop of Volkswagenism
Seriously Obsessed Cyber Dubber
******


Avatar


Posts: 3493
Threads: 104
Registered: August 25th, 2002
Member Is Offline

Location: Gippsland, Victoria
Theme: UltimaBB Pro Blue ( Default )
Mood: Indifferent

posted on August 23rd, 2004 at 09:33 PM


Nice job Wes, and nice looking kit too. It seems to come with all the bits and bobs, unlike some cheaper kits....



Kruizin Kol
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on August 24th, 2004 at 08:16 AM


having never really played with a kombi's door, I can't say how hard it would be on a kombi. Not very hard I wouldn't think. It can't be that much different. It's a universal kit, it's designed to fit any car.

I've had mine for quite a few years now. 4 or 5 years, can't remember. They still work perfectly, not probs at all. Even with crap VW winders. The motors are quite powerful.




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on August 24th, 2004 at 08:34 AM


I tried to find some info on Autostrada. It is a weird little place, and actually a distributor, not a retail shop, however you can still buy from them. I found a website that I think is their's, http://www.autostrada.com.au/ . Go there and search for "electric windows". At the time of typing this they were selling a SPAL kit for $409, I think my original kit in my Baja was the SPAL one. There is an email contact on their website.



Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membernbturbo
Veteran Volks Folk
*****


Avatar


Posts: 2170
Threads: 89
Registered: December 19th, 2002
Member Is Offline

Location: Whyalla Sth.Aust.
Theme: UltimaBB Powder

posted on August 24th, 2004 at 02:51 PM


Thanks Wes-well done-good story and pics.I have been a bit worried because I plan on doing this to mine during the resto and thought it may have been one of those jobs that would be a pain in the arse-but it appears pretty straight forward.Thanks.
Memberbugmeister
Slammed & Awesome Dubber
**


No Avatar


Posts: 89
Threads: 25
Registered: September 3rd, 2002
Member Is Offline

Location: Logan - Brisbane
Theme: UltimaBB Pro Blue ( Default )

posted on October 4th, 2004 at 11:42 PM


If anyone needs the electric window kit, I have a new Jaycar sourced one in the cupbaord you may want to make an offer on. It is the same construction as the SPAL, just generic though.
Membersubibaja
Wolfsburg Wizard
***


Avatar


Posts: 501
Threads: 45
Registered: September 4th, 2005
Member Is Offline

Location: Brisbane, QLD
Theme: XMBX Pro Green

posted on September 6th, 2005 at 09:23 PM


because of my roll cage i have to run these too
better start saving
cause i,m sick of opening the door to wind them up
hehehehehe




anyone who says it's bad to put subaru motors in vw's.....
hasnt got a clue about smoooooooooth

terry
brisbane
0403252522
you know who i am
Membercrewcabconnection
Custom Title Time!
Being Sid James
*****


Avatar


Posts: 1922
Threads: 293
Registered: April 22nd, 2003
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )
Mood: Looking forward to week 10

posted on September 6th, 2005 at 09:29 PM


is there one for a split screen????:P



Loves a lolcat
Memberboxofrabbits
Seriously Crusin Dubber
**


Avatar


Posts: 145
Threads: 40
Registered: December 6th, 2005
Member Is Offline

Location: Devils Bend, VIC
Theme: UltimaBB Pro Blue ( Default )

posted on February 23rd, 2006 at 08:18 PM



How about a tutorial for making some of those snazzy door panels Wes
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on March 3rd, 2006 at 02:25 PM



maybe if I get really bored :). It isn't as hard as you'd think.



Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membernbturbo
Veteran Volks Folk
*****


Avatar


Posts: 2170
Threads: 89
Registered: December 19th, 2002
Member Is Offline

Location: Whyalla Sth.Aust.
Theme: UltimaBB Powder

posted on March 3rd, 2006 at 04:28 PM



Wes,I tried to deal with that Autostrada crowd when you posted it-Don't remember all the details now,but got some emails from them,but all contact finished when I told them I wasn't a Subaru Dealer-they needed my Dealer number to continue contact with me.Did I go wrong somewhere???
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on March 3rd, 2006 at 05:00 PM



I think they are actually a distributor. I just walk in the door and ask for stuff and they sell it to me. A little different interstate I guess. Just ask who they distribute to in your area and buy it there. I think they sell to autobarn.

It's weird cos they advertise stuff on their site;
http://www.autostrada.com.au/Stockview.asp?key=33




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membernbturbo
Veteran Volks Folk
*****


Avatar


Posts: 2170
Threads: 89
Registered: December 19th, 2002
Member Is Offline

Location: Whyalla Sth.Aust.
Theme: UltimaBB Powder

posted on March 3rd, 2006 at 07:53 PM



Yes I found that screen-but you need to register to go any further and the first thing they want is a customer ID number.You wouldn't by any chance have a contact phone number for them?
MemberBaja Wes
Bishop of Volkswagenism
V6 Baja Pioneer
******


Avatar


Posts: 3119
Threads: 94
Registered: August 26th, 2002
Member Is Offline

Location: Brisbane
Theme: UltimaBB Pro Blue ( Default )
Mood: Content

posted on March 3rd, 2006 at 08:53 PM



yeah, it's on there contact page (a pop-up)

Autostrada Accessories
84 Brookes St
Fortitude Valley
QLD 4006
Phone: 07 3852 6886
Fax: 07 3852 6887

Sales eMail: sales@autostrada.com.au
Technical eMail: tech@autostrada.com.au




Wes - www.offroadvw.net - 200HP Quad Cam V6 in a VW Baja - with climate control... :)
www.taylorcycles.com.au - My DH MTB racing brothers shop.
Membermodulus
A.k.a.: Peter Hill
Veteran Volks Folk
*****


Avatar


Posts: 2009
Threads: 76
Registered: July 1st, 2003
Member Is Offline

Location: Melbourne
Theme: UltimaBB Pro White
Mood: modular

posted on March 3rd, 2006 at 09:46 PM



That's a neat solution for the Beetles and well written up.

For the Bay Kombi, I believe that there is a Bosch motor/winder which is a direct, bolt-in replacement for the manual winder which was used on some 1990's 3-series BMWs and other Euros. If the right Bosch part can be found, this is a 30 minute job (modulo some wiring and switch placement).

I'd be keen to know if anyone knows what the Bosch part # is.




Peter Hill
1975 Type 2 Double Cab
modulus.com.au
Memberkarmen
Son of Jim - Creator of Good
******


Avatar


Posts: 2648
Threads: 130
Registered: April 16th, 2003
Member Is Offline

Location: Maryborough QlD
Theme: UltimaBB Pro Blue ( Default )
Mood: cruisin on twin dellortos

posted on March 3rd, 2006 at 10:02 PM



ditto



Karmen
56 oval resto 60 Cal KG
58 & 62 beetle parting. 74 panel parting
63 Baja 80 GLD parting
58 donor split 11 window 63 Splitty sgle cab /son's
96 Seat Cordoba GLX daily drvr.
Membernbturbo
Veteran Volks Folk
*****


Avatar


Posts: 2170
Threads: 89
Registered: December 19th, 2002
Member Is Offline

Location: Whyalla Sth.Aust.
Theme: UltimaBB Powder

posted on March 4th, 2006 at 09:26 AM



Thanks Wes.
MemberSirDelton
Seriously Crusin Dubber
**


Avatar


Posts: 124
Threads: 15
Registered: June 19th, 2006
Member Is Offline

Location: Clinton / Gladstone
Theme: UltimaBB Pro Blue ( Default )
Mood: Will it ever run again..

posted on June 20th, 2006 at 07:56 AM



Great article Wes
MemberRommel
Slammed & Awesome Dubber
**


Avatar


Posts: 85
Threads: 15
Registered: September 29th, 2008
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on October 13th, 2008 at 07:32 PM



Good job Wes. I think I will do that 'lecy window. I also would like to see how you made those door trims.
Membercam070
Custom Title Time!
*****


Avatar


Posts: 1332
Threads: 53
Registered: July 25th, 2009
Member Is Offline

Location: Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Getting hands dirty stripping the bug down

posted on August 1st, 2010 at 11:04 PM



Can anyone tell me if it possible to mount the mechanism so that nothing protrodes through the door panel? I'm looking at building new door trims, and if I can conceal all the mechanisms behind the panel and not have to use the blanking plugs, that would be my ideal solution.
Memberbeetleboyjeff
A.k.a.: Jeff Walsh
Custom Title Time!
*****


Avatar


Posts: 1704
Threads: 40
Registered: February 13th, 2009
Member Is Offline

Location: Port Macquarie
Theme: UltimaBB Pro Blue ( Default )
Mood: Drive bugs hard

posted on August 1st, 2010 at 11:38 PM



I used the same kit that I bought from Autobahn a few years ago.
I screwed the motor direct to the bottom of the door skin though.
I also glued my plastic sheet to the outside of the inside door skin so it was outside all of the electrics.
I then used rubber tubes which are fitted tightly into gromets in the A pillar, but slide through holes in the front edge of the door for the wiring to go through undamaged. I also 'dented' both the pillar and the door edge to allow more room between them for the gromets etc.
When I made my door liners, I installed pockets on them for the electric window switches and storage etc.

Error
Sorry, you must be a registered user in order to download attachments.


Error
Sorry, you must be a registered user in order to download attachments.


Error
Sorry, you must be a registered user in order to download attachments.




From your ole' mate Jeff
Memberbeetleboyjeff
A.k.a.: Jeff Walsh
Custom Title Time!
*****


Avatar


Posts: 1704
Threads: 40
Registered: February 13th, 2009
Member Is Offline

Location: Port Macquarie
Theme: UltimaBB Pro Blue ( Default )
Mood: Drive bugs hard

posted on August 1st, 2010 at 11:45 PM



More photos.

Error
Sorry, you must be a registered user in order to download attachments.


Error
Sorry, you must be a registered user in order to download attachments.


Error
Sorry, you must be a registered user in order to download attachments.




From your ole' mate Jeff
MemberJoel
Scirocco Rare
Now containing 100% E-Wang
*********


Avatar


Posts: 9368
Threads: 211
Registered: February 14th, 2006
Member Is Offline

Location: Northern Rivers NSW
Theme: UltimaBB Pro Purple
Mood: Tact Level 0.00

posted on August 2nd, 2010 at 09:29 AM



I spaced mine in abit by using longer bolts to achieve the same thing.

I already had the holes for the winders so just mounted the switches there to cover them
3 years later still work fine

http://i79.photobucket.com/albums/j154/Vbug74/windows.jpg

http://i79.photobucket.com/albums/j154/Vbug74/windows011.jpg

http://i79.photobucket.com/albums/j154/Vbug74/windows008.jpg
Membercam070
Custom Title Time!
*****


Avatar


Posts: 1332
Threads: 53
Registered: July 25th, 2009
Member Is Offline

Location: Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Getting hands dirty stripping the bug down

posted on August 2nd, 2010 at 11:09 PM



Thanks for the replies guys. This really helps, and like someone else just said, is there anything you don't have pics of Joel.

And Jeff that's some pretty trick door trims you have there. What did the doo pockets come off? And I assme they are installed back to front by the lights.
Memberbeetleboyjeff
A.k.a.: Jeff Walsh
Custom Title Time!
*****


Avatar


Posts: 1704
Threads: 40
Registered: February 13th, 2009
Member Is Offline

Location: Port Macquarie
Theme: UltimaBB Pro Blue ( Default )
Mood: Drive bugs hard

posted on August 2nd, 2010 at 11:32 PM



I think the 'plastic' part of the door trimis are off an old 626, and yes, they are installed 'backwards'. I had to do that because the 'fat' end wouldn't fit between the door and the big 'Autotechnica' seats. It worked out very good though, because the lights light up the footwells quite well when you open the doors, and it gave me a spot to fit little flouros in a light box behind the VW emblem.

Error
Sorry, you must be a registered user in order to download attachments.




From your ole' mate Jeff
Membercam070
Custom Title Time!
*****


Avatar


Posts: 1332
Threads: 53
Registered: July 25th, 2009
Member Is Offline

Location: Sydney
Theme: UltimaBB Pro Blue ( Default )
Mood: Getting hands dirty stripping the bug down

posted on August 3rd, 2010 at 08:18 PM



Even more nifty!
Memberacemarc
Casual Dubber
*


Avatar


Posts: 41
Threads: 21
Registered: July 6th, 2010
Member Is Offline

Theme: UltimaBB Pro Blue ( Default )

posted on July 22nd, 2011 at 10:05 PM
Spal window kits.


The kits being used here are pretty heavy duty indeed! I work for Audioxtra which is a distributor for SPAL products - but none of them look like those. Also, chopping out big chunks of the inner door skin is not necessary with aftermarket Spal kits. Anyone wanting more info:

http://www.audioxtra.com.au/html/s02_article/article_view.asp?art_id=1502&...

As we are a distributor, we don't sell to the public but call your closest branch and we'll let you know the retailers near you.
 Pages:  1  2


  Go To Top


Powered by GaiaBB, © 2011 The GaiaBB Group


[ Queries: 40 ] [ PHP: 27.4% - SQL: 72.6% ]
#Duration:Query:
1.0.00035596SELECT * FROM ubb_settings
2.0.00022292SELECT moderator FROM ubb_forums WHERE moderator != ''
3.0.00019503SELECT DISTINCT uid FROM ubb_members WHERE username = 'BUGBOY'
4.0.00017691SELECT DISTINCT uid FROM ubb_members WHERE username = 'MickH'
5.0.00027204SELECT DISTINCT uid FROM ubb_members WHERE username = 'barls'
6.0.00021005SELECT DISTINCT uid FROM ubb_members WHERE username = 'vanderaj'
7.0.00029087SELECT DISTINCT uid FROM ubb_members WHERE username = 'Cam'
8.0.00015497SELECT DISTINCT uid FROM ubb_members WHERE username = 'vw54'
9.0.00014806SELECT DISTINCT uid FROM ubb_members WHERE username = 'SuperOwen'
10.0.00023794SELECT DISTINCT uid FROM ubb_members WHERE username = 'helbus'
11.0.00015402SELECT DISTINCT uid FROM ubb_members WHERE username = '65busser'
12.0.00022101SELECT DISTINCT uid FROM ubb_members WHERE username = 'Baja Wes'
13.0.00013804SELECT DISTINCT uid FROM ubb_members WHERE username = 'Dasdubber'
14.0.00015187SELECT DISTINCT uid FROM ubb_members WHERE username = 'MISS VDUB'
15.0.00063801SELECT LENGTH(robot_string) AS strlen, robot_string, robot_fullname FROM ubb_robots ORDER BY strlen DESC
16.0.00027299SELECT f.fid, f.theme FROM ubb_forums f, ubb_threads t WHERE f.fid = t.fid AND t.tid = '27695'
17.0.00032187DELETE FROM ubb_whosonline WHERE ip = '3.235.41.241' && (username = 'xguest123' OR username = 'xrobot123' OR username = 'Anonymous') OR time < '1618068075'
18.0.00020385INSERT INTO ubb_whosonline (username, ip, time, location, invisible, robotname) VALUES ('xguest123', '3.235.41.241', LPAD('1618068675', '15', '0'), '/viewtopic.php?tid=27695', '0', '')
19.0.00021005DELETE FROM ubb_guestcount WHERE ((ipaddress = '3.235.41.241') OR (onlinetime < '1617982275'))
20.0.00011706DELETE FROM ubb_robotcount WHERE ((ipaddress = '3.235.41.241') OR (onlinetime < '1617982275'))
21.0.00009704INSERT INTO ubb_guestcount (ipaddress, onlinetime) VALUES ('3.235.41.241', '1618068675')
22.0.00031090SELECT * FROM ubb_themes WHERE themeid = '1'
23.0.00013614SELECT * FROM ubb_pluglinks ORDER BY displayorder ASC
24.0.00017095SELECT id FROM ubb_banned WHERE ((ip1 = '3' OR ip1 = '-1') AND (ip2 = '235' OR ip2 = '-1') AND (ip3 = '41' OR ip3 = '-1') AND (ip4 = '241' OR ip4 = '-1')) AND NOT (ip1 = '-1' AND ip2 = '-1' AND ip3 = '-1' AND ip4 = '-1')
25.0.00060201SELECT 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.00112295SELECT themeid, name FROM ubb_themes
27.0.00117588SELECT 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.00037384SELECT 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 = '27695'
29.0.00021815SELECT * FROM ubb_forums WHERE fid='57' AND status='on'
30.0.00018883SELECT code, url FROM ubb_smilies WHERE type = 'smiley'
31.0.00016689SELECT find, replace1 FROM ubb_words
32.0.00018907SELECT id, title, posts, stars, allowavatars, avatarrank FROM ubb_ranks
33.0.00026798UPDATE ubb_threads SET views = views+1 WHERE tid = '27695' LIMIT 1
34.0.00040007SELECT COUNT(pid) FROM ubb_posts WHERE tid = '27695'
35.0.01306891SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 27695 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 = '57' ORDER BY l.dateline DESC LIMIT 1
36.0.01047802SELECT t.tid as t_tid FROM ubb_threads t LEFT JOIN ubb_threads o ON o.tid = 27695 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 = '57' ORDER BY l.dateline ASC LIMIT 1
37.0.00024295SELECT vote_id FROM ubb_vote_desc WHERE topic_id = '27695'
38.0.00026393SELECT pid FROM ubb_posts WHERE tid = '27695' ORDER BY pid LIMIT 0, 30
39.0.00391793SELECT * FROM ubb_attachments WHERE pid IN('222164', '223035', '223037', '223139', '223305', '223403', '223406', '223577', '241694', '404868', '404871', '458740', '460657', '460690', '460702', '460738', '460750', '460769', '460773', '460831', '502596', '674632', '793733', '793736', '793737', '793755', '793920', '793925', '794045', '853208')
40.0.00140691SELECT 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 = '57' AND p.tid = '27695' ORDER BY p.pid ASC LIMIT 0, 30