Coming. . .

Get the Flash Player to see this player.

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

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
PDF Print E-mail

HISTORIC ST. FRANCISVILLE, LA, CELEBRATES CHRISTMAS

by Anne Butler

White LightsChristmas in St. Francisville, historically the commercial center of surrounding English Louisiana cotton plantations, was always a magical time. In the 19th century, country folks from miles around would pile into wagons to do their weekly shopping in the little town’s dry-goods emporiums that offerd everything from buggies to coffins, gents’ fine furnishings and ladies’ millinery. And at Christmas time, tiny tots would press their noses against frosted storefront windows to gaze with wishful longing at elegant china dolls and wooden rocking horses. It’s still that way today.

Its location atop bluffs overlooking the Mississippi River brought St. Francisville its earliest settlers, and residents have rejoiced in its fortuitous location ever since. The historic little rivertown’s Christmas in the Country celebration on December 4, 5 and 6, pays tribute to its heritage and showcases its continuing vitality as the center of culture and commerce for the entire surrounding region.

Present residents are a whole lot livelier than the initial ones. Respected historian Elisabeth K. Dart, who has researched and written about the area for half a century, says St. Francisville’s high bluffs led Spanish Capuchin friars from the early French settlement of Pointe Coupee to ferry their dead across the Mississippi for burial on high ground safe from the floodwaters. “In the very early years of the 19th century,” writes Mrs. Dart, “an enterprising American of Anglo descent named John Hunter Johnson bought the tract of land on which the burying ground lay from its legal owner, William Williams, who had held it under a land grant from the Spanish crown since 1796.”

Recorded wills, legal documents, and early plat maps cited in a 1945 Louisiana Historical Quarterly essay on the political career of John H. Johnson’s son Isaac, who became state governor, show John H. as owning most of central St. Francisville (when he died in 1819 “he left a large estate, including all the land now the town of St. Francisville” less those lots already sold by him), and credit has traditionally been given to him along with his brother for founding the town atop the bluffs. This was an entirely separate municipality from the port settlement called Bayou Sara along the riverbanks below, founded a bit earlier by John Mills, who had been a business partner of Johnson’s father.

Gifts st francisvilleIt was John H. Johnson’s goal, according to historian Dart, “to establish a market town for the surrounding plantations even then producing cotton hauled to the Bayou Sara Landing and then barged to New Orleans for shipment to markets in Europe, and to grow rich from the sale of lots laid out on the same wooded bluffs occupied by the peaceful dead.” Although in 1810 both John H. Johnson and John Mills would help lead the revolution that ousted the inept Spanish regime, at the time Johnson established St. Francisville the area remained under Spanish rule, and the crown had strict requirements that towns be “properly chartered and laid out by the Royal Surveyor in an ordered grid of streets and squares of twelve lots measuring 60x120 feet centered by a public square.”

Johnson, says Mrs. Dart, “Anglo Protestant though he was, called his town after the Roman Catholic saint of the old burying ground, in the tongue of his Spanish overlords, La Villa de San Francisco. Thinking to please further, he called his main street after the Spanish King Ferdinand, and named other streets Royal, Florida, and Prince, crossing these with Fidelity, Prosperity, Prospect, and Feliciana. The street bordering the burying ground he called after his own family name, Johnson.” His little town was laid out atop a loessial bluffland ridge of highly erosive soil, however, and outer perimeter streets soon sloughed off into the gullies.

But lots along the central streets quickly attracted buyers and builders, and many of the little stores and residences they constructed in the very early 1800s still stand, still hosting that unique downtown combination of commercial and residential that allowed St. Francisville to retain its economic vitality long after deteriorating downtowns in other areas had been abandoned. Thanks to dedicated preservationists and an active Main Street program, downtown St. Francisville today is very much alive. And the well-established Christmas in the Country weekend, December 4, 5 and 6, gives the little town the perfect opportunity to strut its stuff.

Millions of tiny white lights trace soaring Victorian trimwork and grace gallery posts to transform the entire town into a veritable winter wonderland for Christmas in the Country, as special activities throughout the National Register-listed downtown Historic District provide fun for the whole family at this safe small-town celebration of the season which has for decades provided a joyful alternative to mall madness.   The Saturday parade this year has the theme “Homegrown and Hip,” playing on the little town’s lively and engaging present that is nonetheless firmly rooted in its historic past.

paradeBeginning at 5:30 p.m. Friday, Dec. 4, Santa Claus comes to town to kick off the Lighting Ceremony of the Town Christmas Tree, followed by a public reception and fireworks display at Town Hall hosted by jovial longtime St. Francisville Mayor Billy D'Aquilla and featuring performances by the First Baptist Church Children’s Choir and West Feliciana Middle School Choir.   The West Feliciana Parish Hospital is sponsoring a balloon release in recognition of cancer victims and survivors, with proceeds going to the American Cancer Society. From 6 to 8, visitors have the rare opportunity to glimpse beautifully decorated interiors of participating houses along Ferdinand and Royal Streets’ Peep Into Our Holiday Homes. The Baton Rouge Symphony presents its annual concert of seasonal selections and dessert reception beginning at 7 p.m. at Hemingbough (the location has been switched from Grace Church, which is undergoing ceiling repairs); tickets are available at the Bank of St. Francisville. In Grace Church’s parish hall, parishioners host an art exhibit called “Saints and Angels” all weekend, with proceeds funding mission work in Honduras.

Saturday, Dec. 5, begins with a 7:30 a.m. Community Prayer Breakfast at United Methodist Church on Royal St., followed by Breakfast with St. Nick for children at Jackson Hall next to Grace Church at 8, 9:30 and 11 a.m., sponsored by the Women’s Service League (reservations recommended; call 225-202-5403).  The Women’s Service League also sells fresh wreaths and pre-wrapped Plantation Country Cookbooks  all weekend on Ferdinand St. next to the library, with proceeds benefiting local civic and charitable activities.

Throughout the day Saturday there will be children’s activities--spacewalk and obstacle course, train and pony rides, games, pictures with Santa—plus holiday baking contest, Main Street Band (noon to 2), handmade crafts and food vendors in oak-shaded Parker Park.  There will also be entertainment in various locations throughout the downtown historic district, featuring choirs, dancers, musicians, and other performers. 
The angelic voices of the Bains Lower Elementary children's choir—Voices in Motion-- are raised at the West Feliciana Historical Society Museum on Ferdinand St. at 9:30. The Bain Elementary Chorus sings at the Methodist Church Fellowship Hall at 9:15, followed by West Feliciana High School's very popular Latin and Spanish Clubs (10:30 a.m.) and the high school choir (11).  At 11:30 on Ferdinand St. the Junior Jazzercise group puts on a lively show, followed by a Shin Sun Korean Martial Arts demonstration. From 10 to 2 the Sweet Adelines’ Lagniappe Quartet strolls and sings along Ferdinand and Royal Sts., while the Angola Inmate Traveling Band from Louisiana State Penitentiary performs in Garden Symposium Park from noon to 4.

Saturday’s highlight, of course, is the colorful 2 p.m. Christmas parade sponsored by the Women’s Service League, its grand marshall beloved town matriarch Lucille Leake, mother of its popular spring pilgrimage and founder of past Red Cross swimming programs, an energetic 96-year-old who wasn’t about to let a little thing like the loss of a leg slow her down.  Dozens of gaily decorated parade floats vie for coveted prizes, accompanied by cheerleaders, bands, marching ROTC units and dancers, even the high school football homecoming court whose own parade got rained out. There will also be bagpipes, vintage cars, and representatives of parish and town law enforcement and fire departments, all flinging plenty of candy. Santa rides resplendent in a magnificent sleigh pulled by Louisiana State Penitentiary's immense prized Percheron draft horses, groomed and gleaming in the sunlight with their sleigh bells jingling. 

On Saturday and Sunday, St. Francisville Transitory Theatre presents its quirky version of Dickens’ Christmas Carol, a hilarious localized adaptation complete with haunted plantations, nosy tourists and timely atrocities like the swine flu; performances are at 4 and 7:30 p.m. at Jackson Hall next to Grace Church. At 6 p.m. on Saturday, the Methodist Church on Royal St. hosts a Community Sing-a-long, while the First Baptist Church on US 61 at LA 10 sponsors its very popular Live Nativity reminding of the reason for the season.

christmas countryIn addition, Saturday evening from 6 to 8, visitors are welcomed for candlelight tours, period music and wassail at Audubon State Historic Site, where artist-naturalist John James Audubon tutored the daughter of plantation owners and painted many of his famous bird studies in the early 1820's. This historic home never looks lovelier than in the soft romantic glow of the candles that were its only illumination for its early years. 
Christmas in the Country activities continue on Sunday, December 6, with a Christmas Tour of Homes presented from noon to 5 by the Women’s Service League (tickets available at Historical Society Museum and at the League’s wreath sales area on Ferdinand St.).

The enthusiastic sponsors of Christmas in the Country are the downtown merchants, and the real focus of the weekend remains the St. Francisville area's marvelous little shops, which go all out, hosting Open Houses with refreshments and entertainment for shoppers while offering spectacular seasonal decorations and great gift items.  A variety of quaint little shops occupy historic structures throughout the downtown area and spread into the outlying district, each unique in its own way, and visitors should not miss a single one. 

From the rich Victoriana of The Shanty Too, for thirty years the anchor of the downtown business community and always noted for eyecatching Christmas decorations, to the jewelry beautifully crafted from vintage buttons at Grandmother's Buttons, and the extensive selections of carefully chosen gift and decorative items at Hillcrest Gardens and Sage Hill Gifts, downtown St. Francisville is filled with fine shopping opportunities.  Potter Michael Miller and artists Herschel Harrington and Joe Savell (Backwoods Gallery) have studios displaying their own works, while the St. Francisville Art & Antiques, Avondale Antiques, and the recently opened Bohemianville Antiques feature vintage collectibles and fine furnishings. Birdman Books & Coffee has an eclectic selection of books, Belle Glen Traditions has children’s toys plus sports memorabilia and gift items, and Destinee’s Clay Pot augments its florist selections with decorative items as well. Ins-N-Outs and Coyote Creek nurseries carry live seasonal plants to complement any decorating scheme. The tourist information center in the West Feliciana Historical Society on Ferdinand St. has free maps showing locations of all these retail outlets, as well as local plantations, restaurants and accommodations.

santa danceOn the outskirts of town, intrepid shoppers won't want to miss the exquisite creations at Patrick’s Fine Jewelry, the fleur-de-lis decorative pieces at Elliott’s Pharmacy and an extensive collection of the latest in electronics at Radio Shack in Spring Creek Shopping Center, as well as Border Imports with huge selections of Mexican pottery, ironwork and concrete statuary on US 61 north.  Most of the plantations in the St. Francisville area have gift shops, and a visit to those would permit enjoyment of spectacular seasonal decorations as well. The two state historic sites in the St. Francisville area, elegant 1830s Rosedown Plantation and Oakley Plantation (Audubon SHS), are decorated in period style with lots of natural greenery, fruits and nuts, and both offer living history demonstrations and other special activities most December weekends as well as daily tours except on Christmas Day. 

Located on US Highway 61 on the Mississippi River between Baton Rouge, LA, and Natchez, MS, the St. Francisville area is a year-round tourist destination, but visitors find it especially enjoyable in the winter when the glorious 19th-century gardens are filled with blooming camellias.  Six historic plantations--Rosedown and Audubon State Historic Sites, Butler Greenwood, the Myrtles, the Cottage and Greenwood--are open for daily tours, Catalpa Plantation is open by reservation and Afton Villa Gardens seasonally.   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; a modern motel has facilities to 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.

 
< Prev   Next >
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 < '1280596974' ) AND guest = 0 AND gid > 0 ) OR ( ( time < '1280596974' ) AND guest = 1 AND userid = 0 )
3 SELECT * FROM jos_session WHERE session_id = 'e820d278e47f5cada13ac900628112de'
4 SELECT session_id FROM jos_session WHERE session_id = '2a6e590e984ac34f3388a09a746c2a3d'
5 INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest` ) VALUES ( '2a6e590e984ac34f3388a09a746c2a3d','1280597874','','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 = 103 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:37' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:37' ) AND a.access <= 0
17 SELECT a.id FROM jos_content AS a WHERE a.catid = 37 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:37' ) AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:37' ) ORDER BY a.ordering
18 UPDATE jos_content SET hits = ( hits + 1 ) WHERE id = '103'
19 SELECT hits FROM jos_core_log_items WHERE time_stamp = '2010-07-31' AND item_table = '#__content' AND item_id = '103'
20 UPDATE jos_core_log_items SET hits = ( hits + 1 ) WHERE time_stamp = '2010-07-31' AND item_table = '#__content' AND item_id = '103'
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 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'
29 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=0 ORDER BY ordering
30 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1'
31 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
32 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND parent>0 AND published='1'
33 SELECT m.* FROM jos_menu AS m WHERE menutype='othermenu' AND published='1' AND access <= '0' AND parent=-1 ORDER BY ordering
34 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
35 SELECT id FROM jos_menu WHERE link = 'index.php?option=com_search' AND published = 1
36 SELECT m.* FROM jos_menu AS m WHERE menutype = 'mainmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
37 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_typed' AND published = 1
38 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=16'
39 SELECT m.* FROM jos_menu AS m WHERE menutype = 'TempDetour' AND published = 1 AND access <= 0 ORDER BY parent, ordering
40 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=38'
41 SELECT COUNT( id ) FROM jos_menu WHERE type = 'content_item_link' AND published = 1
42 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=40'
43 SELECT * FROM jos_jcalpro_config
44 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
45 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
46 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='registered'
47 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
48 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
49 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
50 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
51 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
52 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='manager'
53 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
54 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='administrator'
55 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
56 SELECT cat_id, level FROM jos_jcalpro_categories
57 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
58 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
59 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
60 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
61 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
62 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
63 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
64 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
65 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
66 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
67 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
68 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
69 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
70 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
71 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
72 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
73 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
74 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
75 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
76 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
77 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
78 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
79 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
80 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
81 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
82 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
83 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
84 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
85 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public frontend'
86 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
87 SELECT lft, rgt FROM jos_core_acl_aro_groups WHERE name='public backend'
88 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
89 SELECT name FROM jos_jcalpro_themes WHERE published= '1'
90 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
91 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
92 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
93 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
94 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
95 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
96 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
97 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
98 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
99 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
100 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
101 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
102 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
103 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
104 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
105 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
106 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
107 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
108 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
109 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
110 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
111 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
112 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
113 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
114 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
115 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
116 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
117 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
118 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
119 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
120 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
121 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
122 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
123 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
124 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
125 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
126 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
127 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
128 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
129 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
130 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
131 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
132 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
133 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
134 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
135 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
136 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
137 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
138 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
139 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
140 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
141 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
142 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
143 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
144 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
145 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
146 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
147 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
148 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
149 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
150 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
151 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
152 select * from jos_gmaps_maps order by title
153 select * from jos_gmaps_maps order by title
154 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
155 SELECT * from jos_gmaps_icons where icon = "flower.png"
156 SELECT * from jos_gmaps_icons where icon = "icon_house.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 = "shop.png"
164 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
165 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
166 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
167 SELECT * from jos_gmaps_icons where icon = "shop.png"
168 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
169 SELECT * from jos_gmaps_config
170 SELECT * from jos_gmaps_icons where icon = "default.png"
171 SELECT * from jos_gmaps_icons where icon = "shop.png"
172 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
173 SELECT * from jos_gmaps_config
174 SELECT * from jos_gmaps_icons where icon = "default.png"
175 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
176 SELECT * from jos_gmaps_icons where icon = "shop.png"
177 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
178 SELECT * from jos_gmaps_icons where icon = "bed.png"
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 = "icon_house.png"
183 SELECT * from jos_gmaps_icons where icon = "bed.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 = "icon_house.png"
189 SELECT * from jos_gmaps_icons where icon = "bed.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 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
197 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
198 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
199 SELECT * from jos_gmaps_icons where icon = "flower.png"
200 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
201 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
202 SELECT * from jos_gmaps_config
203 SELECT * from jos_gmaps_icons where icon = "default.png"
204 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
205 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
206 SELECT * from jos_gmaps_icons where icon = "flower.png"
207 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
208 SELECT * from jos_gmaps_icons where icon = "hiking.png"
209 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
210 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
211 SELECT * from jos_gmaps_icons where icon = "waiter.png"
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 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
225 SELECT * from jos_gmaps_icons where icon = "aqua-marker.png"
226 SELECT * from jos_gmaps_icons where icon = "shop.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 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
246 SELECT * from jos_gmaps_icons where icon = "flower.png"
247 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
248 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
249 SELECT * from jos_gmaps_icons where icon = "waiter.png"
250 SELECT * from jos_gmaps_config
251 SELECT * from jos_gmaps_icons where icon = "default.png"
252 SELECT * from jos_gmaps_icons where icon = "bed.png"
253 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
254 SELECT * from jos_gmaps_config
255 SELECT * from jos_gmaps_icons where icon = "default.png"
256 SELECT * from jos_gmaps_icons where icon = "green-marker.png"
257 SELECT * from jos_gmaps_icons where icon = "icon_house.png"
258 SELECT * from jos_gmaps_icons where icon = "blue-marker.png"
259 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Travel Tools' AND published = 1 AND access <= 0 ORDER BY parent, ordering
260 SELECT id FROM jos_menu WHERE type = 'content_item_link' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=22'
261 SELECT m.* FROM jos_menu AS m WHERE menutype = 'Useful Links' AND published = 1 AND access <= 0 ORDER BY parent, ordering
262 SELECT m.* FROM jos_menu AS m WHERE menutype = 'loginmenu' AND published = 1 AND access <= 0 ORDER BY parent, ordering
263 SELECT id FROM jos_menu WHERE type = 'content_typed' AND published = 1 AND link = 'index.php?option=com_content&task=view&id=14'
264 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
265 SELECT * FROM jos_mambots WHERE id = '25'
266 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
267 SELECT * FROM jos_mambots WHERE id = '23'
268 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
269 SELECT * FROM jos_mambots WHERE id = '22'
270 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:37' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:37' ) AND a.catid = 28 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering
271 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
272 SELECT * FROM jos_mambots WHERE id = '25'
273 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
274 SELECT * FROM jos_mambots WHERE id = '23'
275 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
276 SELECT * FROM jos_mambots WHERE id = '22'
277 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:37' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:37' ) AND a.catid = 43 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering LIMIT 6
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:37' ) AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-07-31 13:37' ) AND a.catid = 42 AND cc.published = 1 AND s.published = 1 ORDER BY a.ordering LIMIT 7
279 SELECT id FROM jos_mambots WHERE element = 'bot_jcalpro_latest_events' AND folder = 'content'
280 SELECT * FROM jos_mambots WHERE id = '25'
281 SELECT id FROM jos_mambots WHERE element = 'plugin_gmaps' AND folder = 'content'
282 SELECT * FROM jos_mambots WHERE id = '23'
283 SELECT id FROM jos_mambots WHERE element = 'plugin_googlemap2' AND folder = 'content'
284 SELECT * FROM jos_mambots WHERE id = '22'
285 SELECT params FROM jos_mambots WHERE element = 'mosemailcloak' AND folder = 'content'