Latest Images in our gallery

SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM cpg15x_gallerypictures AS p LEFT JOIN cpg15x_galleryusers AS u ON p.owner_id = u.user_id LEFT JOIN cpg15x_galleryalbums AS a ON p.aid = a.aid LEFT JOIN cpg15x_gallerycategories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = "")) ORDER BY p.ctime DESC LIMIT 0,10



Archive for Reminder

Spare Parts in theatres today!

sparepartstheatres
(click image above to see theatrical listings)

The day has finally come Spare Parts hits select theatres today. You can view which theatres are showing the film by clicking the image above. Here’s the synopsis and trailer for he movie:

Four Hispanic high school students form a robotics club under the leadership of their school’s newest teacher, Fredi. With no experience, 800 bucks, used car parts and a dream, this rag tag team goes up against the country’s reigning robotics champion, MIT. On their journey, they learn not only how to build a robot- they learn to build a bond that will last a lifetime.


BTR on Penguins Of Madagascar!

Remember back in September when the guys were in the recording studio, recording for a guest appearance on the Penguins Of Madagascar? Looks like we’ll finally get to see the guys in action… and as beavers! Tune into Nickelodeon on Monday July 16th @ 6:30PM to catch the episode!


Reminder: Vote For The KCAs!


The 2012 Kid’s Choice Awards are rapidly approaching and BTR needs your vote to bring home that sweet orange blimp for Favourite Music Group! You can vote on Nick.com, Facebook and you can even vote on twitter just hastag your tweets with “ #FavMusic #BigTimeRush #KCA“!