SELECT *
FROM jos_session
WHERE session_id = 'h6mdoe4tdjcg0ncqbufidq35m1'
DELETE
FROM jos_session
WHERE ( time < '1282717876' )
SELECT *
FROM jos_session
WHERE session_id = 'h6mdoe4tdjcg0ncqbufidq35m1'
UPDATE `jos_session`
SET `time`='1327717876',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1327717875;s:18:\"session.timer.last\";i:1327717875;s:17:\"session.timer.now\";i:1327717875;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:8104:\"rTzbkuM2dvsprs7LbmLPiKSklnqe7LGTdTkeZ22n/MiCSEhCN29DglK3p/rfcw6uByAldarsF4+AA+DcbwCbPaQPX4aHzcPdwKUUzWG4+8AekmSBo/cPdyfeD6Jt7j6oX8m7xVe/fszMr4IVR1hx90E8LGAkSR7ujlJ20TAAlm3NRDPYkfXDXVd07MBxn8XDHf4vyR7uJK+7ikl+FqU8IvBmYfd97Pjh88gqIV9wYmvHSz48ybbLx77CXbJ7jcLD+/clP6Xvetbg2YUc2v2TaMqGD8O7tj+8V0euHu7qdicqng9C8obVCiEg/e7Xb3/66mc1ZXF7Psq6sgjaQbNadMe2CSGPbc0thav0jUj9ZH5882PJ2aBw3Jr9Dn+KjvJZDWq2Krrh3K5k767uHyDY81L0vJBu042ZyHfjfs/73AkhtWeeWXebARruryL/Xu1Gid+qkZByGHgD5RqzCd2gjOcZqjeGQlG3Jb9NtoX8qwjfmv1iuatBQv3KDL2BfovinOSLK5JfwjpF6G0uLCyo6FiJOyTBBn8Vc/w5lj3qnNSOEv6s7dgbGOTwnHBoa2cmLFpaDkrgTa4N6MgZcDlxbHrMwTTN6N0l8NSiEICnF+Ezsj2rqsvbd0wez+zFcilN52ZRMlQfCEQtyrLiMTV6dOY4PRFTQ0fn4GNq/PbpMgAv2roDOTTSYpxMt9y3rZzyX4/OYKAnYozp6Bx8jPHF7R/tjOZumgSzg4B/cxSeA8gCANi7PfNnCSopL+zR87o9cckOLsBGTNMAQ9GLTjqYJIQRtQrY6XQ1zOSsLAf5UvHhApYgEIjMJS/Av1CroSD1jpfF4HcIFbFoGwjBUr50aoNsyshniKqET9Fs2RZ2LdKAbj1cq9OPhM5BOLhtrFPga6Y6hb5iqBQ4NtPFdC4wUrr2polOga8Z6BT6inmmBHjeOOl2N01zCnzNMKfQV8xySTFlfTmo0VSBhmN0W2K+CVVqnJsaXkLZYUxKiTMh47GxTLhEdDlwbyp8Bxq7UtjT8btLCxzHogXpxRVvCDEa/FKICWZnQ4yGoPpLKZoJMnRiStFcmKEzbwgzGvx6mNEwVJcp1jORgE5MsZ4LNXTmDaFGg0e66pROz85oa0g0DQFZMDPr3sOzY521dmLypptudhb+mqedXXBFZSN4orNBPAunA6WNdrjpdWfhrzne2QVXdHYVws8rbbTpTQ88C3/NCc8uuKKzEXyUHyURUVQpp1MziUkaAsVa/6raD1AMiIJjp2ODfQ60RtY/jR0iaBsSYD09Z8BwM7NzRRhkUpw3rgawjl8PH7k4HCUdFzXUPPu2rxlmX58+qG5LLWquDUYVexJSvPeYquBvoLNjPasRv8XDl1c1ch77Pcz+gtC/8579oX6jJ9EE8L5v+8EvwZML1jGo0YQUXM1AsQzAiFJpRXHgUO+IIj/zXb7r2/NgpARcGOHfOaDeSBzJYNn3v+Sffvk9//nb3z/+M/+vHz798OuPH/M/fvgu/+7XX/747YdfDTF7lPiOFU9WCewhz5ZCRK7r23IsZC6afYvIgQv+YpRMF5YEHSsTYFzTPglQQM7k2KOd4imlbQ1ouebtQBeldhFsphhROns+siH/fOa9fMmf+MuuhRQABZ0YRexa0WBPLAdZHdvSyKZugTN3RtdCXHPSLjPHY+045JLtKi6dEmUWJUzrFbzGCeQ4MmDMnmyAal+wJh+eRAe2JA5Q4OaVaJ5yONNii0CG+KJioh6UQIex69peOiAUajM24vPIsfLNj1AOVyGHF0hSyavctsPsxD3h7gyZ9xbzNJIXEH+GarrC86zZaS64JVmEwA7LdIcA0dKvgKivqJauLbZgPj0zquT3Wmq75kqGEUHo8ZGtbBiApbn2Fs0IVUrvxJSiC6g4GyC+2cYHjCXb7TJ/ZM3I+pc7IzXFVM1o7WKwqTQKpdiqw5oCuQKqnCFvG9CnZsyF5CAnIiPlvwCs7c6nHNdj3dcgo6dgwNndKCo0H2Vq+W6UEnaO4FBswGIcgm0YOuLGTS7REzTASwn6mwOhgJbM2V7qDseBS3CfEFVguOSl2xJbcOJPzJbnppdLTTvythRDV7GXXHnAIUepoqNDDgwgDdRipw1ob0O7l2CHE2INO2v2xI2gCnQxg+xVnxkORXvSTahUdYWBIV3P91wWx3g37Akp/p+FhEkgG5yQJX6OXtxc6QXYHS4c3Ax2zoAPOWRH2ESOsE6M6wcV0/Y6I5tzj0UWJlDxJCYk6DQmE3AoKwo0pzlWbTSrDOcHzXpUkgLI86qNLFWUixOG7L6elaWKuBCoQP0+g7LzWUyX92ixnD0BkQPIdq+IHTR7iV7N7I/tSy+KcPkE/FXFTd2p1IZ1rwJGavqasOJgfBJRh+Xarvn/KmS2sCtvMtPhdVVDJa8erEPT4BMBKy+dRefmWtwgbXsgsA3SmkdBGfNMGJOpUIobmS4fmkKP+lscWT9waTAa5X6D/8zceoPLkBegXwWvLI5FW7WaFO+mzAptQKDjPStFq90QpcX0sUbZ8ucOOa5XuJ1SB3JqRemJHdwmK63xnczlUYC5QXIEAbtoIYJyB+RIeJMMUPNIg21AXiOhpTIGq7PO0tPthEGiOYlBIG9QgxzgcsqXEvxv2Z4dU9ChaOQnok/8amBUjeFhzsclDp2LGvR8XYP8SWgWqjeXn0TJ2xlvGhO+700kBbj9WKmEzulD3RFtwyQ3v5TlzvC0bpt2gJSOB2GK6JpnPloq/K8b5RUZaccG9qrYNFUVKFpH5ZsmDjyEMxMYk1OVRygknaNwGgxesFQCwYh86NsRhKgsJzEp0r/9p/rvzmi1XqVLA9QUJkHaYEF+6yn7tcRhTQ6CbT35b8AincGCaJzV167tdL0zo5LDJZX0zPLkoA/B5APza4tm4oS5x7x57KqWlUY9DI1c/cZkVQOCKUNlk+8OigiH2NYkShroSqrk9AJyQUjS+G3UmtbFZedigVb2yJ7RvW6Vd13pAaLuBw4IFjnrRGyvmYF9PvbOHoBhgwR/qGoOreUKxiobpF/GDe1eROnIjsH4CRUYYyfmyM7HbA1YzRrRjXhtB9peUw8R7PLITkxfEFwEEQ3sn2vrvXyI6vBH0wGqZvo1qLoZAn/RwVxJAKuXLE+pFupxYVuU8Os5T5yQF3MAZD7z823NcuurknxxY4uUukw7f870Djs2iIJqZLgBdmRYgaJU5cuNkzI7f69zuOQmecvJivTGitVkhTsViyniul0/JJDJEvlFA5CVbQXCrbCMXWrVhlhe8GetK7EAAgl6ItH+6rGSAuP7JO2dYGG0aKXfoahmji60FjppzWULZnGa5uVwjGwlw9AH62zkD8Fe9bsVHT69zQMS3fEFZA6rdbsnt/0eoHxhGAt+aqwb1WhIUsvacoQ1kEOBCTBd8nu1ivc0rSW7JXgSrHlxINUvYjBvBsPS+aiDXi8sG3s+AA54DMHPTK+Dabd442b9zuHaV5ts45T28spyVbKJRXoPSRtQ4aMXvts5WPPAPpDYU4uGkr2BSNqjA+ugQheQ7D/bxaBDvANvuqs7sp/5lWiunMkkogb7Q04PCEruHOZayUO1xoCM1Spbf9AOeTgdJKpf3lW+pNv4cSqgGFNWdUdG0OqaA0FLiv3eqdESC3X9qmpp3lTxupMv7ZM7YG2G8rZTMjmxapzNRpS7wVT6iB35QulRDIem2bVQSemeVTj9qrA9S4borJTHXdtWlLJYlTJTHyFZ3pXOc2HqikNT2I2eqMXggTOzHnPxXWsJfjWvzYqxV6+5jNmqToXu65YYmjEbLelW+FpkmJAD6O84CKZ3FAGKAxQidiliLPbC7bTRXT+sbSBi9bpqoeeg+pcM8O5Vy6d82GoZn7qG+oZBtr16y8Ie9GM51Q2EtRVvDlDNQiGLDVTddSqdD0SIsa8sFLIFXS1tSiJI0+IGdtb3LC1+2OAYxJ9q62SB/xlFivZXLg4rpoPHYoJnx4bh3GIaYiACJIoWAn+hVc09ESwfLhwIyXbPIcsapPZXK2Vuxl+1u0fMMS3iF3jinwmVmtu43CzFOkpnjFD+K58Mc6ZwMSJEfyoK1R0m7uHejTqzQ/UEDe4YZIF5uVdoQcSohaTI2b18aHQuU4Es6S6YWky3Sfzh+cRJqmdHupyJQx76fWC3RKP4DArriEG+61AxsNPlYyOowFsuPUoQDZRAwnx+OUe6DwjW5ToE+3ofeAnHk+DYgOcmOCyMhlBcyZo0CadQW0IRrDyqlpNTZhB6fDxIDaWOilqUAgqg6gVdEcnYJjBYqkYwmxDPi1xbkb2UI9WZgmGPm8oOXXDrpIQcpTJrAn+RdOSPZ/oFPVZdXQc00VJMmuaJC0Wxnj8q4gCxh4k0qf1SBaG6xpjnOmXZvB1kAf36aZ/1I3Ps2oakXlYpitIzUf9NSF5IPLrfWJ2vmFXd+QQ9MJ6uuWg8hG0ZVdybpIdKMDW0RTwdIR5a6qzozuw0T4/JDRXSkbLdxDslOjPryEOP5PMzbRzBWbPLA+U77+zijR+mhuJPuqg7GYksN8mjJkHFHvAvSoUtPPW+KSVjPuCRlReCCsGFiCxWQYpm4BPmg03k4qdBMjAJYmqBYGqnclSPHex9YAoHAXl/YEJucujQxTuuLciUqejpfBI44ZpXbelbSlFMmKU+ZFAUnFKsQkP9iLIEvPY2c/txegEYYRBuH4vNSVQXCmWv3iBk9v4SVeKEPRPkw07gRXTJscbufWM5ABs4PmTA3lMMllAwKCbPrC+rtvA1Anph2XNWq14jQ/F9MZmPHc5P+CCpAB/JD8ucDR2S9Y0qlkIwzA/ndDmjUHUbeCY/ca5Psb4u6DzTWKigFIJlM8ge03WG7QuLabCVfnDCS8FmOogeLDu4Pg96Njrhc4Z5JOt+JtGbQ3KZ7wg/L1KSeZgNhfGxH2o52YLamXN7OXS2/31BkkSQId37yosoXB5UAKFYu6XTKSxS8T3tOBx95wJ34s+d6HU5rS/6vXvBO7LYqNTVoCuL1NMG3UvChnLY3bmfQEJRqJ5R6DLGUyOGdrNZbeeuV/0OuoGEF3ltsxc9qIrbTzSlaQk4NLOLh0+BVY96KISYILC8gcAF0pfJGxEPGLH2Ipogsp7dcGxuo5LdXDmHzHL75mUxP3Xj5zGtVYPg/t58Y1e2jww8nuvCohtEIKV1e8GrEl8SPXEvla0BKCrOenXjrx9h+gJVTfeYh+X2/QQFSQwe+BayC0pvDIh6b9ac2BCl4XayBuvt24rl1dlJwlKSeUosnjTf2FjkfMC2Q+fatc8wxKmxiu/nSbB7P8qziDciuS46PH0eh/SkmTAr8fOs2rhVa0so5LP46KAHqQLJPOTVkqw1DtrbjV4vyuA+wWK9Iyn81sP6/MGitZPq5siMWs2AoEiGHbMGgVdDg7/3io9A7zyhkY2laEHencrfeKOuvOcpST0lWEBFWtq0ub6SH/JmrKrAa1rR0CrNImCPpk3kYSa6ahr1lWQsR7s/Kbnc/lCSy8sEUiEqVszOBMHEHkaEaIdIjmuNhY1uRzsUt/TDTZcTDOoaxD2nR9j/dNBWDeJ802rNAKkUeW9oOZqVVMWchgoQo6opxbO+xJnFyHXELfpjOTF1Ut6lbr16sXzVsrHnHm9Fqgvn5qzWqyw2P6jeasRvNONHcJWz1nuOmet0XvfAx6BPTOUXVbrxhv4SK5whVuTdvz/diYv3glUxZLhYi2rqXUnZ4/YD3m22UxdVVGVBz/cHJfFQNsMjs3wCm/prRzu0nOpvkJtae9Wp+SV7tSSaABXJwCq1uhiYqLpKJSfaYbr2RDt0pVPX+oZmaQI1Pr2hCG/10HlHrjQTMzi8QC3EGsgBBhnenuAsrYRTPYQqStXTQJIwmRpIrZU6n2n7qj2ENxVmrzBwb/yEeqnj7jHIUeeaKhuO8FPvL24WhrCgDlavaWEUL9kGvMMs4plpRwjLMHzCRwtzhAxcrB0rzOtrxYCMMiArZ9pKZlnQGLciudDGtdQTJ2VIxb8vgJXKASr0ASrVaMWjTwoxZfOYYeEfdYBQ19zTXJ1QkCYERXDaQ956zaMmZURWxLtoHCadDoN01Hc3PK44PjmZ0OcxNMJsJcPAAF4sgiWR0I54xTUjxCdZ9Ck2K8KhAlS0ZwQaWMbFaUINiZVmhLZcLR0oxh2DxIE85FS3VFOlIL13tcXaqze9Q7YeYtAeIlWXThne2Hqfk+qnbXE03pqrVfpwEkVnoxjaMzGYFC8aU/W2EyQFq9AZop8oTcNtoOQOxVOV4+uu7tCz7kisMfEntJJydgDPV+en4MFFxfoDn3MwHj6lOyvc7Ot/51NwtPWuwhKO6kaZNOvINhFDnDdLFgk5NM50FoYFodtY+c2Cq69oT8u/OYTw/pw1bIgcB+IwkuRp4Wn05+Mo3orjax9SWidKfeLwBrgeul4GSewc8l5DVmq3zCAft57JFVcNXkzdoPoZyyxq/+ZFx6CeCPoXHeDitI6TiATIBp4WuwW+Ea7sY09+0Tb/0r4wiBHGPXyNgKlD1JVFMXVhsaSaCpMe7No8OHI3aejvvJ/CX5Uv60GYJNohFt5dwa/ngJLQucVaiBfbF64DYdtxAhfHpFetM/uKDfgAXnL/rn1Dh2e+uEHJ7aup99f7+a+nvBT2VT4TR1GfcEa9RayoPm30+95coxG/M9HHDOMur4rAU6ongPZ5Sap+g6NipTBfkkWtb5zeqSCpq8IYZKtB1DtW1T/qG97HNaM9Z+h6IYm7zey4fT6rPIF65cp7fMVvrES9JUnsSx8oUUzXWT9NyfQ3XGaKPPxf+AWA/hh80brQX9B9Y76g07zpNW+UgakvDD1ulIVduQ/AOrytiV6+gHTwcZr+zo4hLl903mRHL93gbAnI5d51SqAuNHxXU5BpKz6hG9GCl2Ia1AZ0wfx13BwFk8Z2eDBp7tPxmd5+Mt08fHwBgiWZInmSYlRuSfG/ebdHabnc/qc4k+5/Ss+61EO/KEpyC7EmIJcfEoADPArVA73GgEAHZy8U9Asq9ZxTf7CSJPbbT1PqOWUP2bDExz78rB/j65gefGyotvRXD6UscWalJ5YWym1BHpx73XOztYA0cKxzcxPpvxykQAAjhXq5GQL5Py6Gj/pqzOLmD2HP84ckBAj9CALorxiC7xvtJ0kgMhHeueLHnUdelXvsW5fVi/Mv6Jkk5D25+aTYfASNfqYBTD6P5jNZod7yqmKQ4Xd05OE6ljX6Ok9n4zjvP+/+rpX/Cxh/i47vZz+1MoAOSTiwatunscvxva7SsnfJYr1ZrTbrbbrN0iTdbBfrdGX5qffKjwLLeHX4ZjN73N/5M2QI//h6bgoSs6IaUXPn5y1t/7DqAjvh292+bWVuv2ANZOC+d4YQwXX8Sma/rP46+BD6a/cs/PVV5QvlDr/vRpt2H3h/zyTDeib/+eW3f/336s5Yynrme+973CBXf09IfbsE6dZwZ4P1Op6sAnUM55AeHVb8B0uggnnDB6nuPKQT4ULpzL+8yiC8vzbxz3CBj3/797+VO5UW/6Le/r8MnytxZy521fXTfq/W5Pq18yejI0WFmYP5uPeTwccMurRIjWfu4BzY07Szw/gJySetjgRoZTjqj9WN7gLSDqkHgawjPqz1iKD9uR9b9zEtfq1hd8ELIvUQhCJvBgPksQz6XGFjhRvAtYoz6u40BIWT5BG/8vEnqZS7RxfgMX7V48B2RPt/wCuKZ+VaYN8HG1XA/6DBv+h+lPsbe+orI/129ZNx16j/EM6UesO276FCfX8+n9/jH1bLe/b0HjN34MB77fbeo4tRHsb+QbvRWpraAuj9+BHs7z3+Tcm//4f5W3Cw4Tv87hNsFFZX6i/A7Vr5Du1FG+RCvwT+Vt0+eE6NQ+xwPhkK95g4/th81B8JeI22X3bj1+aFCiSwzW/S+lj1IsSAkOQbRtN3ybuVBQHuGh8GoutVqEyy9P4+ud/cr98t0mSbbRfZNs0W2XK9vt+uN/erD04wZin4Z4Ov3lE5OjT9n/iLJZp6bE0YBfQJ99SLW0MNvfjCfbdPvLcZvOmpzV/SQJ9jseD9P61bpi5JTT9/r9zm9yAx+1fzXl9f/w8=\";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:57:\"/var/www/dev2_rak/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:17:\"application.queue\";a:1:{i:0;a:2:{s:7:\"message\";N;s:4:\"type\";s:7:\"message\";}}}'
WHERE session_id='h6mdoe4tdjcg0ncqbufidq35m1'
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 name,player_id,ripper_id,postreplace
FROM jos_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jos_avr_tags
CREATE TABLE IF NOT EXISTS `jos_ualog` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`option` varchar(255) NOT NULL,
`task` varchar(255) NOT NULL,
`action_link` text NOT NULL,
`action_title` text NOT NULL,
`item_title` varchar(255) NOT NULL,
`cdate` int(11) NOT NULL,
PRIMARY KEY (`id`))
SELECT id, title, alias
FROM jos_jumi
WHERE published = 1
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
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
SELECT *
FROM jos_rokcandy
WHERE published=1
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 1)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, parent_id, value, name, lft, rgt
FROM jos_core_acl_aro_groups
WHERE id=23
SHOW COLUMNS
FROM jos_content
SHOW COLUMNS
FROM jos_k2_items
SELECT *
FROM jos_jcomments_settings
SELECT w.*, cc.title AS category, cc.published AS cat_pub, cc.access AS cat_access
FROM jos_nohome AS w
LEFT JOIN jos_categories AS cc
ON cc.id = w.catid
WHERE w.id = 0
SELECT memberid
FROM jos_community_groups_members
WHERE groupid=16
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
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=155&id=380&lang=en&layout=item&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=161&id=384&lang=en&layout=item&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_content&Itemid=160&id=13&lang=en&layout=blog&view=section'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=286&id=69&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_myblog&Itemid=288&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=285&lang=en&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=162&lang=en&view=groups'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=350&id=96&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=175&id=25&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_suggestionsubmission&Itemid=277&lang=en&view=idea'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_suggest&Itemid=417&lang=en&view=suggest'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_chronoforms&Itemid=419&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=187&id=58&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=353&id=88&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=176&id=667&lang=en&layout=item&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=287&id=81&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=280&id=79&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=371&id=93&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=281&id=320&lang=en&layout=item&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=407&id=101&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=232&id=22&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_suggestionsubmission&Itemid=291&lang=en&view=story'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=392&id=97&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=193&id=51&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=279&id=70&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=278&id=68&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=415&id=103&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=369&id=472&lang=en&layout=item&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_community&Itemid=365&lang=en&view=profile'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_myblog&Itemid=288&lang=en'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=414&id=104&lang=en&layout=category&task=category&view=itemlist'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=register'
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-01-28 02:31:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-01-28 02:31:16' )
AND i.catid=22
ORDER BY i.created DESC
LIMIT 0, 3
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2868&lang=en&view=item'
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2868
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2868
AND user_id = 0
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='62'
ORDER BY g.id
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2867&lang=en&view=item'
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2867
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2867
AND user_id = 0
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2866&lang=en&view=item'
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2866
SELECT count(*)
FROM jos_raok_like
WHERE content_id = 2866
AND user_id = 0
SELECT *
FROM jos_k2_categories
WHERE parent=22
AND published=1
AND trash=0
AND access<=0
ORDER BY ordering
SELECT i.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams
FROM jos_k2_items AS i
LEFT JOIN jos_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND i.access <= 0
AND i.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2012-01-28 02:31:16' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2012-01-28 02:31:16' )
AND i.catid IN (22)
ORDER BY i.id DESC
LIMIT 0, 5
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2868&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2867&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2866&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2863&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=298&id=2861&lang=en&view=item'
SELECT *
FROM jos_k2_items
WHERE extra_fields_search LIKE '%2012-01-27%'
AND catid = 1
AND published = 1
AND trash = 0
ORDER BY hits
SELECT COUNT(*)
FROM jos_k2_comments
WHERE published=1
AND itemID=66
SELECT COUNT(*)
FROM jos_raok_like
WHERE content_id =66
AND user_id = 0
SELECT COUNT(*)
FROM jos_raok_like
WHERE content_id =66
SELECT COUNT(*)
FROM jos_raok_didit
WHERE content_id =66
AND user_id = 0
SELECT count(*)
FROM jos_raok_didit
WHERE content_id = 66
SELECT a.*, c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams, CHAR_LENGTH( a.fulltext ) AS readmore
FROM jos_k2_items AS a
LEFT JOIN jos_k2_categories c
ON c.id = a.catid
WHERE a.published = 1
AND a.access <= 0
AND a.trash = 0
AND c.published = 1
AND c.access <= 0
AND c.trash = 0
AND a.catid=36
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-01-28 02:31:16' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-01-28 02:31:16' )
ORDER BY a.id DESC
LIMIT 0, 15
SELECT g.*
FROM jos_core_acl_aro_groups AS g
INNER JOIN jos_core_acl_groups_aro_map AS gm
ON gm.group_id = g.id
INNER JOIN jos_core_acl_aro AS ao
ON ao.id = gm.aro_id
WHERE ao.value='63'
ORDER BY g.id
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&id=48&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&id=47&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&id=46&lang=en&view=item'
SELECT *
FROM jos_community_config
WHERE name = 'config'
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, a.`alias` AS _alias, 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'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=155&id=66&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=155&id=66&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_k2&Itemid=155&id=66&lang=en&view=item'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_suggest&Itemid=292&lang=en&view=suggest'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_suggestionsubmission&lang=en&view=idea'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=reset'
SELECT oldurl, dateadd
FROM jos_redirection
WHERE newurl = 'index.php?option=com_user&lang=en&view=remind'
