SELECT *
FROM jos_session
WHERE session_id = 'c91b586a27028c5491f77bd3f60dadc2'
DELETE
FROM jos_session
WHERE ( time < '1337396719' )
SELECT *
FROM jos_session
WHERE session_id = 'c91b586a27028c5491f77bd3f60dadc2'
UPDATE `jos_session`
SET `time`='1337397619',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:12;s:19:\"session.timer.start\";i:1337397199;s:18:\"session.timer.last\";i:1337397570;s:17:\"session.timer.now\";i:1337397596;s:22:\"session.client.browser\";s:48:\"CCBot/1.0 (+http://www.commoncrawl.org/bot.html)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:12:\"mobilejoomla\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:5:\"cache\";s:6872:\"lTzZkuO4kf6UidoXe9fuEklJJVU/zbVrh3dm7JnZmEcEREISqng1AUpV7qh/dybOBEl1zfZLt4AEkPcFsPlj9vhZPW4f7ypxkaW4+8gfd26k4cPz2N99VI+rxzv8K8se7wbBa+ZnDo8rN6zKQYj2Kit9vvso7XDuh89Cns6ajsuGn8SxGxqu1d3HH2F0B+fJRujXXuBR+8c7LV70/Vk3Nf7ePN71fOAN4rd6/PxmRq7jcITZnxD6VzHw38zvx2zrCBDD0A0qLsGTS97zg6yllsLMFBsERpQqQyJsdRKtGGTJruLADkN3VWIwU8CFEf7NAPVW40gBy777if3406/sh69//fav7H++//H7n//2Lfvt+2/YNz//9Nsv3//siDnyumYHXj7j74dwxp3jRz901VhqJttjh1jla8QqWwNTOsBWUDy8MIBjbfcsOTsKrsdBsN5sXxkm771AWafootwvgs0MByw4kn3min26ikG/smfxeuj4UKGEM5xG9ney1bI9MRDSuaucUJoOWIL/zvMpruwiBiW7lhwPp0jFND/UQgftKTxKogKpILzFCQQ4cmDMkWyQb1CCLVPPsme8lqdWVKyW7TODMz22COSIL2suG2Ukqca+7wYdgFCa7djKTyOIQil25m1VpxxeIUmVqFnLG0EnHgh3F8h88JjnE3kB8Vc5iBrP8/ZmuRCWFBMEDgPgFRAg6vkVEPUVVc+txxbsZuBOleJea2vQwshwQlBeWLZypYClrD93rWDt2Bxw60OwWsScK8EqroXXpmy/X7Mn3o58eL1zUjNMtYx+MyPXpmajNIqdG3MDcmXZtYp1LehTOzKpBciJyAjPRLCuv14YrgeqRIuMnoMBZw+jrNF8jI2xw6g17DyBQ7EBi3EItgE3duzaMLlGF9ACLzXoLwNCAS3N+FGDIoNbOwnNBlF2DQxXogpbgjyu8l9gKmpper22tCNvK6n6mr8y4/oUQ6mih0MOKJAGanHQBrQ31R012OGMWMfOhj8LJ6gSfYvSAwgWJbBGe2qtUWaoqMCQfhBHocvzdLcClQb5f5UaJoFscEKe+CV6cXOjF2B3uFCFmR2q0ABESQ0+YIp15nw+qJi11wXZXAfeM1Th2SSop3Easwk4lJclmtMSq3aWVY7zyrIelaQE8qJqI0sN5fIiGAalRVmiV9EQoUD9PoGyi0VM1w9osYI/A5EKZHs0xCrLXqJXC/sXGyqKdPkM/M0EzBKjozOsBxMwUIkNXoM4OZ9E1GG99Wv+vwpZrPzKd5kZ8PqihmpRP3qHZsFnAjZeupicy6y4Qdr+QGCbaLonSRnzQhhTmFCKG9lRYwoD6m955oMS2mE06uMO/1mE9Q4XxUrQr1LUHseyqztLSnRTboU1INDxgVeys26I0mLB+Kg78dIjx+2KsFMeQC6drCKxKmyysRrfa6bPEswNsiII2GUHEVQEoEDC75IBap47ta4hniCvkdDKGIPX2WDp+X7GINlepJLIG9SgALie86UC/1t118AUdCgW+Znos7gaGNVgeFjycVlAZ9FFRK7f1KB4EpqFAO9WsYusRLfgTaeEHwcXSQHuONYmVw360PRE2zC7ZbfS2wWeNl3bKUjpRBKmiK5F5qOlwl/9qL8gI+vYwF4Nm+aqUnXlaHzTzIGncG4CY3Ju8giDZHAUQYPBC1ZGIBiRT0M3ghCN5WQuRfqP/zZ/7pxW21W2JkBN4RqkDRYUt56z30oc1jAQbBfJ/x1Y5AtYEI3z+tp3vS10FlRS3VLJyKxIDvoQTD4wv/ZoZkGYR8ybx77ueOXUw9EozG9MVi0gmDKUNOxwMkQExPYuUbJAX0iVgl5ALghJmngftbYLcTm4WKCVP/EXdK974103doCo+0kAgiXjvZzaa+FgX85DsAdgmNLgD03NYbXcwHhlg/TLuaHDq6wC2VMwcUEFxtiJOXLwMXsH1vBW9mMN2Stoe0P9crLLE79wKFxlr2+CyBb2Z9Z6bx8CjJ1NJ6i66bek3OYI/NkGcyMBrF4KllMttOOS2WCPv15YFoS8WgIg80Wc7xrOvK/K2OqdLXLqMv38tbA7HLjCgjZqZLoBZDDgKFCUrvL94kmFn3+wOVz2Lnnr2Yr8nRWb2YpwKhZTxHWHRkgikzXyiwYgL9sahFtjGbu2qg2xvBQvVlemAkgkGIlE+2vGWkuM77O0d4aF0yJTHZdn08WxhdbKJq1Md2AWl3l0hGN0pzmGPljnI38K9mY45MJntHlAoj+/gsxhte3zMN/oAcpXjrHgp8amNY2GLPesrUZYAzkUmAC3JX9Uq+merqfktwRPgjUvDuRmAGulBgzL5qMBervybByEAhzwGIKfm94m02HxLszGndO1bz7Zxinr5Y3lmmQTi/QBkjagIkavx7un/uTNA36d5JFaNJTsLUTSAR1YDxW6hGT/xS8GHRI9eNND05P93K/McuVKJhE12B9yekBQi+Awt0YepicGZGw2xfajdcjqctKofqyvY0m3i+NUQFNMed2fOUGrb08ELS2Px6BGayzUT6bvZhj1gLl7r1+753DA1g2xrjcyufB6XMxGjLvBVPoMiIDCGOgJHJpm30ElZXtW6fSbwfaqOaJjuoAocNuKMhZrUmbqIzRnfRU8F6auODSH3dmJRqoIXLj1mIsfOk+wLVeUKMdB6tdgtqZTYbJ2KAIgNGM2WtGtzlr3akYOoH8QIJghUAQoKihE/FLEWB5l2Glnu35Y20DEGmzVQs9B9a844D2Ylk/1uLcyvvQt9Q1KdwMYgrGAlXcOuLYW7QmqWShksXNqu05V8IEIMQ61h0K2oKulTUkEaTvcwM/GnqXHDxscSv7LbJ2t8I9TpMn+xsVhxXSKWMzw7LlS1w7TEAeRIFF2EPhLq2pCYystoLNwICTbg4AsS2nn/3Yfo7/qDk+YY3rEb/Dk3DUiIvxml7ulWEfZjBHKf+OTYc4VLk6E6E9labrDxD08hNFgdqieoME9hyyQVUeDFkSMRmqKnN8rhsbgMg3Imu6CqcV8mywezmZOEk3KlTPTkId+H9it0Sg+gcIGYpDvNlQofrl97AQq8ZbriBJEAyOQNJ9fL5EeA4J3uQHBoTkmXiLwJDk24bkLDiunIRRXsibP0inUllQEm4iq5+ScGYSeGA9yR2mgopGVhAKofkVXRDK2GQyWqhOYXYrnTa5tyF7GkVpLcewJU8WpT66bjJAnqcyWwN8kHfkTmX5Dj01XNwDNtBSTpmXiUlFsl4+acIDYw0ya1H6pglBd4zxynbJs2Q6KhP5KDuBIvB9ZYtc+JfW2SlGUXoj671LyUuLR/U7V+Qtm1fQxQU+Mp29vGg9hW0EV913SUyWYG9pqOj1BPLXURdFd+WWZHpcbGqQnyvYu3jnRmUVHnnqkmJ9Z40jOWlyeKN/14Bfv4jA1lHjSTd0pSGR5lzxqElTsCf8mqbCHp943p2QsBzyy8kZQIbgQkU1VkKKZ+ITlYDNx8fMgmZgEMbVEME1QOarHAfYhMYWThLw/MaEwqXp08YFrKzLlKno6nyVOuBF1V8WW0iQmLFKfMmgSnHKsQlP9mGQJeO3t5o7j/AJwgkG6/VRsQaK2UKgG8/ig8PeXqBIX7JkgHw4SL6IrgTX2EBvLCZgS+IIBe09TsIyCQTF55UNVd2WsEdAL60HwxvQaOYrvs8t8/DC7lB1kwuAjxWnNuOqRrL+YYikFw/xwSZcLCtV0iWeKE9fmMtXXFZ3nFgsTlFKwYgHZc74tsH3hMU22si9NRCX5QgcxghWn0OdBz0YnYs6wjGQzLCR6S0iu2YHw8yYlRYTZUZgY+6GW0x2onTt30Kr3/e8bkiSCTOk+1lFE6fKkAkjF2q+DTmGRynvWj+ocOxe4k3jp5WDLaXvRH90L3pFNjcpcDYayyDxtsL0kbCin3Z2HGSQUheYZhS1jIjVSdbvdZr90vRp3sA0kvMjr2qMcQFXCfrKtXEsgoFncPHwObHrUqpRyhsD6HQRukL7OfifiCSO2UUQzRLaLG47t+6gU765cQma9/93Lpvy0jZ+nvDENggfju3boqJ84eLzQhUU3iEBG645S1BW+JHoWUSp7B1DWgg/mxr80txKxQDXTA+ZhzL+foCCZwwNyNeArLb0xINq9eXvhapKG+8kGrHfoas7qa5CEp6SIlHg8ab6x88jFgO2Hrk1on2GIM2O1OC6T4Pd+0lc53Yjkuujw7HkC0pN2xqwszvN6F1ZtPaGQz+KjgwGkCiSLlFdrstY56Gg3dr2skvsEj/WBpPD7CBvzB4/WQZubIzfqNQOCIhkOzFISr4ZUvPeaHoHeeUYjHyvZgbx7k7+J1lx5L1OSR0qwgJpoadsxeyWvWDvWdeI1vWholeYR8EfTJrJaiK6WRnslOZWj35+UXGF/KMn1bQKpEA0rFmeSYOIPI0L0QyTH9cbCx7CjH5q29NNN1zMMmgbEvaRH2P8M0F4Npvmm1xoFqRR5b+g5WlRUxYKGShCjqSnli73EWcQodMQ9+mM1M3VS3uVhvawqvF/5gmVjz326FakugpvzWm+yWHYyvdUJv9GMn8BVLlrvdcrcoPO2Bz4mfWIqv0mlO90wXmKlM8SKovuPpwdxiUHyegqZLraimntXUvaE/YB3u/3cRZV1VdLz40HZdKhY4JFbPoPN47WjH1rP9TfJTb292tT8lr16El2AmsjAK7W5GJipukklZ9rhuvZEO2yl0zT2hmbtAjU+vaEI7+3Q9UCuNDM3qF6hFuIt5ABKp7cnOEsr4dwOoYpS9XSQJEzmDtJqpc1nuqHuTulNhdsrDdy7OGFe6oR7DHLUtaHKhiPiMsSLm5UjLKmDzWtaGMVLNoV3mOV0Zt4RwjIMn/DRwhwhExfrx0r3+towoKAMKKqFtpJbljTGvUhutHE99cRJOVKfQFuwUjlBha6gUp2seIpJIaZsETMs/CcdINS18DTXJhSkCUERnPeQ91HzqEk5kZXTXSwOs06HQ3rSd3c8rgU+OZnRFzF0wuw0x8AAXmwCSyKhH4mK60aIT/LoU2w2hEMlqOjACTSwTMjLjBoSK90Ibbl6OlCMBw6JA3nIaW6p5kpBeu9mi21Ub3qH7D2Esh4iN5dOBd7YRp+T26dt02i8d1er9OEkis5HMbRnYjA5XjTm5m0nSApWoTNEP1G5hpui5KryuWb4uqs/Dbw/E2vM4gmdppxV4PkadkkeXNR8OIklBxPhc7qzwc2//g8+BUe76Co84ahulEmLjmw3YUjwZtkqI4dOM52VY0HqNjZxs+Tqa7Kn598SQnh/zluuJo4DcRhJ8rSKNMbzcRRvxfG1DymtM6M+0/AGuJ76QSdJ7BLyUUM2ZrfCIT9tPZMrrga8mLlBjTOeWdT+3YsOZZ4IxhcdeeZ0nEQkQDbxtNgtiI1wYx9H8ou2+df+hcEUYdwj1giYOky6siimPi2WTFNh1oPdugdH4SYN/V30U/irjmU9CJNEO8Qiuiv49ZJQkjq3qRbixfaN60DYdpzBTWPSm9WZY80VPoDXIr5r39HhhS9uUHLHeu797X7x66kohWPNFuIo6hPOmLeINdWnnX3fyywa03cm9hg1HlhdJp7SPAH0z0ty8xscFa+k+4Rs0vrG6YMJkrYqnILsLYh5x2r6R0MrhmnN6M9R/SA1cbeFH/fPZ40nMK9cxYCv+J2VmLckmX/pAyWK6zrbpymF/YbLTZGH/6u4ANAfOTZZqvTTub+4T+csbwbLG2Ng5tPCiBtlYV8dE7Aeb2smL19AOvg4zX5gxxGXzzZv8qO3bnD2BOR27zonUDcavps5yLwVn9GNaMFLMU1qA7pg+TpuiYJZYzs9mDT36fhCbz+bb54+vgDBkkyRPElxKrem+L97t0dpud3+pziT7n9Oz7rVQ78pSnILsSUgtx8SgAM8S9MD/RIDEh1cvFCwL6jMc077wUqW+W8/XakXlD1lwxof+4irfYxvY3rysaHZMl49VLrCmY2dWHuosAV5cB51L8w2EtLAsWHuJjJ+OUiBAEZL83IzBTIe33wbio/6Gszilg/hL8uHZAQI/QgC2K8Yku8b/SdJIDKZ3rnix51nUVdH7FtX9WvwLxhVGz5ofYk+ZmU8XBh2kPi29iz71GW1x3LmsnC9hlSKuc+T3QfVBhyI+zS6L2+leR5s6kuOn+aRt/BYKdkbQpvg47zzpGAi33T6/4AJX6Mv/SFObRxgoBsOrLvueewZPgE2ivthtdmss91+u8tXq+2u2OyLh42XkN2KnSU2BszZu93iaX8UL5Bz/OnPS1OQ6pX1iLawPO9J+5NXQNgJXwMPXaeZ/yY2kWr4dBqCjrBu6WHxI+0/h6flb28m56gO+HE4+oXwdfh3XHOsidgPr7/88383d87atgsfiz/gBhCGe/f9E6Rs6s4H/O10sk5UOp1DCmxoih89gRqzViht7k10kNnKKMk/o44gfLx6iU95gXN/+M8/VAeTWv9kvh94VZ9qeefRLwzAuVP6H+AD5Avlao7SfkFNfLW9F/tl/t59Zmnfaf7o7AMlA67bqBgsvMcnifeYnWpe9/f9eKhBDOhT7jFdla26t7Z+j0ZgbOD+zm4+emUwrgwo+PZbUJH77MPqqz/+F3auHu/vr9frB/zYEdQIVtcfuuF0f+j0BzzA6szKPn/92rTc7X8egOIYZybxoyP1iNnS39pv7cv4KAL/OTN+Yl0a7wnb/KK9YzHPIBwIyThhNP+Qfdh4EGCyszLIGgcTH7KieCj2D9l+/6HYFJv1ard/KLb7Yrd+2G62uTG4gq4En+TQtRsaU0RV/bt49TRTl2LpooAxyZy7Ga9YqZtZhW/ViXtxg++6Eulc3UPEQgx/9Y6DmpCZfvnOGPZ3IDDz30OsYfXb278B\";s:6:\"markup\";s:0:\"\";}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:66:\"/home/digitalp/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:19:\"com_mailto.formtime\";i:1337397304;s:13:\"session.token\";s:32:\"7f1345b3b7f44cd5590fc31cb9d55725\";}'
WHERE session_id='c91b586a27028c5491f77bd3f60dadc2'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT id, url_sef, url_real, blocked
FROM jos_acesef_urls
WHERE published = '1'
AND url_sef = 'services/market-research-services.html'
ORDER BY used DESC
SELECT *
FROM jos_acesef_urls
WHERE url_real ='index.php?option=com_content&catid=39&id=61'
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
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 = 61
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-05-19 03:20:19' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 03:20:19' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='61'
SELECT rewrite_rule, component_prefix, component, skip_title
FROM jos_acesef_routers
SELECT extension, params
FROM jos_acesef_extensions
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =61
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=39&id=61'
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =61
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=39&format=pdf&id=61&view=article'
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =61
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=39&id=61&layout=default&page=&print=1&tmpl=component&view=article'
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =61
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =39
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=39&id=61'
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_mailto&link=aHR0cDovL3d3dy5kaWdpdGFscGF0aG9sb2d5Y29uc3VsdGFudHMuY29tL3NlcnZpY2VzL21hcmtldC1yZXNlYXJjaC1zZXJ2aWNlcy5odG1s&tmpl=component'
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 = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT catid
FROM jos_content
WHERE id =54
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =54
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =44
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =44
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=44&id=54&view=article'
SELECT catid
FROM jos_content
WHERE id =53
SELECT title, alias, catid, introtext, id
FROM jos_content
WHERE id =53
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =35
SELECT title, alias, section, description, id
FROM jos_categories
WHERE id =35
SELECT id, url_sef, blocked
FROM jos_acesef_urls
WHERE url_real='index.php?option=com_content&catid=35&id=53&view=article'
