Follow Us

RSS Feed    Follow on Twitter    Follow on Facebook    YouTube Channel    Vimeo Channel    Tumblr    SoundCloud Channel    iPhone App    iPhone App

Last Week on Jadaliyya (Nov 5-11)

This is a selection of what you might have missed on Jadaliyya last week. It also includes a list of the most read articles and videos.  Progressively, we will be featuring more content on our "Last Week on Jadaliyya" series. 

 

If you prefer, email your comments to info@jadaliyya.com.

Pages/Sections

Archive

Jad Navigation

View Full Map, Topics, and Countries »
You need to upgrade your Flash Player

Top Jadaliyya Tags

Get Adobe Flash player

Debugging Output
Pages
filecountloadqueryapptotal
Total133110951151211
/var/www/components/basicfunctions.cfc$getDynamicModule400240240
/var/www/cpanel/components/customTables.cfc$getTable_complete_specific200176176
/var/www/components/basicfunctions.cfc$getArticlesByAuthor100163163
/var/www/components/basicfunctions.cfc$getPostSummariesCategory2100112112
/var/www/components/basicfunctions.cfc$getQuotes1008080
/var/www/components/basicfunctions.cfc$getJadalicious1007171
/var/www/components/basicfunctions.cfc$getAllTopics1005757
/var/www/components/basicfunctions.cfc$getStatusItems1005555
/var/www/components/basicfunctions.cfc$getCustomHeader1005454
/var/www/components/basicfunctions.cfc$getNav1005353
/var/www/components/basicfunctions.cfc$getHeadlines1005252
/var/www/cpanel/components/charCleaner.cfc$URLFriendly17003737
/var/www/components/basicfunctions.cfc$getCategoryInfo1001818
/var/www/global.cfm101303
/var/www/dropdown_reports_posts.cfm10022
/var/www/dropdown_ar_culture_posts.cfm10022
/var/www/components/basicfunctions.cfc$getPostBrief10022
/var/www/dropdown_pedagogy_posts.cfm10022
/var/www/module_blog.cfm10022
/var/www/dropdown_syria_posts.cfm10022
/var/www/dropdown_interviews_posts.cfm10022
/var/www/dropdown_media_posts.cfm10022
/var/www/components/basicfunctions.cfc$getFullPost210022
/var/www/cached_cities_dropdown.html11001
/var/www/module_categories.cfm10011
/var/www/dropdown_profiles_posts.cfm10011
/var/www/dropdown_reviews_posts.cfm10011
/var/www/dropdown_oil_posts.cfm10011
/var/www/dropdown_ar_arabic_posts.cfm10011
/var/www/dropdown_ap_posts.cfm10011
/var/www/dropdown_roundups_posts.cfm10011
/var/www/dropdown_photography_posts.cfm10011
/var/www/dropdown_cities_posts.cfm10011
/var/www/dropdown_culture_posts.cfm10011
/var/www/module_blogarchive.cfm10011
/var/www/dropdown_dars_posts.cfm10011
/var/www/dropdown_egypt_posts.cfm10011
/var/www/dropdown_maghreb_posts.cfm10011
/var/www/dropdown_newton_posts.cfm10011
/var/www/dropdown_ar_economics_posts.cfm10011
/var/www/dropdown_cci_posts.cfm10011
/var/www/dropdown_voxpop_posts.cfm10011
/var/www/dropdown_turkey_posts.cfm10011
/var/www/headerfunctions.cfm10011
/var/www/dropdown_ar_politics_posts.cfm10011
/var/www/cpanel/components/charCleaner.cfc$cleanDescription40000
/var/www/cached_latestentries.html10000
/var/www/cached_categorylist.html10000
/var/www/cached_ar_politics_dropdown.html10000
/var/www/dropdown_palestine_posts.cfm10000
/var/www/cached_voxpop_dropdown.html10000
/var/www/module_jadalicious.cfm10000
/var/www/cached_media_dropdown.html10000
/var/www/footer.cfm10000
/var/www/cpanel/components/customTables.cfc1013900
/var/www/cpanel/components/charCleaner.cfc20000
/var/www/cached_interviews_dropdown.html10000
/var/www/latency_tracker.cfm10000
/var/www/cached_roundups_dropdown.html10000
/var/www/cached_oil_dropdown.html10000
/var/www/cpanel/global.cfm10000
/var/www/cpanel/components/imgAdmin.cfc$CheckImage70000
/var/www/cached_ar_economics_dropdown.html10000
/var/www/module_fb_popular.cfm10000
/var/www/module_boxes.cfm10000
/var/www/header.cfm10000
/var/www/cached_profiles_dropdown.html10000
/var/www/cached_syria_dropdown.html10000
/var/www/module_map.cfm10000
/var/www/cached_newton_dropdown.html10000
/var/www/cpanel/settings.cfm10000
/var/www/cached_dars_dropdown.html10000
/var/www/handler.cfm10000
/var/www/index.cfm10000
/var/www/cached_culture_dropdown.html10000
/var/www/cached_cci_dropdown.html10000
/var/www/cached_reports_dropdown.html10000
/var/www/cached_ar_culture_dropdown.html10000
/var/www/cached_maghreb_dropdown.html10000
/var/www/cached_egypt_dropdown.html10000
/var/www/cached_pedagogy_dropdown.html10000
/opt/railo/tomcat/webapps/ROOT/WEB-INF/railo/context/templates/debugging/debugging.cfm10000
/opt/railo/tomcat/webapps/ROOT/WEB-INF/railo/context/Component.cfc60000
/var/www/cpanel/components/imgAdmin.cfc20000
/var/www/cached_ap_dropdown.html10000
/var/www/cached_reviews_dropdown.html10000
/var/www/components/basicfunctions.cfc1094300
/var/www/module_tagcloud.cfm10000
/var/www/settings.cfm30000
/var/www/googleanalytics.cfm10000
/var/www/cached_ar_arabic_dropdown.html10000
/var/www/module_quote.cfm10000
/var/www/cached_archives.html10000
/var/www/cached_photography_dropdown.html10000
/var/www/cached_turkey_dropdown.html10000
Total133110951151211
filecountloadqueryapptotal
Queries
Source/var/www/global.cfm
Execution Time2
Recordcount1
SQLSELECT * FROM jadaliyya_Pages WHERE PageBase='index' AND Alive=1
Source/var/www/components/basicfunctions.cfc
Execution Time1
Recordcount1
SQL# getPostBrief SELECT p.id, p.field1 as Title, p.field4 as pageimage, left(p.field6,2000) as content, p.field8 as category1, p.field17 as tags FROM jadaliyya_DataSets p LEFT JOIN jadaliyya_Users u ON u.userid=p.createdby LEFT JOIN jadaliyya_DataSets pu on pu.id=p.field3 LEFT JOIN jadaliyya_DataSets pc on pc.id=p.field8 LEFT JOIN jadaliyya_DataSets pc2 on pc2.id=p.field9 LEFT JOIN jadaliyya_DataSets pc3 on pc3.id=p.field10 LEFT JOIN jadaliyya_DataSets pl on pl.id=p.field20 WHERE p.id=8326 AND p.field3=1 AND p.field2 <= "{ts '2016-04-30 12:55:10'}" AND p.alive=1
Source/var/www/cpanel/components/customTables.cfc
Execution Time2
Recordcount1
SQLSELECT * from jadaliyya_CustomTables WHERE TableName='Overlay Image'
Source/var/www/cpanel/components/customTables.cfc
Execution Time52
Recordcount0
SQLSELECT c.ID, c.CreatedDate, c.CreatedBy, u.UserFirstName, u.UserLastName, Field1 AS Image, Field2 AS LinkURL FROM jadaliyya_DataSets c, jadaliyya_Users u WHERE CustomTableID=124 AND u.UserID=c.CreatedBy AND c.Alive=1 ORDER BY c.createddate desc
Source/var/www/components/basicfunctions.cfc
Execution Time53
Recordcount1
SQLSELECT Field1 AS JPGImage FROM jadaliyya_DataSets c WHERE CustomTableID=8 AND c.Alive=1 ORDER BY c.listorder
Source/var/www/components/basicfunctions.cfc
Execution Time52
Recordcount4
SQL# getNav SELECT Field1 AS LinkTitle, Field2 AS LinkURL, Field3 AS Parent, Field4 AS Teaser, Field5 AS LinkClass FROM jadaliyya_DataSets c, jadaliyya_Users u WHERE CustomTableID=4 AND u.UserID=c.CreatedBy AND c.Alive=1 AND Field6=1 ORDER BY c.listorder
Source/var/www/components/basicfunctions.cfc
Execution Time56
Recordcount28
SQLSELECT id, field1 as name FROM jadaliyya_DataSets WHERE customtableid=19 and alive=1 ORDER BY listorder
Source/var/www/components/basicfunctions.cfc
Execution Time51
Recordcount11
SQLSELECT ID, Field1 AS title, Field2 as link FROM jadaliyya_DataSets c WHERE CustomTableID=13 AND c.Alive=1 ORDER BY c.listorder
Source/var/www/components/basicfunctions.cfc
Execution Time2
Recordcount1
SQL# getFullPost2 SELECT p.id, p.createddate, p.createdby, u.userfirstname, u.userlastname, p.field1 as Title, p.field2 as publishdate, pu.field1 as publishstatus, p.field3 as publishstatus_id, p.field4 as pageimage, p.field5 as pageimagecaption, p.field6 as content, p.field7 as postjumpcontent, pc.field1 as category1, p.field8 as category1_id, p.field17 as tags, p.field18 as allowcomments, p.field19 as passwordprotect, pl.field1 as languagedirection, p.field20 as languagedirection_id, p.field21 as publicpost, p.field23 as picasaurl FROM jadaliyya_DataSets p LEFT JOIN jadaliyya_Users u ON u.userid=p.createdby LEFT JOIN jadaliyya_DataSets pu on pu.id=p.field3 LEFT JOIN jadaliyya_DataSets pl on pl.id=p.field20 LEFT JOIN jadaliyya_DataSets pc on pc.id=p.field8 WHERE p.id=8326 AND p.field3=1 AND p.field2 < NOW() AND p.alive=1
Source/var/www/components/basicfunctions.cfc
Execution Time17
Recordcount1
SQLSELECT field1 as categoryname, field2 as categoryheaderimage FROM jadaliyya_DataSets WHERE customtableid=2 and alive=1 and field1='Roundups'
Source/var/www/components/basicfunctions.cfc
Execution Time163
Recordcount4
SQL# getArticlesByAuthor SELECT p.id, u.userfirstname, u.userlastname, p.field1 as Title, p.field2 AS publishdate, p.field4 as pageimage, left(p.field6,2000) as content FROM jadaliyya_DataSets p LEFT JOIN jadaliyya_Users u ON u.userid=p.createdby LEFT JOIN jadaliyya_DataSets pu on pu.id=p.field3 WHERE p.customtableid=3 AND p.alive=1 AND p.field2 < NOW() AND p.field3=1 AND p.createdby=266 AND p.id<>8326 ORDER BY p.field2 DESC
Source/var/www/components/basicfunctions.cfc
Execution Time54
Recordcount1
SQLSELECT field1 as PostTitle, field2 as PostLink, field3 as Author FROM jadaliyya_DataSets WHERE customtableid=123 and alive=1 and active=1 ORDER BY listorder
Source/var/www/components/basicfunctions.cfc
Execution Time52
Recordcount1
SQLselect id, field1, customtableid FROM jadaliyya_DataSets WHERE field1='Roundups' AND alive=1 and (customtableid = 19 or customtableid=2 or customtableid=18) order by customtableid
Source/var/www/components/basicfunctions.cfc
Execution Time58
Recordcount4
SQL# getPostSummariesCategory2 SELECT p.id, p.createddate, p.createdby, u.userfirstname, u.userlastname, p.field1 as Title, p.field2 AS publishdate, p.field4 as pageimage, p.field5 as pageimagecaption, left(p.field6,2000) as content, p.field17 as tags, p.field17 as allowcomments, pl.field1 as languagedirection, p.field20 as languagedirection_id, pc.field1 as category1, p.field8 as category1_id FROM jadaliyya_DataSets p LEFT JOIN jadaliyya_Users u ON u.userid=p.createdby LEFT JOIN jadaliyya_DataSets pu on pu.id=p.field3 LEFT JOIN jadaliyya_DataSets pl on pl.id=p.field20 LEFT JOIN jadaliyya_DataSets pc on pc.id=p.field8 WHERE p.customtableid=3 AND p.alive=1 AND p.field2 <= "{ts '2016-04-30 12:55:10'}" AND p.field3=1 AND ( p.field8=6620 OR p.field9=6620 OR p.field10=6620 OR p.field11=6620 ) AND (p.field21=1 AND p.field21=1) ORDER BY p.field2 DESC LIMIT 0,4
Source/var/www/global.cfm
Execution Time11
Recordcount0
SQLSELECT fs.field3 AS fullname, fs.field4 as emailaddress, fs.field5 as website, fs.field6 as commentcontent, fs.createddate FROM jadaliyya_FormSets fs LEFT JOIN jadaliyya_CustomForms cf ON cf.formid=fs.customformid WHERE cf.formname='Comments' AND fs.alive=1 AND fs.field1='8326' AND fs.field7='Yes' ORDER BY fs.createddate
Source/var/www/components/basicfunctions.cfc
Execution Time70
Recordcount5
SQLSELECT p.ID, p.field1 as title FROM jadaliyya_DataSets c LEFT JOIN jadaliyya_DataSets p on p.id=c.field1 WHERE c.CustomTableID=11 AND c.Alive=1 ORDER BY c.listorder
Source/var/www/components/basicfunctions.cfc
Execution Time51
Recordcount1
SQLSELECT ID, Field1 as modulename, Field2 as modulealias, Field3 as moduletitle, Field4 as modulecontent FROM jadaliyya_DataSets WHERE alive=1 AND customtableid=23 AND field2='Roundups'
Source/var/www/cpanel/components/customTables.cfc
Execution Time2
Recordcount1
SQLSELECT * from jadaliyya_CustomTables WHERE TableName='Boxes'
Source/var/www/cpanel/components/customTables.cfc
Execution Time52
Recordcount12
SQLSELECT c.ID, c.CreatedDate, c.CreatedBy, u.UserFirstName, u.UserLastName, Field1 AS Name, Field2 AS Page, Field2 AS Page_ID, Field3 AS Shape, Field3 AS Shape_ID, Field4 AS BackgroundColor, Field4 AS BackgroundColor_ID, Field5 AS TextContent, Field6 AS Artwork, Field7 AS WebLink FROM jadaliyya_DataSets c, jadaliyya_Users u WHERE CustomTableID=16 AND u.UserID=c.CreatedBy AND c.Alive=1 ORDER BY c.listorder ASC, c.ID DESC
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='2410' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1969' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='8' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1035' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='65' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='65' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='65' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='215' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1038' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='8' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1037' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='65' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount0
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='0' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='728' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='442' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='396' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time1
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1032' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount1
SQLSELECT Field1 FROM jadaliyya_DataSets WHERE ID='1036' LIMIT 0,30
Source/var/www/cpanel/components/customTables.cfc
Execution Time0
Recordcount0
SQLSELECT * FROM customdata WHERE page=''
Source/var/www/components/basicfunctions.cfc
Execution Time51
Recordcount0
SQLSELECT ID, Field1 as modulename, Field2 as modulealias, Field3 as moduletitle, Field4 as modulecontent FROM jadaliyya_DataSets WHERE alive=1 AND customtableid=23 AND field2='jlsp'
Source/var/www/components/basicfunctions.cfc
Execution Time59
Recordcount0
SQLSELECT ID, Field1 as modulename, Field2 as modulealias, Field3 as moduletitle, Field4 as modulecontent FROM jadaliyya_DataSets WHERE alive=1 AND customtableid=23 AND field2='jlo'
Source/var/www/components/basicfunctions.cfc
Execution Time78
Recordcount265
SQLSELECT ID, Field1 AS quote, Field2 as sourcetitle, Field3 as sourcelink FROM jadaliyya_DataSets c WHERE CustomTableID=14 AND c.Alive=1 ORDER BY c.listorder
Source/var/www/components/basicfunctions.cfc
Execution Time75
Recordcount1
SQLSELECT ID, Field1 as modulename, Field2 as modulealias, Field3 as moduletitle, Field4 as modulecontent FROM jadaliyya_DataSets WHERE alive=1 AND customtableid=23 AND field2='listen'