Home Contact Join for FREE About Us Site Map Gallery News Directory

Go Gators You missed this gator event - make sure you check back for this years date and time Beautifull Calendar Girls Photographers - Events - Promotions and more.. Exit stage right! Jodie quiles One of many beautiful calendar girls in our galleries Kristi Parrales View More Images of Kristi - Become a member today Galleries | Newsletters

Recommend a Website   Your name Your Email Address Recommended Website URL (include http://) What is special about this website?   Security Code:       Check Link status | Exchange Links | Recommend a Website | Bikini Model Link Partners Powered by JV-LinkExchanger Quick Access to the Most Popular Models Amy Zidian  Andrea Lowell April Scott Ashley Massaro Ashley Smith Aspen Lea Barbie Blank Becky Wunder Brittany Noel Brooke Paller Charity Hodges Carin Ashley Donna Feldman Holly Weber Jessica Canizales Jillian Beyor Kristyl Spears Lisa Perry Maggie Heinen Maria Checa Milena Roucka  Paula LaRocca Samantha Harris Tami Donaldson Tiffany Toth Become a Member Members have access to Personal Profiles, Upload Features, Rating System, Private Casting Calls, Pesonal Blog Features and more... REGISTER NOW   Username Password Remember me Enter what you see: tips: hit Reload page before writing a text if you have difficulty reading characters in image Lost Password?

Home Contact Join for FREE About Us Site Map Gallery News Directory

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%directory%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'directory/recommend.html.html' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_jvlinx&Itemid=118&lang=en&task=recommend' AND `oldurl` = 'Directory/recommend.html.html'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 118 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1280416535' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280416535' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT *
 FROM jos_session
 WHERE session_id = '25b1c3c637761bd8ffa8a005f9a76ff0'
9
SELECT session_id
 FROM jos_session
 WHERE session_id = 'e23fdef0f4b0864ab56978ba06c73e5b'
10
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( 'e23fdef0f4b0864ab56978ba06c73e5b','1280417435','','0','1' )
11
SELECT id FROM jos_mambots WHERE element = 'joomsef_metabot' AND folder = 'system'
12
SELECT *
 FROM jos_mambots
 WHERE id = '26'
13
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 118 )
 ORDER BY menuid DESC
LIMIT 1
14
SELECT *
 FROM jos_menu
 WHERE id = 118
15
select * from jos_jvlinx_settings
16
select * from jos_jvlinx_settings
17
select count(id) as CNT from jos_jvlinx_categories
18
select count(id) as CNT from jos_jvlinx_categories
19
delete from jos_jvlinx_captcha where created_on < '1280417135'
20
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
21
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
22
SELECT m.id
 FROM jos_modules AS m
 WHERE m.module = 'mod_rssfeed'
 AND m.published = 1
23
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 118 )
 ORDER BY ordering
24
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
25
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
26
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=74'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_sefservicemap&Itemid=96&lang=en'
28
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
29
UPDATE `jos_fabanner` SET finished=1, published=0
          WHERE (enddate < curdate() and enddate != '0000-00-00')
             OR (impressions >= maximpressions AND maximpressions != 0 )
             OR (clicks >= maxclicks AND maxclicks != 0)
30
UPDATE `jos_fabanner` SET published=1
          WHERE startdate31
UPDATE `jos_fabanner` SET dailyimpressions=0, lastreset=curdate()
          WHERE lastreset32
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 1 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
33
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 1 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
34
SELECT *
 FROM jos_fabanner
 WHERE bannerid = '14'
35
UPDATE jos_fabanner SET `clientid`='4',`linkid`='15',`sizeid`='8',`imageurl`='',`imagealt`='BetUS 728 Poker',`customcode`='\r\n',`restrictbyid`='0',`clicks`='7',`impressions`='962646',`startdate`='0000-00-00',`enddate`='0000-00-00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='34',`lastreset`='2010-07-29',`published`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00' WHERE bannerid='14'
36
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_flexadvert&bannerid=14&lang=en&task=click'
37
SELECT * FROM  `jos_js_smoothgallery_conf` LIMIT 1
38
SELECT * FROM `jos_js_smoothgallery` WHERE published=1 AND catid = '0' ORDER by ordering
39
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'NetworkNavigation'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
40
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_yanc&Itemid=94&lang=en'
41
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
42
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
43
SELECT *
 FROM jos_fabanner
 WHERE bannerid = '13'
44
UPDATE jos_fabanner SET `clientid`='3',`linkid`='14',`sizeid`='12',`imageurl`='',`imagealt`='SBCOM-Players Flex300',`customcode`='',`restrictbyid`='0',`clicks`='30',`impressions`='1215143',`startdate`='0000-00-00',`enddate`='0000-00-00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='39',`lastreset`='2010-07-29',`published`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00' WHERE bannerid='13'
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_flexadvert&bannerid=13&lang=en&task=click'
46
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
47
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
48
SELECT *
 FROM jos_fabanner
 WHERE bannerid = '15'
49
UPDATE jos_fabanner SET `clientid`='1',`linkid`='16',`sizeid`='12',`imageurl`='',`imagealt`='Adam Eve Sex Toys',`customcode`='\r\n',`restrictbyid`='0',`clicks`='0',`impressions`='1169959',`startdate`='0000-00-00',`enddate`='0000-00-00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='39',`lastreset`='2010-07-29',`published`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00' WHERE bannerid='15'
50
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_flexadvert&bannerid=15&lang=en&task=click'
51
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
52
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
53
SELECT *
 FROM jos_fabanner
 WHERE bannerid = '16'
54
UPDATE jos_fabanner SET `clientid`='4',`linkid`='17',`sizeid`='12',`imageurl`='HTdownlaods-mobile-300x250.gif',`imagealt`='BetUS.com Casino 300x250',`customcode`='  ',`restrictbyid`='0',`clicks`='0',`impressions`='590109',`startdate`='0000-00-00',`enddate`='0000-00-00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='39',`lastreset`='2010-07-29',`published`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00' WHERE bannerid='16'
55
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_flexadvert&bannerid=16&lang=en&task=click'
56
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
57
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 2 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
58
SELECT *
 FROM jos_fabanner
 WHERE bannerid = '17'
59
UPDATE jos_fabanner SET `clientid`='3',`linkid`='18',`sizeid`='12',`imageurl`='HTdownlaods-mobile-300x250.gif',`imagealt`='Sportsbook.com Casino Banner 300x600',`customcode`='',`restrictbyid`='0',`clicks`='0',`impressions`='590070',`startdate`='0000-00-00',`enddate`='0000-00-00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='39',`lastreset`='2010-07-29',`published`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00' WHERE bannerid='17'
60
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_flexadvert&bannerid=17&lang=en&task=click'
61
SELECT `jos_fabanner`.`bannerid`,
               `jos_falocation`.`locationname`,
               `jos_fabanner`.`imageurl`,
               `jos_fabanner`.`imagealt`,
               `jos_fabanner`.`customcode`,
               `jos_fabanner`.`startdate`,
               `jos_fabanner`.`enddate`,
               `jos_fabanner`.`lastreset`,
               `jos_fabanner`.`impressions`,
               `jos_fabanner`.`clicks`,
               `jos_fabanner`.`maximpressions`,
               `jos_fabanner`.`maxclicks`,
               `jos_fabanner`.`linkid`,
               `jos_fasize`.`width`,
               `jos_fasize`.`height`,
               `jos_fabanner`.`restrictbyid`,
               `jos_fabanner`.`dailyimpressions`,
               if(`jos_faclient`.`barred` OR `jos_fabanner`.`finished`OR NOT `jos_fabanner`.`published`, 0, 1) as `valid`
        FROM   `jos_fabanner`
        Inner Join `jos_fabannerlocation` ON `jos_fabanner`.`bannerid` = `jos_fabannerlocation`.`bannerid`
        Inner Join `jos_faclient` ON `jos_fabanner`.`clientid` = `jos_faclient`.`clientid`
        Inner Join `jos_falocation` ON `jos_fabannerlocation`.`locationid` = `jos_falocation`.`locationid`
        Inner Join `jos_falocationsize` ON `jos_falocation`.`locationid` = `jos_falocationsize`.`locationid`
        Inner Join `jos_fasize` ON `jos_fabanner`.`sizeid` = `jos_fasize`.`sizeid`
               AND `jos_falocationsize`.`sizeid` = `jos_fasize`.`sizeid`
        WHERE `jos_falocation`.`locationid` = 3 
          AND `jos_fabanner`.`published` = 1
        ORDER BY `restrictbyid` desc, `dailyimpressions`
62
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
63
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_sefservicemap&Itemid=96&lang=en'