All About Long Island

Profile Information

Memory Usage

69 queries logged

1. SELECT *
     FROM jos_session
     WHERE session_id = 'd0b86028390f63165f74b3f641c1ed4f'
2. DELETE
     FROM jos_session
     WHERE ( time < '1283589727' )
3. SELECT *
     FROM jos_session
     WHERE session_id = 'd0b86028390f63165f74b3f641c1ed4f'
4. INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
     VALUES ( 'd0b86028390f63165f74b3f641c1ed4f','1283596927','','0','1','0' )
5. SELECT *
     FROM jos_components
     WHERE parent = 0
6. SELECT folder AS type, element AS name, params
     FROM jos_plugins
     WHERE published >= 1
     AND access <= 0
     ORDER BY ordering
7. SELECT m.*, c.`option` AS component
     FROM jos_menu AS m
     LEFT JOIN jos_components AS c
     ON m.componentid = c.id
     WHERE m.published = 1
     ORDER BY m.sublevel, m.parent, m.ordering
8. SELECT template
     FROM jos_templates_menu
     WHERE client_id = 0
     AND (menuid = 0 OR menuid = 1)
     ORDER BY menuid DESC
     LIMIT 0, 1
9. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
     FROM jos_content AS a
     INNER JOIN jos_content_frontpage AS f
     ON f.content_id = a.id
     LEFT JOIN jos_categories AS cc
     ON cc.id = a.catid
     LEFT JOIN jos_sections AS s
     ON s.id = a.sectionid
     LEFT JOIN jos_users AS u
     ON u.id = a.created_by
     LEFT JOIN jos_groups AS g
     ON a.access = g.id
     WHERE 1
     AND a.access <= 0
     AND a.state = 1
     AND (( cc.published = 1
     AND s.published = 1 ) OR ( a.catid = 0
     AND a.sectionid = 0 ) )
     AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-04 10:42:07' )
     AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-04 10:42:07' )
     ORDER BY  f.ordering
     LIMIT 0, 9
10. SELECT a.id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.attribs, a.urls, a.metakey, a.metadesc, a.access, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, CHAR_LENGTH( a.`fulltext` ) AS readmore, u.name AS author, u.usertype, g.name AS groups, u.email AS author_email, cc.title AS category, s.title AS section, s.ordering AS s_ordering, cc.ordering AS cc_ordering, a.ordering AS a_ordering, f.ordering AS f_ordering
      FROM jos_content AS a
      INNER JOIN jos_content_frontpage AS f
      ON f.content_id = a.id
      LEFT JOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFT JOIN jos_sections AS s
      ON s.id = a.sectionid
      LEFT JOIN jos_users AS u
      ON u.id = a.created_by
      LEFT JOIN jos_groups AS g
      ON a.access = g.id
      WHERE 1
      AND a.access <= 0
      AND a.state = 1
      AND (( cc.published = 1
      AND s.published = 1 ) OR ( a.catid = 0
      AND a.sectionid = 0 ) )
      AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-09-04 10:42:07' )
      AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-09-04 10:42:07' )
      ORDER BY  f.ordering
11. SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND ( mm.menuid = 1 OR mm.menuid = 0 )
      ORDER BY position, ordering
12. SELECT `varname`, `value`, `default`
      FROM jos_mt_config
13. SELECT l.*, cl.cat_id AS cat_id, c.cat_name AS category
     
      FROM (jos_mt_links AS l, jos_mt_cats AS c, jos_mt_cl AS cl)
     
      WHERE l.link_id = cl.link_id
      AND c.cat_id = cl.cat_id
      AND cl.main = 1
     
      AND link_published='1' && link_approved='1'
     
      AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2010-09-04 10:42:07'  )
     
      AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2010-09-04 10:42:07' )
     
      AND l.link_votes >= 1
     
      ORDER BY link_rating DESC, link_votes DESC 
     
      LIMIT 5
14. SELECT *
      FROM `jos_users` AS a
      INNER JOIN `jos_community_users` AS b
      ON a.`id` = b.`userid`
      WHERE a.`block` = '0' 
      ORDER BY a.`registerDate` DESC
      LIMIT 10
15. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid` IN (332,331,329,328,327,325,323,322,320,318)
16. SELECT *
      FROM jos_community_config
      WHERE name = 'config'
17. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='0'
18. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=profile%'
      AND `published`=1
19. SELECT id
      FROM jos_menu
      WHERE `link` = 'index.php?option=com_community&view=frontpage'
      AND `published`=1
20. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=search%'
      AND `published`=1
21. SELECT value
      FROM jos_myblog_config
      WHERE name='all'
22. SELECT value
      FROM jos_myblog_config
      WHERE name='all'
23. SELECT count(*)
      FROM jos_content AS a,jos_myblog_permalinks AS p 
      WHERE a.state=1
      AND a.publish_up < '2010-09-04 10:42:07'
      AND a.sectionid IN (1)
      AND a.id=p.contentid
24. SELECT a.*, round(r.rating_sum/r.rating_count) AS rating, r.rating_count 
                   
      FROM (jos_content AS a  )
                           
      LEFT
      OUTER JOIN jos_content_rating AS r
                                   
      ON (r.content_id=a.id)
                   
      WHERE a.state=1
      AND a.publish_up < '2010-09-04 10:42:07'
                           
      AND a.sectionid IN (1)
                            
      ORDER BY  a.created DESC,a.id DESC
      LIMIT 0,5
25. SELECT id
      FROM jos_menu
      WHERE link LIKE '%option=com_myblog%'
      AND published='1'
      AND `id`='1'
26. SELECT id
      FROM jos_menu
      WHERE (type='component' OR type='components')
      AND link='index.php?option=com_myblog'
      AND published='1'
27. SELECT permalink
      FROM jos_myblog_permalinks
      WHERE contentid='1'
28. SELECT permalink
      FROM jos_myblog_permalinks
      WHERE contentid='1'
29. SELECT username
      FROM jos_users
      WHERE id='62'
30. SELECT a. * , count( b.id ) AS counter, c.name AS username
      FROM `jos_community_groups_discuss` AS a
      INNER JOIN `jos_users` AS c
      ON a.creator = c.id
      LEFT JOIN `jos_community_wall` AS b
      ON b.contentid = a.id
      AND b.type = 'discussions'
      AND a.parentid = '0'
      INNER JOIN `jos_community_groups`AS g
      ON g.id = a.groupid
      WHERE g.published = '1' 
      GROUP BY a.id
      ORDER BY a.created DESC
      LIMIT 5
31. SELECT *
      FROM jos_mt_cats
      WHERE cat_published=1 && cat_approved=1 && cat_parent='0'
      ORDER BY cat_name ASC
32. SELECT DISTINCT(a.id)
      FROM `jos_users` AS a
      INNER JOIN `jos_session` AS b
      ON a.id=b.userid
      WHERE a.block='0'
      AND client_id != '1'
      ORDER BY b.time DESC
      LIMIT 10
33. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid`
      WHERE a.`userid` IN (332)
34. SELECT count(`session_id`) AS guest
      FROM `jos_session`
      WHERE `userid` = '0'
35. SELECT `created_by`, sum(hits) AS `hits`
      FROM jos_content
      WHERE `sectionid` IN (1)
      AND `state`='1'
      GROUP BY `created_by`
      ORDER BY `hits` DESC
      LIMIT 0,5
36. SELECT COUNT(*)
      FROM jos_content
      WHERE `created_by`='62'
      AND `sectionid` IN (1)
      AND `state` != '0'
      AND created <= '2010-09-04 10:42:07'
37. SELECT username
      FROM jos_users
      WHERE id='62'
38. SELECT name
      FROM jos_users
      WHERE id=62
39. SELECT `email`
      FROM jos_users
      WHERE id='62'
40. SELECT id
      FROM `jos_components`
      WHERE `name` = 'eWeather'
41. SELECT *
      FROM jos_components
      WHERE id = '56'
42. UPDATE `jos_components`
      SET `name`='eWeather',`link`='option=com_eweather',`menuid`='0',`parent`='0',`admin_menu_link`='option=com_eweather',`admin_menu_alt`='eWeather',`option`='com_eweather',`ordering`='0',`admin_menu_img`='../media/com_eweather/images/menu/icon-16-eweather.png',`iscore`='0',`params`='version=1.4.5\npartnerId=1125321965\npartnerKey=51706f89d56faf1a\nlocationId=USNY0973\nccCacheTime=1500\nforecastCacheTime=12600\nunits=s\nshowCurrentConditions=1\nshowForecast=1\niconStyle=default\nmoonIconStyle=moon\nforecastDays=5\nforecastDaysPerRow=5\nproviderPosition=1\nallowUserProfiles=1\nshowFooter=0\ntimeFormat=%H:%M\ndateFormatLong=%d.%m.%Y %H:%M\ndateFormatShort=%d. %b %y\ndateFormatDetail=%A %d.%m.%Y\nuseProxy=0\nproxyHost=\nproxyPort=\nuseProxyAuth=0\nproxyAuthUser=\nproxyAuthPwd=\nshow_page_title=1\nmenu_image=ext_plugin.png\nsecure=0\npage_title=Weather\npage_description=Joomla! - the dynamic portal engine and content management system\nnum_leading_articles=1\nnum_intro_articles=4\nnum_columns=2\nnum_links=4\norderby_sec=front\nmulti_column_order=1\nshow_pagination=2\nshow_pagination_results=1\nshow_feed_link=1\n\n',`enabled`='1'
      WHERE id='56'
43. SELECT id,name,params
      FROM `jos_menu`
      WHERE `link` LIKE '%option=com_eweather%'
44. SELECT *
      FROM jos_eweather_cache
      WHERE `locid` = 'USNY0973'
      AND `dataType` = 'dayf'
      AND `units` =  's'
45. SELECT *
      FROM jos_eweather_cache
      WHERE `locid` = 'USNY0973'
      AND `dataType` = 'cc'
      AND `units` =  's'
46. SELECT a.*, b.name AS groupname, b.thumb AS thumbnail
      FROM `jos_community_wall` AS a
      INNER JOIN `jos_community_groups` AS b
      ON b.id=a.contentid
      AND b.approvals='0'
      WHERE `type`='groups'
      ORDER BY a.date DESC
      LIMIT 5
47. SELECT a.id, a.comment, a.preview AS preview, a.contentid, a.date, a.user_id
      FROM jos_jomcomment AS a JOIN jos_content AS b
      ON a.contentid=b.id
      WHERE b.sectionid IN (1)
      AND b.state=1
      AND a.published=1
      AND a.OPTION='com_myblog' 
      ORDER BY date DESC
      LIMIT 0, 5
48. SELECT a.*, TO_DAYS('2010-09-04 10:42:07') -  TO_DAYS( DATE_ADD(a.`created`, INTERVAL 0 HOUR ) ) AS 'daydiff' 
      FROM jos_community_activities AS a   
      WHERE   `archived`=0
      AND (a.`access` <= 10)
      ORDER BY a.`created` DESC
      LIMIT 80
49. SELECT name
      FROM jos_plugins
      WHERE `element`='videos'
50. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='64'
51. SELECT *
      FROM jos_community_wall
      WHERE id = '7'
52. SELECT name
      FROM jos_plugins
      WHERE `element`='photos'
53. SELECT name
      FROM jos_plugins
      WHERE `element`='friends'
54. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='62'
55. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='66'
56. SELECT *
      FROM jos_community_videos
      WHERE id = '2'
57. SELECT id
      FROM jos_menu
      WHERE `link` LIKE '%option=com_community&view=videos%'
      AND `published`=1
58. SELECT *
      FROM jos_community_videos
      WHERE id = '1'
59. SELECT name
      FROM jos_plugins
      WHERE `element`='friends'
60. SELECT          a.`userid` AS _userid ,         a.`status` AS _status ,         a.`points`      AS _points,   a.`posted_on` AS _posted_on,      a.`avatar`   AS _avatar ,       a.`thumb`     AS _thumb ,  a.`invite`       AS _invite,    a.`params` AS _cparams,     a.`view`   AS _view,  a.`friendcount` AS _friendcount, s.`userid` AS _isonline, u.* 
      FROM jos_community_users AS a 
      LEFT JOIN jos_users u 
      ON u.`id`=a.`userid` 
      LEFT
      OUTER JOIN jos_session s 
      ON s.`userid`=a.`userid` 
      AND s.client_id !='1'
      WHERE a.`userid`='68'
61. SELECT name
      FROM jos_plugins
      WHERE `element`='walls'
62. SELECT *
      FROM jos_community_wall
      WHERE id = '5'
63. SELECT count(*)
      FROM jos_content AS a,jos_myblog_permalinks AS p 
      WHERE a.state=1
      AND a.publish_up < '2010-09-04 10:42:07'
      AND a.sectionid IN (1)
      AND a.id=p.contentid
64. SELECT a.*, round(r.rating_sum/r.rating_count) AS rating, r.rating_count 
                   
      FROM (jos_content AS a  )
                           
      LEFT
      OUTER JOIN jos_content_rating AS r
                                   
      ON (r.content_id=a.id)
                   
      WHERE a.state=1
      AND a.publish_up < '2010-09-04 10:42:07'
                           
      AND a.sectionid IN (1)
                            
      ORDER BY  a.created DESC,a.id DESC
      LIMIT 0,5
65. SELECT permalink
      FROM jos_myblog_permalinks
      WHERE contentid='1'
66. SELECT permalink
      FROM jos_myblog_permalinks
      WHERE contentid='1'
67. SELECT name
      FROM jos_users
      WHERE id='62'
68. SELECT m.*, sum(case when p.published=1 then 1 else 0 end) AS cnt
    
      FROM jos_menu AS m
    
      LEFT JOIN jos_menu AS p
      ON p.parent = m.id
    
      WHERE m.menutype='mainmenu'
      AND m.published='1'
      AND m.access <= '0'
    
      GROUP BY m.id
      ORDER BY m.parent, m.ordering
69. SELECT m.*
      FROM jos_menu AS m
    
      WHERE menutype='mainmenu'
      AND m.published='1'

1 legacy queries logged

1. SELECT c.*,  (SELECT count(*)   
     FROM jos_adsmanager_ads a   
     LEFT JOIN jos_adsmanager_adcat AS adcat
     ON adcat.adid = a.id   
     WHERE adcat.catid = c.id     
     AND a.published = 1  ) AS num_ads
     FROM jos_adsmanager_categories AS c
     WHERE c.published = 1
     ORDER BY c.parent,c.ordering

Language Files Loaded

• /home/aali10/public_html/language/en-GB/en-GB.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.plg_system_debug.ini 1
• /home/aali10/public_html/administrator/language/en-GB/en-GB.plg_system_cdscriptegrator.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.com_content.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.tpl_comuna3_plazza.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_mt_votedbest.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_latestmembers.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.com_community.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_myblog_latest.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_latestdiscussion.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_hellome.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_mainmenu.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_adsmanager_menu.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_mt_categories.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_onlineusers.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_myblog_blogger.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_eweather.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.com_eweather.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_latestgroupwalls.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_myblog_comments.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_activitystream.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_myblog_latestintro.ini
• /home/aali10/public_html/language/en-GB/en-GB.mod_search.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_breadcrumbs.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_login.ini 1
• /home/aali10/public_html/language/en-GB/en-GB.mod_tpmenu.ini

Untranslated Strings Diagnostic

None

Untranslated Strings Designer

None