Coming. . .

Get the Flash Player to see this player.

Local Updates

Map & Info
Updates
Happenings News
Ferry Status
Cat Island Updates

TOURISM CALENDAR

July 2010
Su Mo Tu We Th Fr Sa
Week 26 1 2 3
Week 27 4 5 6 7 8 9 10
Week 28 11 12 13 14 15 16 17
Week 29 18 19 20 21 22 23 24
Week 30 25 26 27 28 29 30 31

Map List

  • Attractions
  • Government Sites
  • Historic District
  • Lodging
  • Main Map
  • Parks, Wildlife Areas
  • Restaurants & Bars
  • Shops
  • Wedding Facilities

    • TRAVEL TOOLS

    Media Center
    Information Request
    Group Planning
    Environmental Friendly
    Film Opportunities
    Transportation
    ePostcards

    links

    Useful Links

    Sign-In

    Members

    SlideShow Pro

    Get the Flash Player to see this player.
    saints team
    Welcome
    Consider this your invitation to enjoy all that West Feliciana Parish and Town of St. Francisville, Louisiana have to offer you and your family. Experience our southern hospitality as you explore our quaint small town, enjoy our fantastic shopping, admire our breathtaking scenery, and so much more! Whether you're coming for history, shopping or the outdoors, you'll find what you're looking for
    in West Feliciana Parish.
    Come for the history & fun, stay for your health.
    Read more...
     

    Happenings - What's Going On This Week & Next

    Cache Directory Unwriteable
    Audubon Pilgrimage PDF Print E-mail
    BUTLER GREENWOOD PLANTATION ONE OF FEATURES ON ANNUAL AUDUBON PILGRIMAGE IN ST. FRANCISVILLE, LA

    By Anne Butler

    butler greenwood Samuel Flower was one of the earliest English settlers in the St. Francisville area, a Quaker physician who emigrated from Pennsylvania in the 1770’s when the area was British territory; later, when Spain gained control, he treated Governor Manuel Gayoso. When Dr. Flower died in 1813, his eight heirs would divide thousands of arpents of land in the Felicianas, Rapides Parish, along Bayou Manchac, and in the Mississippi Territory. The family residence bordering Bayou Sara, appraised in the estate division at $12,300, was left to Dr. Flower’s 20-year-old butler greenwoodBUTLER GREENWOOD PLANTATION ONE OF FEATURES ON ANNUAL AUDUBON PILGRIMAGE IN ST. FRANCISVILLE, LA

    By Anne Butler

    Samuel Flower was one of the earliest English settlers in the St. Francisville area, a Quaker physician who emigrated from Pennsylvania in the 1770’s when the area was British territory; later, when Spain gained control, he treated Governor Manuel Gayoso. When Dr. Flower died in 1813, his eight heirs would divide thousands of arpents of land in the Felicianas, Rapides Parish, along Bayou Manchac, and in the Mississippi Territory. The family residence bordering Bayou Sara, appraised in the estate division at $12,300, was left to Dr. Flower’s 20-year-old married daughter Harriett. Now known as Butler Greenwood Plantation, the property is still owned and occupied by direct descendants of the original family and will be one of the featured tour homes on the Audubon Pilgrimage March 19, 20 and 21, 2010, as the West Feliciana Historical Society opens the doors to antebellum mansions and glorious gardens in celebration of artist John James Audubon’s stay in the parish in 1821.

    azaelas gardensThis 39th annual pilgrimage, the major fundraiser supporting society preservation projects, also marks the bicentennial celebration of the West Florida Republic, whereby the Anglo-American settlers wrested the area from Spanish control to belatedly join the United States in the winter of 1810. Harriett Flower’s husband, Judge George Mathews, was a superior court judge in the Mississippi Territory and then the Territory of Orleans, appointed by President Jefferson, and would become the chief justice of the Louisiana State Supreme Court once Louisiana became a state in 1812. His father, General George Mathews, was a Revolutionary War hero who survived being bayoneted nine times to become a US Congressman and governor of Georgia, and during the international political wrangling over just where the eastern boundary of the Louisiana Purchase might be, he was sent by President Madison to Mobile and St. Augustine to keep an eye on the situation and maybe even foment a rebellion there in hopes of annexing to the United States all of East Florida as well as West.

    From Butler GreenwoodHarriett and George Mathews lived at Butler Greenwood and raised indigo, cotton, sugarcane and corn, shipping the crops from their own dock on Bayou Sara and extending their landholdings to include a productive sugar plantation in Lafourche Parish that, according to Lewis Gray’s figures, placed them among the top 9% of sugar planters in the state in the 1850’s. After the death of Judge Mathews in 1836, his widow continued to run the plantations with help from her son Charles.

    In the census of 1860, both Harriett and her son list their occupations as “planter,” their household including Charles’ wife Penelope Stewart, their children, an Austrian music teacher and an Irish gardener, with 96 slaves living in 18 dwellings and their personal estate valued at $260,000. In that year the 1400 acres of Butler Greenwood Plantation produced 130 bales of cotton, 2000 bushels of corn, 175 hogsheads of sugar and more than 10,000 gallons of molasses. Their other plantations covered nearly 10,000 acres worked by some 400 slaves and were equally productive in 1860, although after the Civil War the labor force had fallen to a field gang of only 27 freedmen working for monthly wages on the home place.

    AntiqueNow the home of the seventh and eighth generation of the family, Butler Greenwood is a simple, raised cottage-style plantation home filled with family treasures—oil portraits, Brussels carpet, gilded pier mirrors, Mallard poster beds, fine china and silverware, a French Pleyel grand piano, and the area’s finest original Victorian formal parlor, its twelve matching pieces still in the original upholstery. Listed on the National Register of Historic Places since 1979, the house is surrounded by extensive groves of live oaks and formal gardens filled with ancient camellias and sasanquas, sweet olive and magnolia fuscata grown to immense size. The original detached brick kitchen dates from the 1790’s, the finely trimmed garden gazebo from the 1850’s.

    Other features of the 2010 Audubon Pilgrimage include historic townhouses (the recently beautifully reclaimed Cabildo and the Barrow House), Laurel Hill Plantation which has also been recently restored, glorious Afton Villa Gardens, Rosedown and Audubon State Historic Sites, three 19th-century churches as well as the Rural Homestead with its lively demonstrations of the rustic skills of daily pioneer life. Tour hostesses are clad in the exquisitely detailed costumes of the 1820’s, nationally recognized for their authenticity.

    audubon pilgrimageThe National Register-listed historic district around Royal Street is filled during the day with costumed children playing nostalgic games and dancing the Maypole; in the evening as candles flicker and fireflies flit among the ancient moss-draped live oaks, there is no place more inviting for a leisurely, lingering stroll. Friday evening features old-time Hymn Signing at the United Methodist Church, Graveyard Tours raising the dead to tell their stories at Grace Episcopal Church cemetery, and a wine and cheese reception at the West Feliciana Historical Society museum/pilgrimage headquarters. Saturday evening features dinner al fresco and dancing to live music. For tickets and tour information, contact the West Feliciana Historical Society, P.O. Box 338, St. Francisville, LA 70775; telephone 225-635-6330; online www.audubonpilgrimage.info, email This e-mail address is being protected from spam bots, you need JavaScript enabled to view it

    maypole under the oaksWith six plantations—Rosedown and Audubon State Historic Sites, Butler Greenwood, The Cottage, The Myrtles and Greenwood--open for daily tours, and Afton Villa Gardens open seasonally, the St. Francisville area (located on US Highway 61 between Baton Rouge, LA, and Natchez, MS) is a year-round tourist destination, but visitors find it especially enjoyable in the early spring when the glorious 19th-century gardens are filled with both camellias and azaleas. There are unique little shops in restored historic structures, and reasonably priced meals are available in a nice array of restaurants in St. Francisville. Some of the state's most unique Bed and Breakfasts offer overnight accommodations ranging from golf clubs and lakeside resorts to historic townhouses and country plantations; modern motel facilities can accommodate busloads. The scenic unspoiled Tunica Hills region surrounding St. Francisville offers excellent biking, hiking, birding, horseback riding and other recreational activities. For online coverage of tourist facilities, attractions and events in the St. Francisville area, see www.stfrancisville.us or www.stfrancisvilleovernight.com, or telephone (225) 635-3873 or 635-4224.

     
    [ Back ]
    285 queries executed
    1
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
    2
DELETE FROM jos_session
 WHERE (
 ( time < '1280596363' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1280596363' )
 AND guest = 1
 AND userid = 0
 )
    3
SELECT *
 FROM jos_session
 WHERE session_id = '0d32df11bb3c89518e5cba160990ec44'
    4
SELECT session_id
 FROM jos_session
 WHERE session_id = '316edbb581d13814d5dde004704824b7'
    5
INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '316edbb581d13814d5dde004704824b7','1280597263','','0','1' )
    6
SELECT params
 FROM jos_mambots
 WHERE element = 'jfdatabase.systembot'
 AND folder = 'system'
    7
SELECT * FROM jos_languages WHERE iso='en'
    8
SELECT joomlatablename,tablepkID FROM `jos_jf_tableinfo`
    9
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 0
    10
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 0
    11
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 1
    12
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 1
    13
SELECT COUNT(*)
 FROM jos_stats_agents
 WHERE agent = 'Unknown'
 AND type = 2
    14
UPDATE jos_stats_agents
 SET hits = ( hits + 1 )
 WHERE agent = 'Unknown'
 AND type = 2
    15
SELECT *
 FROM jos_menu
 WHERE id = 1
    16
SELECT a.*, u.name AS author, u.usertype, cc.name AS category, s.name AS section, g.name AS groups,
 s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access,
 s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 LEFT JOIN jos_categories AS cc ON cc.id = a.catid
 LEFT JOIN jos_sections AS s ON s.id = cc.section AND s.scope = 'content'
 LEFT JOIN jos_users AS u ON u.id = a.created_by
 LEFT JOIN jos_groups AS g ON a.access = g.id
 WHERE a.id = 106 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-31 13:27' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:27' )
 AND a.access <= 0
    17
SELECT a.id
 FROM jos_content AS a
 WHERE a.catid = 1
 AND a.state = 1
 AND a.access <= 0 AND ( a.state = 1 OR a.state = -1 )
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-31 13:27' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:27' )
 ORDER BY a.ordering
    18
UPDATE jos_content
 SET hits = ( hits + 1 )
 WHERE id = '106'
    19
SELECT hits
 FROM jos_core_log_items
 WHERE time_stamp = '2010-07-31'
 AND item_table = '#__content'
 AND item_id = '106'
    20
UPDATE jos_core_log_items
 SET hits = ( hits + 1 )
 WHERE time_stamp = '2010-07-31'
 AND item_table = '#__content'
 AND item_id = '106'
    21
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
    22
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
    23
SELECT *
 FROM jos_mambots
 WHERE id = '25'
    24
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
    25
SELECT *
 FROM jos_mambots
 WHERE id = '23'
    26
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
    27
SELECT *
 FROM jos_mambots
 WHERE id = '22'
    28
SELECT params
 FROM jos_mambots
 WHERE element = 'mosemailcloak'
 AND folder = 'content'
    29
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'
    30
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0
ORDER BY ordering
    31
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1'
    32
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1
ORDER BY ordering
    33
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND parent>0 AND published='1'
    34
SELECT m.* FROM jos_menu AS m
WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1
ORDER BY ordering
    35
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 = 1 )
 ORDER BY ordering
    36
SELECT id
 FROM jos_menu
 WHERE link = 'index.php?option=com_search'
 AND published = 1
    37
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'mainmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
    38
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
    39
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=16'
    40
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'TempDetour'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
    41
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=38'
    42
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
    43
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=40'
    44
SELECT * FROM jos_jcalpro_config
    45
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
    46
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
    47
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
    48
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 5 AND 10
GROUP BY g1.name
ORDER BY g1.lft
    49
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    50
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    51
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
    52
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
    53
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
    54
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 15 AND 18
GROUP BY g1.name
ORDER BY g1.lft
    55
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='administrator'
    56
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 16 AND 17
GROUP BY g1.name
ORDER BY g1.lft
    57
SELECT
  	cat_id, level
  FROM
  	jos_jcalpro_categories
    58
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    59
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    60
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    61
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    62
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    63
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    64
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    65
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    66
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    67
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    68
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    69
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    70
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    71
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    72
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    73
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    74
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    75
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    76
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    77
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    78
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    79
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    80
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    81
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    82
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    83
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    84
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    85
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    86
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
    87
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 4 AND 11
GROUP BY g1.name
ORDER BY g1.lft
    88
SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
    89
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_core_acl_aro_groups AS g2 ON g1.lft BETWEEN g2.lft AND g2.rgt
WHERE g1.lft BETWEEN 14 AND 19
GROUP BY g1.name
ORDER BY g1.lft
    90
SELECT name FROM jos_jcalpro_themes WHERE published= '1'
    91
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100701 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100701 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100701 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    92
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100701) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    93
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100702 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100702 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100702 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    94
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100702) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    95
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100703 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100703 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100703 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    96
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100703) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    97
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100704 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100704 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100704 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    98
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100704) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    99
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100705 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100705 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100705 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    100
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100705) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    101
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100706 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100706 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100706 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    102
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100706) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    103
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100707 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100707 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100707 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    104
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100707) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    105
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100708 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100708 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100708 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    106
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100708) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    107
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100709 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100709 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100709 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    108
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100709) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    109
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100710 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100710 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100710 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    110
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100710) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    111
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100711 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100711 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100711 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    112
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100711) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    113
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100712 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100712 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100712 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    114
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100712) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    115
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100713 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100713 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100713 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    116
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100713) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    117
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100714 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100714 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100714 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    118
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100714) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    119
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100715 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100715 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100715 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    120
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100715) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    121
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100716 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100716 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100716 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    122
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100716) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    123
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100717 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100717 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100717 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    124
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100717) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    125
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100718 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100718 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100718 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    126
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100718) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    127
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100719 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100719 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100719 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    128
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100719) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    129
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100720 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100720 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100720 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    130
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100720) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    131
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100721 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100721 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100721 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    132
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100721) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    133
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100722 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100722 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100722 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    134
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100722) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    135
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100723 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100723 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100723 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    136
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100723) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    137
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100724 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100724 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100724 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    138
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100724) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    139
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100725 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100725 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100725 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    140
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100725) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    141
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100726 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100726 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100726 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    142
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100726) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    143
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100727 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100727 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100727 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    144
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100727) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    145
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100728 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100728 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100728 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    146
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100728) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    147
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100729 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100729 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100729 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    148
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100729) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    149
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100730 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100730 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100730 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    150
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100730) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    151
SELECT e.extid, e.cat, start_date, end_date from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE ( ( DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100731 AND DATE_FORMAT(e.end_date,'%Y%m%d') >= 20100731 ) OR ( DATE_FORMAT(e.start_date,'%Y%m%d') = 20100731 ) ) AND c.published = '1' AND e.published = '1' AND approved = '1' AND recur_type = ''ORDER BY start_date,title ASC
    152
SELECT e.extid, e.cat, recur_type, recur_val, recur_until, start_date, end_date, recur_end_type, recur_count from jos_jcalpro_events AS e LEFT JOIN jos_jcalpro_categories AS c ON e.cat=c.cat_id WHERE (DATE_FORMAT(e.start_date,'%Y%m%d') <= 20100731) AND c.published = '1' AND e.published = '1' AND e.published = '1' AND approved = '1' AND recur_type <> ''  ORDER BY start_date,title ASC
    153
select * from jos_gmaps_maps order by title
    154
select * from jos_gmaps_maps order by title
    155
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (3) order by name
    156
SELECT * from jos_gmaps_icons where icon = "flower.png"
    157
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    158
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    159
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    160
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    161
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    162
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    163
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    164
SELECT * from jos_gmaps_icons where icon = "shop.png"
    165
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (4) order by name
    166
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
    167
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (11) order by name
    168
SELECT * from jos_gmaps_icons where icon = "shop.png"
    169
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    170
SELECT * from jos_gmaps_config
    171
SELECT * from jos_gmaps_icons where icon = "default.png"
    172
SELECT * from jos_gmaps_icons where icon = "shop.png"
    173
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    174
SELECT * from jos_gmaps_config
    175
SELECT * from jos_gmaps_icons where icon = "default.png"
    176
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
    177
SELECT * from jos_gmaps_icons where icon = "shop.png"
    178
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (7) order by name
    179
SELECT * from jos_gmaps_icons where icon = "bed.png"
    180
SELECT * from jos_gmaps_icons where icon = "bed.png"
    181
SELECT * from jos_gmaps_icons where icon = "bed.png"
    182
SELECT * from jos_gmaps_icons where icon = "bed.png"
    183
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    184
SELECT * from jos_gmaps_icons where icon = "bed.png"
    185
SELECT * from jos_gmaps_icons where icon = "bed.png"
    186
SELECT * from jos_gmaps_icons where icon = "bed.png"
    187
SELECT * from jos_gmaps_icons where icon = "bed.png"
    188
SELECT * from jos_gmaps_icons where icon = "bed.png"
    189
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    190
SELECT * from jos_gmaps_icons where icon = "bed.png"
    191
SELECT * from jos_gmaps_icons where icon = "bed.png"
    192
SELECT * from jos_gmaps_icons where icon = "bed.png"
    193
SELECT * from jos_gmaps_icons where icon = "bed.png"
    194
SELECT * from jos_gmaps_icons where icon = "bed.png"
    195
SELECT * from jos_gmaps_icons where icon = "bed.png"
    196
SELECT * from jos_gmaps_icons where icon = "bed.png"
    197
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (5) order by name
    198
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
    199
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (6) order by name
    200
SELECT * from jos_gmaps_icons where icon = "flower.png"
    201
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    202
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    203
SELECT * from jos_gmaps_config
    204
SELECT * from jos_gmaps_icons where icon = "default.png"
    205
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    206
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    207
SELECT * from jos_gmaps_icons where icon = "flower.png"
    208
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    209
SELECT * from jos_gmaps_icons where icon = "hiking.png"
    210
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
    211
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (8) order by name
    212
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    213
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    214
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    215
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    216
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    217
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    218
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    219
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    220
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    221
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    222
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    223
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    224
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    225
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (2) order by name
    226
SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
    227
SELECT * from jos_gmaps_icons where icon = "shop.png"
    228
SELECT * from jos_gmaps_icons where icon = "shop.png"
    229
SELECT * from jos_gmaps_icons where icon = "shop.png"
    230
SELECT * from jos_gmaps_icons where icon = "shop.png"
    231
SELECT * from jos_gmaps_icons where icon = "shop.png"
    232
SELECT * from jos_gmaps_icons where icon = "shop.png"
    233
SELECT * from jos_gmaps_icons where icon = "shop.png"
    234
SELECT * from jos_gmaps_icons where icon = "shop.png"
    235
SELECT * from jos_gmaps_icons where icon = "shop.png"
    236
SELECT * from jos_gmaps_icons where icon = "shop.png"
    237
SELECT * from jos_gmaps_icons where icon = "shop.png"
    238
SELECT * from jos_gmaps_icons where icon = "shop.png"
    239
SELECT * from jos_gmaps_icons where icon = "shop.png"
    240
SELECT * from jos_gmaps_icons where icon = "shop.png"
    241
SELECT * from jos_gmaps_icons where icon = "shop.png"
    242
SELECT * from jos_gmaps_icons where icon = "shop.png"
    243
SELECT * from jos_gmaps_icons where icon = "shop.png"
    244
SELECT * from jos_gmaps_icons where icon = "shop.png"
    245
SELECT * from jos_gmaps_icons where icon = "shop.png"
    246
select item.*, points.map_id from jos_gmaps_markers item,  jos_gmaps_points points where item.id = points.item_id  and points.map_id in (12) order by name
    247
SELECT * from jos_gmaps_icons where icon = "flower.png"
    248
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    249
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    250
SELECT * from jos_gmaps_icons where icon = "waiter.png"
    251
SELECT * from jos_gmaps_config
    252
SELECT * from jos_gmaps_icons where icon = "default.png"
    253
SELECT * from jos_gmaps_icons where icon = "bed.png"
    254
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    255
SELECT * from jos_gmaps_config
    256
SELECT * from jos_gmaps_icons where icon = "default.png"
    257
SELECT * from jos_gmaps_icons where icon = "green-marker.png"
    258
SELECT * from jos_gmaps_icons where icon = "icon_house.png"
    259
SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
    260
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Travel Tools'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
    261
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=22'
    262
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'Useful Links'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
    263
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'loginmenu'
 AND published = 1
 AND access <= 0
 ORDER BY parent, ordering
    264
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=14'
    265
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
    266
SELECT *
 FROM jos_mambots
 WHERE id = '25'
    267
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
    268
SELECT *
 FROM jos_mambots
 WHERE id = '23'
    269
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
    270
SELECT *
 FROM jos_mambots
 WHERE id = '22'
    271
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-31 13:27' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:27' )
 AND a.catid = 28
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
    272
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
    273
SELECT *
 FROM jos_mambots
 WHERE id = '25'
    274
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
    275
SELECT *
 FROM jos_mambots
 WHERE id = '23'
    276
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
    277
SELECT *
 FROM jos_mambots
 WHERE id = '22'
    278
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-31 13:27' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:27' )
 AND a.catid = 43
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
LIMIT 6
    279
SELECT a.id, a.introtext, a.fulltext , a.images, a.attribs, a.title, a.state
 FROM jos_content AS a
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 WHERE a.state = 1
 AND a.access <= 0 AND cc.access <= 0 AND s.access <= 0
 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-07-31 13:27' ) 
 AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:27' )
 AND a.catid = 42
 AND cc.published = 1
 AND s.published = 1
 ORDER BY a.ordering
LIMIT 7
    280
SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
    281
SELECT *
 FROM jos_mambots
 WHERE id = '25'
    282
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_gmaps'
 AND folder = 'content'
    283
SELECT *
 FROM jos_mambots
 WHERE id = '23'
    284
SELECT id
 FROM jos_mambots
 WHERE element = 'plugin_googlemap2'
 AND folder = 'content'
    285
SELECT *
 FROM jos_mambots
 WHERE id = '22'