•Información del perfil• Application afterLoad: 0.000 seconds, 0.40 MB Application afterInitialise: 0.143 seconds, 10.36 MB Application afterRoute: 0.206 seconds, 14.98 MB Application afterDispatch: 0.694 seconds, 27.44 MB Application afterRender: 1.732 seconds, 49.55 MB •Uso de la memoria• 52371784 •343 consultas en la lista.• 1. SELECT * FROM jos_session WHERE session_id = 'ac66d126fa4ba4d5319a0536363722e4' 2. DELETE FROM jos_session WHERE ( time < '1298967186' ) 3. SELECT * FROM jos_session WHERE session_id = 'ac66d126fa4ba4d5319a0536363722e4' 4. UPDATE `jos_session` SET `time`='1299075186',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:62;s:19:\"session.timer.start\";i:1299059417;s:18:\"session.timer.last\";i:1299074809;s:17:\"session.timer.now\";i:1299074830;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; fr; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 ( .NET CLR 3.5.30729)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{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:75:\"/home/vedouze2/public_html/testtemp/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:16:\"duplicate_review\";b:0;}s:17:\"rsfirewall_config\";O:8:\"stdClass\":36:{s:15:\"master_password\";s:0:\"\";s:23:\"master_password_enabled\";s:1:\"0\";s:13:\"blacklist_ips\";s:0:\"\";s:21:\"active_scanner_status\";s:1:\"1\";s:10:\"verify_sql\";s:1:\"1\";s:9:\"verify_js\";s:1:\"1\";s:15:\"verify_sql_skip\";a:0:{}s:14:\"verify_js_skip\";a:0:{}s:13:\"verify_upload\";s:1:\"1\";s:18:\"verify_upload_skip\";a:0:{}s:28:\"verify_upload_blacklist_exts\";s:32:\"php\r\njs\r\nexe\r\ncom\r\nbat\r\ncmd\r\nmp3\";s:12:\"monitor_core\";s:1:\"1\";s:13:\"monitor_files\";s:0:\"\";s:13:\"monitor_users\";a:0:{}s:30:\"backend_access_control_enabled\";s:1:\"0\";s:20:\"backend_access_users\";a:0:{}s:25:\"backend_access_components\";a:0:{}s:24:\"backend_password_enabled\";s:1:\"0\";s:16:\"backend_password\";s:0:\"\";s:21:\"backend_whitelist_ips\";s:0:\"\";s:10:\"log_emails\";s:18:\"fred@ibericity.com\";s:15:\"log_alert_level\";s:6:\"medium\";s:11:\"log_history\";s:2:\"30\";s:12:\"log_overview\";s:1:\"5\";s:8:\"lockdown\";s:1:\"0\";s:10:\"verify_dos\";s:1:\"1\";s:13:\"verify_agents\";s:1:\"1\";s:20:\"verify_multiple_exts\";s:1:\"1\";s:10:\"verify_php\";s:1:\"1\";s:15:\"verify_php_skip\";a:0:{}s:20:\"global_register_code\";s:20:\"3CTQX46HR9KZTNI1V1H9\";s:16:\"verify_generator\";s:1:\"1\";s:5:\"grade\";s:2:\"76\";s:13:\"verify_emails\";s:1:\"0\";s:6:\"offset\";s:3:\"300\";s:15:\"backend_captcha\";s:1:\"3\";}s:13:\"session.token\";s:32:\"ce739e3fbb82e4f212373effc062b881\";}__com_jreviews|a:13:{s:14:\"module_rand390\";i:1947990432;s:16:\"module_params390\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:7:\"reviews\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:6:\"medium\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"180\";s:12:\"module_limit\";s:1:\"1\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"140\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"390\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"a41c285b9fc1ca39c65dbb1ffed69f85\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1947990432;}s:14:\"module_rand378\";i:1876888232;s:16:\"module_params378\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:6:\"random\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:0:\"\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"250\";s:13:\"slider_height\";s:3:\"300\";s:12:\"module_limit\";s:1:\"1\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"3\";s:7:\"section\";s:2:\"26\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"150\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"378\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"c18be4f687d91156a235a993d1940bbb\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1876888232;}s:14:\"module_rand132\";i:1171944968;s:16:\"module_params132\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:5:\"rdate\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:0:\"\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"250\";s:13:\"slider_height\";s:3:\"500\";s:12:\"module_limit\";s:1:\"3\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:5:\"scale\";s:8:\"tn_width\";s:2:\"40\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:1:\"4\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"132\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"032d3b765bd3dbf00445258ab15b8d20\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1171944968;}s:14:\"module_rand524\";i:1859258598;s:16:\"module_params524\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:27:{s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"600\";s:13:\"listing_order\";s:6:\"rating\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"promo\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"module_limit\";s:2:\"10\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:5:\"scale\";s:8:\"tn_width\";s:2:\"60\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"1\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"524\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"654cd106e1f5d1cee73c271c2929cacb\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1859258598;}s:14:\"module_rand525\";i:536737893;s:16:\"module_params525\";a:12:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:14:\"module_reviews\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:24:{s:13:\"reviews_order\";s:7:\"helpful\";s:12:\"reviews_type\";s:3:\"all\";s:9:\"extension\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"color\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:4:\"side\";s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"150\";s:12:\"module_limit\";s:1:\"5\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"100\";s:10:\"link_title\";s:15:\"{listing_title}\";s:13:\"show_comments\";s:1:\"1\";s:12:\"show_numbers\";s:1:\"1\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"525\";s:4:\"page\";i:1;s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:536737893;}s:14:\"module_rand181\";i:1553498653;s:16:\"module_params181\";a:12:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:14:\"module_reviews\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:24:{s:13:\"reviews_order\";s:6:\"latest\";s:12:\"reviews_type\";s:3:\"all\";s:9:\"extension\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"color\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:4:\"side\";s:12:\"slider_width\";s:3:\"600\";s:13:\"slider_height\";s:3:\"100\";s:12:\"module_limit\";s:1:\"9\";s:7:\"columns\";s:1:\"3\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:2:\"50\";s:10:\"link_title\";s:17:\"{review_title 35}\";s:13:\"show_comments\";s:1:\"1\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"181\";s:4:\"page\";i:1;s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1553498653;}s:7:\"__Token\";a:1:{s:4:\"Keys\";a:3:{i:0;s:32:\"240d347a47bd06598ea2745177cb5241\";i:1;s:32:\"3baf5c2ecab1ed134d501c97084b40d1\";i:2;s:32:\"1a0be51e432e4e79eee9b610d570023d\";}}}' WHERE session_id='ac66d126fa4ba4d5319a0536363722e4' 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 * FROM jos_sef_config WHERE id = '1' 8. SELECT * FROM jos_sef_alias WHERE published='1' 9. SELECT id, link FROM jos_menu WHERE home=1 AND published=1 10. SELECT `configuration` FROM `jos_ak_profiles` WHERE `id` = '1' 11. SELECT * FROM `jos_rsfirewall_configuration` 12. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='1.5.22' 13. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='1.5.22' 14. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='protect' 15. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='protect' 16. SELECT * FROM jos_sef_redirect WHERE source='accesorios/diversos/antifaz-relajante-grande-y-peque%c3%b1o-de-the-body-shop-200801315080/' AND published='1' LIMIT 1 17. SELECT id, link FROM jos_menu WHERE alias = 'accesorios' AND published=1 18. SELECT id FROM jos_components WHERE link='option=com_accesorios' ORDER BY id DESC 19. SELECT id FROM jos_menu WHERE alias='accesorios' AND published=1 20. SELECT id FROM jos_menu WHERE alias='diversos' AND published=1 AND parent=132 21. SELECT count(id) FROM jos_sections WHERE title='accesorios' 22. SELECT id, catid, sectionid FROM jos_content WHERE id='5080' AND (state > 0 OR state = -1) 23. SELECT id, link FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=5080' ORDER BY id 24. SELECT id FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=category%&id=976' ORDER BY id 25. SELECT id FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=section%&id=16' ORDER BY id 26. SELECT * FROM jos_autotweet_automator WHERE id = 'automator' 27. UPDATE `jos_autotweet_automator` SET `lastexec`='2011-03-02 14:13:06' WHERE id='automator' 28. SELECT c.`id` AS id, c.`name` AS name, c.`autopublish` AS autopublish, c.`description` AS description, t.`name` AS type, t.`max_chars` AS max_chars, c.`id_1` AS id_1, c.`id_1_secret` AS id_1_secret, c.`id_2` AS id_2, c.`id_2_secret` AS id_2_secret, c.`selection` AS selection, c.`other` AS other, c.`use_own_api` AS use_own_api, c.`api_key` AS api_key, c.`api_secret` AS api_secret, c.`api_authurl` AS api_authurl, c.`api_other` AS api_other FROM `jos_autotweet_channel` c, `jos_autotweet_channeltype` t WHERE c.`published` = 1 AND c.`channeltype_id` = t.`id` 29. SELECT * FROM `jos_autotweet_queue` WHERE `publish_up` <= '2011-03-02 14:13:06' LIMIT 3 30. SELECT template FROM jos_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 149) ORDER BY menuid DESC LIMIT 0, 1 31. SELECT m.* 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 = 149 OR mm.menuid = 0 ) ORDER BY m.position, m.ordering 32. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 33. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 AND id='102' 34. SELECT * FROM jos_kunena_config 35. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos' AND published=1 AND id='329' 36. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 37. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 38. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 AND id='102' 39. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos' AND published=1 AND id='329' 40. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 41. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 42. SELECT created FROM jos_content a ORDER BY created DESC LIMIT 1 43. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 44. SELECT id FROM jos_menu WHERE link LIKE "%com_community&view=profile%" AND published = 1 AND type = "component" 45. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved` FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) ORDER BY Review.vote_helpful DESC, `Rating.average_rating` DESC LIMIT 5 46. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id LEFT JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.id IN (2716,3214,2390,3238,2601) ) 47. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 48. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (2390,2601,2716,3214,3238) GROUP BY listing_id 49. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (154,160,159) ) 50. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,163,168,169,172,178,180,185,200,204,220,535,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4) AND type = 'content' 51. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,17,18,19,161,163,168,169,172,177,178,180,183,185,187,189,200,204,218,220,222,534,535,537) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 52. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 53. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 54. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 81 ORDER BY ordering ASC ,optionid ASC 55. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 82 ORDER BY ordering ASC ,optionid ASC 56. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 83 ORDER BY ordering ASC ,optionid ASC 57. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 225 ORDER BY ordering ASC ,optionid ASC 58. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 227 ORDER BY ordering ASC ,optionid ASC 59. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 232 ORDER BY ordering ASC ,optionid ASC 60. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 233 ORDER BY ordering ASC ,optionid ASC 61. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 236 ORDER BY ordering ASC ,optionid ASC 62. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 241 ORDER BY ordering ASC ,optionid ASC 63. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 242 ORDER BY ordering ASC ,optionid ASC 64. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 244 ORDER BY ordering ASC ,optionid ASC 65. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 247 ORDER BY ordering ASC ,optionid ASC 66. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 249 ORDER BY ordering ASC ,optionid ASC 67. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 251 ORDER BY ordering ASC ,optionid ASC 68. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 253 ORDER BY ordering ASC ,optionid ASC 69. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 264 ORDER BY ordering ASC ,optionid ASC 70. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 268 ORDER BY ordering ASC ,optionid ASC 71. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 282 ORDER BY ordering ASC ,optionid ASC 72. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 284 ORDER BY ordering ASC ,optionid ASC 73. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 286 ORDER BY ordering ASC ,optionid ASC 74. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 624 ORDER BY ordering ASC ,optionid ASC 75. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 622 ORDER BY ordering ASC ,optionid ASC 76. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 77. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_presentacin,jr_textura,jr_tiposdepiel,jr_aclaradofac,jr_antiarrugasfac,jr_antibolsas,jr_antiojeras,jr_biofac,jr_contornodeojo,jr_corrector,jr_efectolifting,jr_exfoliantefac,jr_hidratantefac,jr_iluminador,jr_limpiadorfac,jr_ojosylabios,jr_proteccinpolucin,jr_sinjabnfac,jr_sinperfumefac,jr_todotipodemaquillaje,jr_proteccionuvfac,jr_reafirmantefac,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (2390,2601,2716,3214,3238) 78. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (241,639,443,251,568) ) 79. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (160,159,154) ) 80. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,163,168,169,172,178,180,185,200,204,220,535,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4) AND type = 'review' 81. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (4) AND `Group`.type = 'review' ) WHERE FIELD.location = 'review' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 82. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 21 ORDER BY ordering ASC ,optionid ASC 83. SELECT Review.reviewid AS element_id,jr_puntospositivos,jr_puntosnegativos,jr_recomendacion,jr_otro FROM jos_jreviews_review_fields AS Review WHERE Review.reviewid IN (3959,3621,3425,3691,3550) 84. SELECT COUNT(DISTINCT Review.id) FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) 85. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2716' 86. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2716' 87. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=241' AND published=1 AND id='113' 88. SELECT * FROM jos_community_config WHERE name = 'config' 89. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='241' 90. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3214' 91. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3214' 92. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=639' AND published=1 AND id='113' 93. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='639' 94. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2390' 95. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2390' 96. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=443' AND published=1 AND id='113' 97. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='443' 98. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3238' 99. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3238' 100. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=251' AND published=1 AND id='113' 101. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='251' 102. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2601' 103. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2601' 104. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=568' AND published=1 AND id='113' 105. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='568' 106. SELECT DISTINCT g2.id FROM jos_core_acl_aro AS o INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id=o.id INNER JOIN jos_core_acl_aro_groups AS g1 ON g1.id = gm.group_id INNER JOIN jos_core_acl_aro_groups AS g2 ON (g2.lft <= g1.lft AND g2.rgt >= g1.rgt) WHERE (o.section_value='users' AND o.value='0') 107. SELECT c.* FROM jos_kunena_categories AS c 108. SELECT c.id FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.memberid='0' 109. SELECT COUNT(DISTINCT t.thread) FROM jos_kunena_messages AS t INNER JOIN jos_kunena_messages AS m ON m.id=t.thread WHERE m.moved='0' AND m.hold IN (0) AND m.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND t.hold IN (0) AND t.moved=0 AND t.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND m.catid NOT IN (10) AND t.time>'1267539187' 110. SELECT m.id, MAX(t.id) AS lastid FROM jos_kunena_messages AS t INNER JOIN jos_kunena_messages AS m ON m.id=t.thread WHERE m.moved='0' AND m.hold IN (0) AND m.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND t.hold IN (0) AND t.moved='0' AND t.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND m.catid NOT IN (10) AND t.time>'1267539187' GROUP BY t.thread ORDER BY lastid DESC LIMIT 0, 5 111. SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments, l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx FROM ( SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL AND f.userid='0') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount, COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='0', m.id, NULL)) AS mycount, MAX(m.id) AS lastid, MAX(IF(m.userid='0', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime FROM jos_kunena_messages AS m LEFT JOIN jos_kunena_favorites AS f ON f.thread = m.thread LEFT JOIN jos_kunena_attachments AS a ON a.mesid = m.id WHERE m.hold IN (0) AND m.moved='0' AND m.thread IN (249,922,892,1002,987) GROUP BY thread ) AS l INNER JOIN jos_kunena_messages AS a ON a.thread = l.thread INNER JOIN jos_kunena_messages_text AS t ON a.id = t.mesid LEFT JOIN jos_users AS j ON j.id = a.userid LEFT JOIN jos_kunena_users AS u ON u.userid = j.id LEFT JOIN jos_kunena_categories AS c ON c.id = a.catid LEFT JOIN jos_kunena_attachments AS aa ON aa.mesid = a.id WHERE (a.parent='0' OR a.id=l.lastid ) GROUP BY a.id ORDER BY lastid DESC 112. SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline FROM jos_users AS u LEFT JOIN jos_kunena_users AS k ON k.userid=u.id INNER JOIN jos_session AS s ON s.client_id=0 AND s.userid=u.id AND s.userid>0 GROUP BY s.userid ORDER BY username ASC 113. SELECT id, username AS username FROM jos_users WHERE block='0' OR activation='' ORDER BY id DESC LIMIT 0, 1 114. SELECT u.name, u.username, u.block AS blocked, ku.* FROM jos_users AS u LEFT JOIN jos_kunena_users AS ku ON u.id = ku.userid WHERE u.id IN (141,430,104,306,595,406,357,128,77,676) 115. 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, a.`profile_id` AS _profile_id, a.`friendcount` AS _friendcount, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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 (141,430,104,306,595,406,357,128,77,676) 116. SELECT u.id AS userid, 0 AS catid FROM jos_users AS u WHERE u.block='0' AND u.usertype IN ('Administrator', 'Super Administrator') 117. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 118. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 119. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 120. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 121. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`=1 122. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 123. SELECT id, name, parent FROM jos_kunena_categories WHERE published=1 124. SELECT code, `location` FROM jos_kunena_smileys 125. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 126. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 127. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 128. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 129. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=104' AND published=1 AND id='113' 130. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 131. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 132. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 133. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 134. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=595' AND published=1 AND id='113' 135. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 136. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 137. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 138. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 139. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=406' AND published=1 AND id='113' 140. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 141. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 142. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 143. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 144. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=128' AND published=1 AND id='113' 145. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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' 146. SELECT m.*,n.`name` FROM `jos_community_blocklist` m LEFT JOIN `jos_users` n ON m.`blocked_userid`=n.`id` WHERE m.`userid`='0' AND m.`blocked_userid`!=0 147. SELECT a.*, TO_DAYS('2011-03-02 14:13: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 56 148. SELECT name FROM jos_plugins WHERE `element`='wall' 149. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 150. SELECT name FROM jos_plugins WHERE `element`='wall' 151. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 152. SELECT name FROM jos_plugins WHERE `element`='profile' 153. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 154. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='642' 155. SELECT name FROM jos_plugins WHERE `element`='videos' 156. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 157. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=videos%' AND `published`=1 158. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 159. SELECT * FROM jos_community_videos WHERE id = '2' 160. SELECT * FROM jos_community_wall WHERE id = '12' 161. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 162. SELECT name FROM jos_plugins WHERE `element`='videos' 163. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 164. SELECT * FROM jos_community_videos WHERE id = '2' 165. SELECT * FROM jos_community_videos WHERE id = '2' 166. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 167. SELECT * FROM jos_community_videos WHERE id = '2' 168. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 169. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='180' 170. SELECT name FROM jos_plugins WHERE `element`='videos' 171. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 172. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=180&videoid=1' AND published=1 AND id='329' 173. SELECT * FROM jos_community_videos WHERE id = '1' 174. SELECT * FROM jos_community_wall WHERE id = '11' 175. SELECT COUNT(1) FROM jos_community_activities 176. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 177. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 178. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 179. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 180. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 181. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile' AND published=1 AND id='113' 182. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 183. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=frontpage%' AND `published`=1 184. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=register%' AND `published`=1 185. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 186. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 187. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 188. SELECT catid FROM jos_content WHERE id = 5080 189. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id INNER JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2011-03-02 14:13") ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2011-03-02 14:13") ) AND Listing.access <= 0 AND Listing.catid IN (976) ) ORDER BY Totals.user_rating DESC, Totals.user_rating_count DESC LIMIT 10 190. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 191. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (5080,5083,5082,5089,5090,5091,5092,5081,5084,5086) GROUP BY listing_id 192. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (255) ) 193. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,3,150,583,2,4) AND type = 'content' 194. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,150,583) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 195. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 196. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 197. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 214 ORDER BY ordering ASC ,optionid ASC 198. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 671 ORDER BY ordering ASC ,optionid ASC 199. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 200. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_rostrocor,jr_cuerpoacc,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (5080,5083,5082,5089,5090,5091,5092,5081,5084,5086) 201. SELECT COUNT(DISTINCT Listing.id) FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id INNER JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2011-03-02 14:13") ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2011-03-02 14:13") ) AND Listing.access <= 0 AND Listing.catid IN (976) ) 202. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5080' 203. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5080' 204. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5083' 205. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5083' 206. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5082' 207. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5082' 208. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5089' 209. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5089' 210. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5090' 211. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5090' 212. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5091' 213. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5091' 214. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5092' 215. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5092' 216. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5081' 217. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5081' 218. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5084' 219. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5084' 220. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5086' 221. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5086' 222. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 223. SELECT Category.id AS catid, Category.section AS sectionid, CONCAT(SUBSTR(Category.title,1,20),'...') AS category, CONCAT(SUBSTR(Section.title,1,20),'...') AS section FROM jos_jreviews_categories AS JreviewCategory LEFT JOIN jos_categories AS Category ON Category.id = JreviewCategory.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id WHERE Category.published = 1 AND Category.access <= '0' AND JreviewCategory.OPTION = 'com_content' ORDER BY Section.title ASC,Category.title ASC 224. SELECT FIELD.fieldid AS `Field.id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.type AS `Field.type`, FIELD.options AS `Field.params`, FIELD.required AS `Field.required`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid AND `Group`.type = 'content' ) WHERE FIELD.name IN ('category','categories') AND FIELD.location = 'content' 225. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 226. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved` FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) ORDER BY `Review.created` DESC LIMIT 9 227. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id LEFT JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.id IN (8322,6458,8105,2617,8242,8628,8299,8027,8015) ) 228. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 229. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (2617,6458,8015,8027,8105,8242,8299,8322,8628) GROUP BY listing_id 230. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (166,160,300,205,210,154,194,192) ) 231. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4,1,3,17,18,19,162,167,172,176,179,189,191,197,215,220,223,539,2,4,1,3,322,371,385,563,2,4,1,3,17,324,344,350,354,358,359,369,374,382,563,2,4,1,2,3,17,18,226,228,230,231,233,241,248,249,252,4,1,3,234,251,256,2,4,1,2,3,17,296,297,298,299,300,301,302,303,561,562,582,4) AND type = 'content' 232. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,19,18,17,161,162,163,167,172,176,177,179,180,183,185,187,189,191,197,215,218,220,222,223,226,228,230,231,233,234,241,248,249,251,252,256,296,297,298,299,300,301,302,303,322,324,344,350,354,358,359,369,371,374,382,385,534,535,537,539,561,562,563,582) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 233. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 234. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 235. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 81 ORDER BY ordering ASC ,optionid ASC 236. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 82 ORDER BY ordering ASC ,optionid ASC 237. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 83 ORDER BY ordering ASC ,optionid ASC 238. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 225 ORDER BY ordering ASC ,optionid ASC 239. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 226 ORDER BY ordering ASC ,optionid ASC 240. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 227 ORDER BY ordering ASC ,optionid ASC 241. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 231 ORDER BY ordering ASC ,optionid ASC 242. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 236 ORDER BY ordering ASC ,optionid ASC 243. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 240 ORDER BY ordering ASC ,optionid ASC 244. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 241 ORDER BY ordering ASC ,optionid ASC 245. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 243 ORDER BY ordering ASC ,optionid ASC 246. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 244 ORDER BY ordering ASC ,optionid ASC 247. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 247 ORDER BY ordering ASC ,optionid ASC 248. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 249 ORDER BY ordering ASC ,optionid ASC 249. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 251 ORDER BY ordering ASC ,optionid ASC 250. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 253 ORDER BY ordering ASC ,optionid ASC 251. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 255 ORDER BY ordering ASC ,optionid ASC 252. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 261 ORDER BY ordering ASC ,optionid ASC 253. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 279 ORDER BY ordering ASC ,optionid ASC 254. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 282 ORDER BY ordering ASC ,optionid ASC 255. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 284 ORDER BY ordering ASC ,optionid ASC 256. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 286 ORDER BY ordering ASC ,optionid ASC 257. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 287 ORDER BY ordering ASC ,optionid ASC 258. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 290 ORDER BY ordering ASC ,optionid ASC 259. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 292 ORDER BY ordering ASC ,optionid ASC 260. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 294 ORDER BY ordering ASC ,optionid ASC 261. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 295 ORDER BY ordering ASC ,optionid ASC 262. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 297 ORDER BY ordering ASC ,optionid ASC 263. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 298 ORDER BY ordering ASC ,optionid ASC 264. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 305 ORDER BY ordering ASC ,optionid ASC 265. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 311 ORDER BY ordering ASC ,optionid ASC 266. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 312 ORDER BY ordering ASC ,optionid ASC 267. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 314 ORDER BY ordering ASC ,optionid ASC 268. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 315 ORDER BY ordering ASC ,optionid ASC 269. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 320 ORDER BY ordering ASC ,optionid ASC 270. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 360 ORDER BY ordering ASC ,optionid ASC 271. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 361 ORDER BY ordering ASC ,optionid ASC 272. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 362 ORDER BY ordering ASC ,optionid ASC 273. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 363 ORDER BY ordering ASC ,optionid ASC 274. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 364 ORDER BY ordering ASC ,optionid ASC 275. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 365 ORDER BY ordering ASC ,optionid ASC 276. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 366 ORDER BY ordering ASC ,optionid ASC 277. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 367 ORDER BY ordering ASC ,optionid ASC 278. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 386 ORDER BY ordering ASC ,optionid ASC 279. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 388 ORDER BY ordering ASC ,optionid ASC 280. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 408 ORDER BY ordering ASC ,optionid ASC 281. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 414 ORDER BY ordering ASC ,optionid ASC 282. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 418 ORDER BY ordering ASC ,optionid ASC 283. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 422 ORDER BY ordering ASC ,optionid ASC 284. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 423 ORDER BY ordering ASC ,optionid ASC 285. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 433 ORDER BY ordering ASC ,optionid ASC 286. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 435 ORDER BY ordering ASC ,optionid ASC 287. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 438 ORDER BY ordering ASC ,optionid ASC 288. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 446 ORDER BY ordering ASC ,optionid ASC 289. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 449 ORDER BY ordering ASC ,optionid ASC 290. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 624 ORDER BY ordering ASC ,optionid ASC 291. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 622 ORDER BY ordering ASC ,optionid ASC 292. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 626 ORDER BY ordering ASC ,optionid ASC 293. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 649 ORDER BY ordering ASC ,optionid ASC 294. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 650 ORDER BY ordering ASC ,optionid ASC 295. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 651 ORDER BY ordering ASC ,optionid ASC 296. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 670 ORDER BY ordering ASC ,optionid ASC 297. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 298. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_presentacin,jr_textura,jr_tiposdepiel,jr_aclaradofac,jr_acnefac,jr_antiarrugasfac,jr_antirojeces,jr_biofac,jr_concolor,jr_contornodeojo,jr_cuperosis,jr_efectolifting,jr_exfoliantefac,jr_hidratantefac,jr_iluminador,jr_limpiadorfac,jr_maana,jr_nochefac,jr_serum,jr_sinjabnfac,jr_sinperfumefac,jr_todotipodemaquillaje,jr_tnico,jr_anticaries,jr_antisarro,jr_bioperso,jr_blanqueador,jr_colutorio,jr_compresas,jr_encassensibles,jr_niosperso,jr_refrescanteperso,jr_salvaslip,jr_sedadental,jr_tampones,jr_anticelulticos,jr_antiedadnutri,jr_antiojerasybolsas,jr_cabellonutri,jr_firmezapiel,jr_hidratantenutri,jr_preparacinsolar,jr_uasnutri,jr_aplicador,jr_brillante,jr_hidratantemaq,jr_largaduracin,jr_mate,jr_multiuso,jr_paleta,jr_proteccinuvmaq,jr_retractil,jr_satinado,jr_transparente,jr_waterproofmaq,jr_proteccionuvfac,jr_reafirmantefac,jr_mascarillaexfoliantefac,jr_prolongadordelbronceadonutri,jr_purificaciondelapielnutri,jr_biomaq,jr_bionutri,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (2617,6458,8015,8027,8105,8242,8299,8322,8628) 299. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (524,327,427,674,324) ) 300. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (194,160,210,166,154,192,205,300) ) 301. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4,1,3,17,18,19,162,167,172,176,179,189,191,197,215,220,223,539,2,4,1,3,322,371,385,563,2,4,1,3,17,324,344,350,354,358,359,369,374,382,563,2,4,1,2,3,17,18,226,228,230,231,233,241,248,249,252,4,1,3,234,251,256,2,4,1,2,3,17,296,297,298,299,300,301,302,303,561,562,582,4) AND type = 'review' 302. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (4) AND `Group`.type = 'review' ) WHERE FIELD.location = 'review' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 303. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 21 ORDER BY ordering ASC ,optionid ASC 304. SELECT Review.reviewid AS element_id,jr_puntospositivos,jr_puntosnegativos,jr_recomendacion,jr_otro FROM jos_jreviews_review_fields AS Review WHERE Review.reviewid IN (10342,10341,10340,10339,10338,10337,10336,10335,10334) 305. SELECT COUNT(DISTINCT Review.id) FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) 306. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8322' 307. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8322' 308. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='6458' 309. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='6458' 310. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=524' AND published=1 AND id='113' 311. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='524' 312. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8105' 313. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8105' 314. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=327' AND published=1 AND id='113' 315. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='327' 316. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2617' 317. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2617' 318. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8242' 319. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8242' 320. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=427' AND published=1 AND id='113' 321. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='427' 322. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8628' 323. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8628' 324. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 325. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='674' 326. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8299' 327. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8299' 328. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 329. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8027' 330. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8027' 331. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=324' AND published=1 AND id='113' 332. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='324' 333. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8015' 334. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8015' 335. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 336. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 337. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 338. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 339. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='192' 340. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='191' 341. SELECT count(id) FROM jos_menu WHERE link LIKE 'index.php?option=com_contact&view=contact&id=%' AND published = 1 342. SELECT title FROM jos_categories WHERE id=12 343. SELECT name FROM jos_contact_details WHERE id=1-name •Archivos de idioma cargados• * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.ini 1 * /home/vedouze2/public_html/testtemp/administrator/language/es-ES/es-ES.plg_system_jat3.ini * /home/vedouze2/public_html/testtemp/administrator/language/en-GB/en-GB.plg_system_jat3.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.plg_system_debug.ini 1 * /home/vedouze2/public_html/testtemp/administrator/language/es-ES/es-ES.com_rsfirewall.ini * /home/vedouze2/public_html/testtemp/administrator/language/en-GB/en-GB.com_rsfirewall.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.tpl_ja_teline_iv.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.tpl_ja_teline_iv.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.com_content.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_jreviews_reviews.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.mod_jreviews_reviews.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_kunenalatest.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.com_kunena.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_activitystream.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.mod_activitystream.ini * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.com_community.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_hellome.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_jreviews_listings.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.mod_jreviews_listings.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_jreviews_advsearch.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.mod_jreviews_advsearch.ini 1 * /home/vedouze2/public_html/testtemp/language/es-ES/es-ES.mod_vergefacebooklike.ini * /home/vedouze2/public_html/testtemp/language/en-GB/en-GB.mod_vergefacebooklike.ini •Diagnóstico de frases no traducidas• CSS MENU ::include() [/home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php:179] DROPLINE MENU ::include() [/home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php:179] LAST UPDATE ::include() [/home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php:179] MEGA MENU ::include() [/home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php:179] SPLIT MENU ::include() [/home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php:179] •DiseFrases no traducidas de diseñador• # /home/vedouze2/public_html/testtemp/plugins/system/jat3/core/template.php CSS MENU=CSS Menu DROPLINE MENU=Dropline Menu LAST UPDATE=Last update MEGA MENU=Mega Menu SPLIT MENU=Split Menu •Información del perfil• Application afterLoad: 0.000 seconds, 0.40 MB Application afterInitialise: 0.143 seconds, 10.36 MB Application afterRoute: 0.206 seconds, 14.98 MB Application afterDispatch: 0.694 seconds, 27.44 MB Application afterRender: 1.732 seconds, 49.55 MB •Uso de la memoria• 52371784 •343 consultas en la lista.• 1. SELECT * FROM jos_session WHERE session_id = 'ac66d126fa4ba4d5319a0536363722e4' 2. DELETE FROM jos_session WHERE ( time < '1298967186' ) 3. SELECT * FROM jos_session WHERE session_id = 'ac66d126fa4ba4d5319a0536363722e4' 4. UPDATE `jos_session` SET `time`='1299075186',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:9:{s:15:\"session.counter\";i:62;s:19:\"session.timer.start\";i:1299059417;s:18:\"session.timer.last\";i:1299074809;s:17:\"session.timer.now\";i:1299074830;s:22:\"session.client.browser\";s:109:\"Mozilla/5.0 (Windows; U; Windows NT 6.0; fr; rv:1.9.2.13) Gecko/20101203 Firefox/3.6.13 ( .NET CLR 3.5.30729)\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":20:{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:75:\"/home/vedouze2/public_html/testtemp/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:16:\"duplicate_review\";b:0;}s:17:\"rsfirewall_config\";O:8:\"stdClass\":36:{s:15:\"master_password\";s:0:\"\";s:23:\"master_password_enabled\";s:1:\"0\";s:13:\"blacklist_ips\";s:0:\"\";s:21:\"active_scanner_status\";s:1:\"1\";s:10:\"verify_sql\";s:1:\"1\";s:9:\"verify_js\";s:1:\"1\";s:15:\"verify_sql_skip\";a:0:{}s:14:\"verify_js_skip\";a:0:{}s:13:\"verify_upload\";s:1:\"1\";s:18:\"verify_upload_skip\";a:0:{}s:28:\"verify_upload_blacklist_exts\";s:32:\"php\r\njs\r\nexe\r\ncom\r\nbat\r\ncmd\r\nmp3\";s:12:\"monitor_core\";s:1:\"1\";s:13:\"monitor_files\";s:0:\"\";s:13:\"monitor_users\";a:0:{}s:30:\"backend_access_control_enabled\";s:1:\"0\";s:20:\"backend_access_users\";a:0:{}s:25:\"backend_access_components\";a:0:{}s:24:\"backend_password_enabled\";s:1:\"0\";s:16:\"backend_password\";s:0:\"\";s:21:\"backend_whitelist_ips\";s:0:\"\";s:10:\"log_emails\";s:18:\"fred@ibericity.com\";s:15:\"log_alert_level\";s:6:\"medium\";s:11:\"log_history\";s:2:\"30\";s:12:\"log_overview\";s:1:\"5\";s:8:\"lockdown\";s:1:\"0\";s:10:\"verify_dos\";s:1:\"1\";s:13:\"verify_agents\";s:1:\"1\";s:20:\"verify_multiple_exts\";s:1:\"1\";s:10:\"verify_php\";s:1:\"1\";s:15:\"verify_php_skip\";a:0:{}s:20:\"global_register_code\";s:20:\"3CTQX46HR9KZTNI1V1H9\";s:16:\"verify_generator\";s:1:\"1\";s:5:\"grade\";s:2:\"76\";s:13:\"verify_emails\";s:1:\"0\";s:6:\"offset\";s:3:\"300\";s:15:\"backend_captcha\";s:1:\"3\";}s:13:\"session.token\";s:32:\"ce739e3fbb82e4f212373effc062b881\";}__com_jreviews|a:13:{s:14:\"module_rand390\";i:1947990432;s:16:\"module_params390\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:7:\"reviews\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:6:\"medium\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"180\";s:12:\"module_limit\";s:1:\"1\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"140\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"390\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"a41c285b9fc1ca39c65dbb1ffed69f85\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1947990432;}s:14:\"module_rand378\";i:1876888232;s:16:\"module_params378\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:6:\"random\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:0:\"\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"250\";s:13:\"slider_height\";s:3:\"300\";s:12:\"module_limit\";s:1:\"1\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"3\";s:7:\"section\";s:2:\"26\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"150\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"378\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"c18be4f687d91156a235a993d1940bbb\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1876888232;}s:14:\"module_rand132\";i:1171944968;s:16:\"module_params132\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:9:\"frontpage\";s:6:\"Itemid\";s:1:\"1\";s:5:\"limit\";i:8;s:6:\"module\";a:27:{s:13:\"listing_order\";s:5:\"rdate\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:0:\"\";s:8:\"ajax_nav\";s:1:\"0\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"slider_width\";s:3:\"250\";s:13:\"slider_height\";s:3:\"500\";s:12:\"module_limit\";s:1:\"3\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"0\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:5:\"scale\";s:8:\"tn_width\";s:2:\"40\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:1:\"4\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"132\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"032d3b765bd3dbf00445258ab15b8d20\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1171944968;}s:14:\"module_rand524\";i:1859258598;s:16:\"module_params524\";a:13:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:15:\"module_listings\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:27:{s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"600\";s:13:\"listing_order\";s:6:\"rating\";s:9:\"extension\";s:11:\"com_content\";s:12:\"custom_where\";s:0:\"\";s:12:\"custom_order\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"promo\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:6:\"bottom\";s:12:\"module_limit\";s:2:\"10\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:5:\"scale\";s:8:\"tn_width\";s:2:\"60\";s:21:\"filter_listing_period\";s:0:\"\";s:20:\"filter_review_period\";s:0:\"\";s:19:\"filter_review_count\";s:0:\"\";s:17:\"filter_avg_rating\";s:0:\"\";s:12:\"show_numbers\";s:1:\"1\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"524\";s:4:\"page\";i:1;s:5:\"token\";s:32:\"654cd106e1f5d1cee73c271c2929cacb\";s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1859258598;}s:14:\"module_rand525\";i:536737893;s:16:\"module_params525\";a:12:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:14:\"module_reviews\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:24:{s:13:\"reviews_order\";s:7:\"helpful\";s:12:\"reviews_type\";s:3:\"all\";s:9:\"extension\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"color\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:4:\"side\";s:12:\"slider_width\";s:3:\"300\";s:13:\"slider_height\";s:3:\"150\";s:12:\"module_limit\";s:1:\"5\";s:7:\"columns\";s:1:\"1\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:3:\"100\";s:10:\"link_title\";s:15:\"{listing_title}\";s:13:\"show_comments\";s:1:\"1\";s:12:\"show_numbers\";s:1:\"1\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"525\";s:4:\"page\";i:1;s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:536737893;}s:14:\"module_rand181\";i:1553498653;s:16:\"module_params181\";a:12:{s:4:\"data\";a:3:{s:6:\"module\";b:1;s:10:\"controller\";s:14:\"module_reviews\";s:6:\"action\";s:5:\"index\";}s:4:\"form\";a:0:{}s:3:\"url\";a:4:{s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";}s:6:\"option\";s:11:\"com_content\";s:4:\"view\";s:7:\"article\";s:2:\"id\";s:4:\"5080\";s:6:\"Itemid\";s:3:\"149\";s:6:\"module\";a:24:{s:13:\"reviews_order\";s:6:\"latest\";s:12:\"reviews_type\";s:3:\"all\";s:9:\"extension\";s:0:\"\";s:11:\"tmpl_suffix\";s:0:\"\";s:15:\"moduleclass_sfx\";s:5:\"color\";s:8:\"ajax_nav\";s:1:\"1\";s:12:\"nav_position\";s:4:\"side\";s:12:\"slider_width\";s:3:\"600\";s:13:\"slider_height\";s:3:\"100\";s:12:\"module_limit\";s:1:\"9\";s:7:\"columns\";s:1:\"3\";s:8:\"cat_auto\";s:1:\"1\";s:3:\"dir\";s:1:\"1\";s:7:\"section\";s:0:\"\";s:8:\"category\";s:0:\"\";s:7:\"listing\";s:0:\"\";s:7:\"tn_show\";s:1:\"1\";s:7:\"tn_mode\";s:4:\"crop\";s:8:\"tn_width\";s:2:\"50\";s:10:\"link_title\";s:17:\"{review_title 35}\";s:13:\"show_comments\";s:1:\"1\";s:12:\"show_numbers\";s:1:\"0\";s:5:\"cache\";s:1:\"0\";s:10:\"cache_time\";s:3:\"900\";}s:9:\"module_id\";s:3:\"181\";s:4:\"page\";i:1;s:11:\"tmpl_suffix\";s:0:\"\";s:4:\"rand\";i:1553498653;}s:7:\"__Token\";a:1:{s:4:\"Keys\";a:3:{i:0;s:32:\"240d347a47bd06598ea2745177cb5241\";i:1;s:32:\"3baf5c2ecab1ed134d501c97084b40d1\";i:2;s:32:\"1a0be51e432e4e79eee9b610d570023d\";}}}' WHERE session_id='ac66d126fa4ba4d5319a0536363722e4' 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 * FROM jos_sef_config WHERE id = '1' 8. SELECT * FROM jos_sef_alias WHERE published='1' 9. SELECT id, link FROM jos_menu WHERE home=1 AND published=1 10. SELECT `configuration` FROM `jos_ak_profiles` WHERE `id` = '1' 11. SELECT * FROM `jos_rsfirewall_configuration` 12. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='1.5.22' 13. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='1.5.22' 14. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='protect' 15. SELECT * FROM jos_rsfirewall_hashes WHERE `type`='protect' 16. SELECT * FROM jos_sef_redirect WHERE source='accesorios/diversos/antifaz-relajante-grande-y-peque%c3%b1o-de-the-body-shop-200801315080/' AND published='1' LIMIT 1 17. SELECT id, link FROM jos_menu WHERE alias = 'accesorios' AND published=1 18. SELECT id FROM jos_components WHERE link='option=com_accesorios' ORDER BY id DESC 19. SELECT id FROM jos_menu WHERE alias='accesorios' AND published=1 20. SELECT id FROM jos_menu WHERE alias='diversos' AND published=1 AND parent=132 21. SELECT count(id) FROM jos_sections WHERE title='accesorios' 22. SELECT id, catid, sectionid FROM jos_content WHERE id='5080' AND (state > 0 OR state = -1) 23. SELECT id, link FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=article%&id=5080' ORDER BY id 24. SELECT id FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=category%&id=976' ORDER BY id 25. SELECT id FROM jos_menu WHERE type='component' AND published='1' AND link LIKE 'index.php?option=com_content&view=section%&id=16' ORDER BY id 26. SELECT * FROM jos_autotweet_automator WHERE id = 'automator' 27. UPDATE `jos_autotweet_automator` SET `lastexec`='2011-03-02 14:13:06' WHERE id='automator' 28. SELECT c.`id` AS id, c.`name` AS name, c.`autopublish` AS autopublish, c.`description` AS description, t.`name` AS type, t.`max_chars` AS max_chars, c.`id_1` AS id_1, c.`id_1_secret` AS id_1_secret, c.`id_2` AS id_2, c.`id_2_secret` AS id_2_secret, c.`selection` AS selection, c.`other` AS other, c.`use_own_api` AS use_own_api, c.`api_key` AS api_key, c.`api_secret` AS api_secret, c.`api_authurl` AS api_authurl, c.`api_other` AS api_other FROM `jos_autotweet_channel` c, `jos_autotweet_channeltype` t WHERE c.`published` = 1 AND c.`channeltype_id` = t.`id` 29. SELECT * FROM `jos_autotweet_queue` WHERE `publish_up` <= '2011-03-02 14:13:06' LIMIT 3 30. SELECT template FROM jos_templates_menu WHERE client_id = 0 AND (menuid = 0 OR menuid = 149) ORDER BY menuid DESC LIMIT 0, 1 31. SELECT m.* 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 = 149 OR mm.menuid = 0 ) ORDER BY m.position, m.ordering 32. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 33. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 AND id='102' 34. SELECT * FROM jos_kunena_config 35. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos' AND published=1 AND id='329' 36. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 37. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 38. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 AND id='102' 39. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos' AND published=1 AND id='329' 40. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 41. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 42. SELECT created FROM jos_content a ORDER BY created DESC LIMIT 1 43. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 44. SELECT id FROM jos_menu WHERE link LIKE "%com_community&view=profile%" AND published = 1 AND type = "component" 45. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved` FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) ORDER BY Review.vote_helpful DESC, `Rating.average_rating` DESC LIMIT 5 46. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id LEFT JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.id IN (2716,3214,2390,3238,2601) ) 47. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 48. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (2390,2601,2716,3214,3238) GROUP BY listing_id 49. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (154,160,159) ) 50. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,163,168,169,172,178,180,185,200,204,220,535,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4) AND type = 'content' 51. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,17,18,19,161,163,168,169,172,177,178,180,183,185,187,189,200,204,218,220,222,534,535,537) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 52. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 53. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 54. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 81 ORDER BY ordering ASC ,optionid ASC 55. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 82 ORDER BY ordering ASC ,optionid ASC 56. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 83 ORDER BY ordering ASC ,optionid ASC 57. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 225 ORDER BY ordering ASC ,optionid ASC 58. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 227 ORDER BY ordering ASC ,optionid ASC 59. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 232 ORDER BY ordering ASC ,optionid ASC 60. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 233 ORDER BY ordering ASC ,optionid ASC 61. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 236 ORDER BY ordering ASC ,optionid ASC 62. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 241 ORDER BY ordering ASC ,optionid ASC 63. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 242 ORDER BY ordering ASC ,optionid ASC 64. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 244 ORDER BY ordering ASC ,optionid ASC 65. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 247 ORDER BY ordering ASC ,optionid ASC 66. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 249 ORDER BY ordering ASC ,optionid ASC 67. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 251 ORDER BY ordering ASC ,optionid ASC 68. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 253 ORDER BY ordering ASC ,optionid ASC 69. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 264 ORDER BY ordering ASC ,optionid ASC 70. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 268 ORDER BY ordering ASC ,optionid ASC 71. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 282 ORDER BY ordering ASC ,optionid ASC 72. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 284 ORDER BY ordering ASC ,optionid ASC 73. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 286 ORDER BY ordering ASC ,optionid ASC 74. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 624 ORDER BY ordering ASC ,optionid ASC 75. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 622 ORDER BY ordering ASC ,optionid ASC 76. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 77. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_presentacin,jr_textura,jr_tiposdepiel,jr_aclaradofac,jr_antiarrugasfac,jr_antibolsas,jr_antiojeras,jr_biofac,jr_contornodeojo,jr_corrector,jr_efectolifting,jr_exfoliantefac,jr_hidratantefac,jr_iluminador,jr_limpiadorfac,jr_ojosylabios,jr_proteccinpolucin,jr_sinjabnfac,jr_sinperfumefac,jr_todotipodemaquillaje,jr_proteccionuvfac,jr_reafirmantefac,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (2390,2601,2716,3214,3238) 78. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (241,639,443,251,568) ) 79. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (160,159,154) ) 80. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,163,168,169,172,178,180,185,200,204,220,535,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4) AND type = 'review' 81. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (4) AND `Group`.type = 'review' ) WHERE FIELD.location = 'review' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 82. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 21 ORDER BY ordering ASC ,optionid ASC 83. SELECT Review.reviewid AS element_id,jr_puntospositivos,jr_puntosnegativos,jr_recomendacion,jr_otro FROM jos_jreviews_review_fields AS Review WHERE Review.reviewid IN (3959,3621,3425,3691,3550) 84. SELECT COUNT(DISTINCT Review.id) FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) 85. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2716' 86. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2716' 87. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=241' AND published=1 AND id='113' 88. SELECT * FROM jos_community_config WHERE name = 'config' 89. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='241' 90. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3214' 91. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3214' 92. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=639' AND published=1 AND id='113' 93. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='639' 94. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2390' 95. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2390' 96. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=443' AND published=1 AND id='113' 97. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='443' 98. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3238' 99. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='3238' 100. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=251' AND published=1 AND id='113' 101. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='251' 102. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2601' 103. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2601' 104. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=568' AND published=1 AND id='113' 105. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='568' 106. SELECT DISTINCT g2.id FROM jos_core_acl_aro AS o INNER JOIN jos_core_acl_groups_aro_map AS gm ON gm.aro_id=o.id INNER JOIN jos_core_acl_aro_groups AS g1 ON g1.id = gm.group_id INNER JOIN jos_core_acl_aro_groups AS g2 ON (g2.lft <= g1.lft AND g2.rgt >= g1.rgt) WHERE (o.section_value='users' AND o.value='0') 107. SELECT c.* FROM jos_kunena_categories AS c 108. SELECT c.id FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.memberid='0' 109. SELECT COUNT(DISTINCT t.thread) FROM jos_kunena_messages AS t INNER JOIN jos_kunena_messages AS m ON m.id=t.thread WHERE m.moved='0' AND m.hold IN (0) AND m.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND t.hold IN (0) AND t.moved=0 AND t.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND m.catid NOT IN (10) AND t.time>'1267539187' 110. SELECT m.id, MAX(t.id) AS lastid FROM jos_kunena_messages AS t INNER JOIN jos_kunena_messages AS m ON m.id=t.thread WHERE m.moved='0' AND m.hold IN (0) AND m.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND t.hold IN (0) AND t.moved='0' AND t.catid IN (1,11,12,2,5,6,10,7,8,9,13,14,15,16,17,18) AND m.catid NOT IN (10) AND t.time>'1267539187' GROUP BY t.thread ORDER BY lastid DESC LIMIT 0, 5 111. SELECT a.*, j.id AS userid, t.message, l.myfavorite, l.favcount, l.threadhits, l.lasttime, l.threadattachments, COUNT(aa.id) AS attachments, l.msgcount, l.mycount, l.lastid, l.mylastid, l.lastid AS lastread, 0 AS unread, u.avatar, j.username, j.name AS uname, c.name AS catname, c.class_sfx FROM ( SELECT m.thread, MAX(m.hits) AS threadhits, MAX(f.userid IS NOT NULL AND f.userid='0') AS myfavorite, COUNT(DISTINCT f.userid) AS favcount, COUNT(DISTINCT a.id) AS threadattachments, COUNT(DISTINCT m.id) AS msgcount, COUNT(DISTINCT IF(m.userid='0', m.id, NULL)) AS mycount, MAX(m.id) AS lastid, MAX(IF(m.userid='0', m.id, 0)) AS mylastid, MAX(m.time) AS lasttime FROM jos_kunena_messages AS m LEFT JOIN jos_kunena_favorites AS f ON f.thread = m.thread LEFT JOIN jos_kunena_attachments AS a ON a.mesid = m.id WHERE m.hold IN (0) AND m.moved='0' AND m.thread IN (249,922,892,1002,987) GROUP BY thread ) AS l INNER JOIN jos_kunena_messages AS a ON a.thread = l.thread INNER JOIN jos_kunena_messages_text AS t ON a.id = t.mesid LEFT JOIN jos_users AS j ON j.id = a.userid LEFT JOIN jos_kunena_users AS u ON u.userid = j.id LEFT JOIN jos_kunena_categories AS c ON c.id = a.catid LEFT JOIN jos_kunena_attachments AS aa ON aa.mesid = a.id WHERE (a.parent='0' OR a.id=l.lastid ) GROUP BY a.id ORDER BY lastid DESC 112. SELECT s.userid, u.username AS username, u.id, k.moderator, k.showOnline FROM jos_users AS u LEFT JOIN jos_kunena_users AS k ON k.userid=u.id INNER JOIN jos_session AS s ON s.client_id=0 AND s.userid=u.id AND s.userid>0 GROUP BY s.userid ORDER BY username ASC 113. SELECT id, username AS username FROM jos_users WHERE block='0' OR activation='' ORDER BY id DESC LIMIT 0, 1 114. SELECT u.name, u.username, u.block AS blocked, ku.* FROM jos_users AS u LEFT JOIN jos_kunena_users AS ku ON u.id = ku.userid WHERE u.id IN (141,430,104,306,595,406,357,128,77,676) 115. 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, a.`profile_id` AS _profile_id, a.`friendcount` AS _friendcount, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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 (141,430,104,306,595,406,357,128,77,676) 116. SELECT u.id AS userid, 0 AS catid FROM jos_users AS u WHERE u.block='0' AND u.usertype IN ('Administrator', 'Super Administrator') 117. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 118. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 119. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 120. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 121. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=profile%' AND `published`=1 122. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 123. SELECT id, name, parent FROM jos_kunena_categories WHERE published=1 124. SELECT code, `location` FROM jos_kunena_smileys 125. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 126. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 127. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 128. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 129. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=104' AND published=1 AND id='113' 130. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 131. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 132. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 133. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 134. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=595' AND published=1 AND id='113' 135. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 136. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 137. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 138. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 139. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=406' AND published=1 AND id='113' 140. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 141. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 142. SELECT u.id AS userid, m.catid FROM jos_users AS u INNER JOIN jos_kunena_users AS ku ON u.id=ku.userid LEFT JOIN jos_kunena_moderation AS m ON u.id=m.userid LEFT JOIN jos_kunena_categories AS c ON m.catid=c.id WHERE u.block='0' AND ku.moderator='1' AND (m.catid IS NULL OR c.moderated='1') 143. SELECT g.memberid AS userid, c.id AS catid FROM jos_kunena_categories AS c INNER JOIN jos_community_groups_members AS g ON c.accesstype='jomsocial' AND c.access=g.groupid WHERE c.published=1 AND g.approved=1 AND g.permissions='1' 144. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=128' AND published=1 AND id='113' 145. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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' 146. SELECT m.*,n.`name` FROM `jos_community_blocklist` m LEFT JOIN `jos_users` n ON m.`blocked_userid`=n.`id` WHERE m.`userid`='0' AND m.`blocked_userid`!=0 147. SELECT a.*, TO_DAYS('2011-03-02 14:13: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 56 148. SELECT name FROM jos_plugins WHERE `element`='wall' 149. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 150. SELECT name FROM jos_plugins WHERE `element`='wall' 151. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 152. SELECT name FROM jos_plugins WHERE `element`='profile' 153. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 154. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='642' 155. SELECT name FROM jos_plugins WHERE `element`='videos' 156. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 157. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=videos%' AND `published`=1 158. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 159. SELECT * FROM jos_community_videos WHERE id = '2' 160. SELECT * FROM jos_community_wall WHERE id = '12' 161. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 162. SELECT name FROM jos_plugins WHERE `element`='videos' 163. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 164. SELECT * FROM jos_community_videos WHERE id = '2' 165. SELECT * FROM jos_community_videos WHERE id = '2' 166. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=642&videoid=2' AND published=1 AND id='329' 167. SELECT * FROM jos_community_videos WHERE id = '2' 168. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 169. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='180' 170. SELECT name FROM jos_plugins WHERE `element`='videos' 171. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 172. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=videos&task=video&userid=180&videoid=1' AND published=1 AND id='329' 173. SELECT * FROM jos_community_videos WHERE id = '1' 174. SELECT * FROM jos_community_wall WHERE id = '11' 175. SELECT COUNT(1) FROM jos_community_activities 176. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 177. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=430' AND published=1 AND id='113' 178. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 179. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=642' AND published=1 AND id='113' 180. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=180' AND published=1 AND id='113' 181. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile' AND published=1 AND id='113' 182. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 183. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=frontpage%' AND `published`=1 184. SELECT id FROM jos_menu WHERE `link` LIKE '%option=com_community&view=register%' AND `published`=1 185. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 AND id='112' 186. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 187. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 188. SELECT catid FROM jos_content WHERE id = 5080 189. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id INNER JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2011-03-02 14:13") ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2011-03-02 14:13") ) AND Listing.access <= 0 AND Listing.catid IN (976) ) ORDER BY Totals.user_rating DESC, Totals.user_rating_count DESC LIMIT 10 190. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 191. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (5080,5083,5082,5089,5090,5091,5092,5081,5084,5086) GROUP BY listing_id 192. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (255) ) 193. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,3,150,583,2,4) AND type = 'content' 194. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,150,583) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 195. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 196. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 197. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 214 ORDER BY ordering ASC ,optionid ASC 198. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 671 ORDER BY ordering ASC ,optionid ASC 199. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 200. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_rostrocor,jr_cuerpoacc,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (5080,5083,5082,5089,5090,5091,5092,5081,5084,5086) 201. SELECT COUNT(DISTINCT Listing.id) FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id INNER JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.state = 1 AND ( Listing.publish_up = "0000-00-00 00:00:00" OR DATE(Listing.publish_up) <= DATE("2011-03-02 14:13") ) AND ( Listing.publish_down = "0000-00-00 00:00:00" OR DATE(Listing.publish_down) >= DATE("2011-03-02 14:13") ) AND Listing.access <= 0 AND Listing.catid IN (976) ) 202. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5080' 203. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5080' 204. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5083' 205. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5083' 206. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5082' 207. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5082' 208. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5089' 209. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5089' 210. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5090' 211. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5090' 212. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5091' 213. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5091' 214. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5092' 215. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5092' 216. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5081' 217. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5081' 218. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5084' 219. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5084' 220. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5086' 221. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='5086' 222. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 223. SELECT Category.id AS catid, Category.section AS sectionid, CONCAT(SUBSTR(Category.title,1,20),'...') AS category, CONCAT(SUBSTR(Section.title,1,20),'...') AS section FROM jos_jreviews_categories AS JreviewCategory LEFT JOIN jos_categories AS Category ON Category.id = JreviewCategory.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id WHERE Category.published = 1 AND Category.access <= '0' AND JreviewCategory.OPTION = 'com_content' ORDER BY Section.title ASC,Category.title ASC 224. SELECT FIELD.fieldid AS `Field.id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.type AS `Field.type`, FIELD.options AS `Field.params`, FIELD.required AS `Field.required`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid AND `Group`.type = 'content' ) WHERE FIELD.name IN ('category','categories') AND FIELD.location = 'content' 225. SELECT id,name,link AS menu_type,link,componentid,params,access,published FROM jos_menu WHERE published = 1 ORDER BY link DESC 226. SELECT Review.id AS `Review.review_id`, Review.pid AS `Review.listing_id`, Review.mode AS `Review.extension`, Review.created AS `Review.created`, Review.modified AS `Review.modified`, Review.userid AS `User.user_id`, CASE WHEN CHAR_LENGTH(User.name) THEN User.name ELSE Review.name END AS `User.name`, CASE WHEN CHAR_LENGTH(User.username) THEN User.username ELSE Review.username END AS `User.username`, Review.email AS `User.email`, Review.ipaddress AS `User.ipaddress`, Review.title AS `Review.title`, Review.comments AS `Review.comments`, Review.posts AS `Review.posts`, Review.author AS `Review.editor`, Review.published AS `Review.published`, Rating.ratings AS `Rating.ratings`, (Rating.ratings_sum/Rating.ratings_qty) AS `Rating.average_rating`, Review.vote_helpful AS `Vote.yes`, (Review.vote_total - Review.vote_helpful) AS `Vote.no`, (Review.vote_helpful/Review.vote_total)*100 AS `Vote.helpful`, Review.owner_reply_text AS `Review.owner_reply_text`, Review.owner_reply_approved AS `Review.owner_reply_approved` FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) ORDER BY `Review.created` DESC LIMIT 9 227. SELECT Listing.id AS `Listing.listing_id`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.sectionid AS `Listing.section_id`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Section.id AS `Section.section_id`, Section.title AS `Section.title`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.image AS `Listing.category_image`, Directory.id AS `Directory.dir_id`, Directory.DESC AS `Directory.title`, Directory.title AS `Directory.slug`, Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.weights AS `Criteria.weights`, Criteria.required AS `Criteria.required`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, `Field`.featured AS `Listing.featured`, Frontpage.content_id AS `Listing.frontpage`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Claim.approved AS `Claim.approved`, Listing.alias AS `Listing.slug`, Category.alias AS `Category.slug`, Section.alias AS `Section.slug` FROM jos_content AS Listing INNER JOIN jos_jreviews_categories AS JreviewsCategory ON Listing.catid = JreviewsCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN jos_categories AS Category ON JreviewsCategory.id = Category.id LEFT JOIN jos_sections AS Section ON Category.section = Section.id LEFT JOIN jos_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN jos_jreviews_content AS FIELD ON FIELD.contentid = Listing.id LEFT JOIN jos_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id LEFT JOIN jos_jreviews_criteria AS Criteria ON JreviewsCategory.criteriaid = Criteria.id LEFT JOIN jos_users AS User ON User.id = Listing.created_by LEFT JOIN jos_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.approved = 1 LEFT JOIN jos_content_frontpage AS Frontpage ON Frontpage.content_id = Listing.id WHERE 1 = 1 AND ( Listing.id IN (8322,6458,8105,2617,8242,8628,8299,8027,8015) ) 228. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (71) ) 229. SELECT content_id AS listing_id, count(*) AS favored FROM jos_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (2617,6458,8015,8027,8105,8242,8299,8322,8628) GROUP BY listing_id 230. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (166,160,300,205,210,154,194,192) ) 231. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4,1,3,17,18,19,162,167,172,176,179,189,191,197,215,220,223,539,2,4,1,3,322,371,385,563,2,4,1,3,17,324,344,350,354,358,359,369,374,382,563,2,4,1,2,3,17,18,226,228,230,231,233,241,248,249,252,4,1,3,234,251,256,2,4,1,2,3,17,296,297,298,299,300,301,302,303,561,562,582,4) AND type = 'content' 232. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (1,2,3,19,18,17,161,162,163,167,172,176,177,179,180,183,185,187,189,191,197,215,218,220,222,223,226,228,230,231,233,234,241,248,249,251,252,256,296,297,298,299,300,301,302,303,322,324,344,350,354,358,359,369,371,374,382,385,534,535,537,539,561,562,563,582) AND `Group`.type = 'content' ) WHERE FIELD.location = 'content' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 233. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 600 ORDER BY ordering ASC ,optionid ASC 234. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 609 ORDER BY ordering ASC ,optionid ASC 235. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 81 ORDER BY ordering ASC ,optionid ASC 236. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 82 ORDER BY ordering ASC ,optionid ASC 237. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 83 ORDER BY ordering ASC ,optionid ASC 238. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 225 ORDER BY ordering ASC ,optionid ASC 239. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 226 ORDER BY ordering ASC ,optionid ASC 240. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 227 ORDER BY ordering ASC ,optionid ASC 241. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 231 ORDER BY ordering ASC ,optionid ASC 242. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 236 ORDER BY ordering ASC ,optionid ASC 243. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 240 ORDER BY ordering ASC ,optionid ASC 244. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 241 ORDER BY ordering ASC ,optionid ASC 245. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 243 ORDER BY ordering ASC ,optionid ASC 246. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 244 ORDER BY ordering ASC ,optionid ASC 247. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 247 ORDER BY ordering ASC ,optionid ASC 248. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 249 ORDER BY ordering ASC ,optionid ASC 249. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 251 ORDER BY ordering ASC ,optionid ASC 250. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 253 ORDER BY ordering ASC ,optionid ASC 251. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 255 ORDER BY ordering ASC ,optionid ASC 252. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 261 ORDER BY ordering ASC ,optionid ASC 253. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 279 ORDER BY ordering ASC ,optionid ASC 254. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 282 ORDER BY ordering ASC ,optionid ASC 255. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 284 ORDER BY ordering ASC ,optionid ASC 256. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 286 ORDER BY ordering ASC ,optionid ASC 257. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 287 ORDER BY ordering ASC ,optionid ASC 258. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 290 ORDER BY ordering ASC ,optionid ASC 259. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 292 ORDER BY ordering ASC ,optionid ASC 260. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 294 ORDER BY ordering ASC ,optionid ASC 261. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 295 ORDER BY ordering ASC ,optionid ASC 262. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 297 ORDER BY ordering ASC ,optionid ASC 263. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 298 ORDER BY ordering ASC ,optionid ASC 264. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 305 ORDER BY ordering ASC ,optionid ASC 265. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 311 ORDER BY ordering ASC ,optionid ASC 266. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 312 ORDER BY ordering ASC ,optionid ASC 267. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 314 ORDER BY ordering ASC ,optionid ASC 268. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 315 ORDER BY ordering ASC ,optionid ASC 269. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 320 ORDER BY ordering ASC ,optionid ASC 270. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 360 ORDER BY ordering ASC ,optionid ASC 271. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 361 ORDER BY ordering ASC ,optionid ASC 272. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 362 ORDER BY ordering ASC ,optionid ASC 273. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 363 ORDER BY ordering ASC ,optionid ASC 274. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 364 ORDER BY ordering ASC ,optionid ASC 275. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 365 ORDER BY ordering ASC ,optionid ASC 276. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 366 ORDER BY ordering ASC ,optionid ASC 277. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 367 ORDER BY ordering ASC ,optionid ASC 278. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 386 ORDER BY ordering ASC ,optionid ASC 279. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 388 ORDER BY ordering ASC ,optionid ASC 280. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 408 ORDER BY ordering ASC ,optionid ASC 281. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 414 ORDER BY ordering ASC ,optionid ASC 282. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 418 ORDER BY ordering ASC ,optionid ASC 283. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 422 ORDER BY ordering ASC ,optionid ASC 284. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 423 ORDER BY ordering ASC ,optionid ASC 285. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 433 ORDER BY ordering ASC ,optionid ASC 286. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 435 ORDER BY ordering ASC ,optionid ASC 287. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 438 ORDER BY ordering ASC ,optionid ASC 288. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 446 ORDER BY ordering ASC ,optionid ASC 289. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 449 ORDER BY ordering ASC ,optionid ASC 290. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 624 ORDER BY ordering ASC ,optionid ASC 291. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 622 ORDER BY ordering ASC ,optionid ASC 292. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 626 ORDER BY ordering ASC ,optionid ASC 293. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 649 ORDER BY ordering ASC ,optionid ASC 294. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 650 ORDER BY ordering ASC ,optionid ASC 295. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 651 ORDER BY ordering ASC ,optionid ASC 296. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 670 ORDER BY ordering ASC ,optionid ASC 297. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 12 ORDER BY ordering ASC ,optionid ASC 298. SELECT Listing.contentid AS element_id,jr_producto,jr_descripcincorta,jr_marca,jr_gama,jr_sitiointernet,jr_precio,jr_capacidadml,jr_capacidadgramo,jr_capacidadunidad,jr_preciolitro,jr_preciokilo,jr_precioporunidad,jr_comercialisado,jr_comprar,jr_comprardos,jr_presentacin,jr_textura,jr_tiposdepiel,jr_aclaradofac,jr_acnefac,jr_antiarrugasfac,jr_antirojeces,jr_biofac,jr_concolor,jr_contornodeojo,jr_cuperosis,jr_efectolifting,jr_exfoliantefac,jr_hidratantefac,jr_iluminador,jr_limpiadorfac,jr_maana,jr_nochefac,jr_serum,jr_sinjabnfac,jr_sinperfumefac,jr_todotipodemaquillaje,jr_tnico,jr_anticaries,jr_antisarro,jr_bioperso,jr_blanqueador,jr_colutorio,jr_compresas,jr_encassensibles,jr_niosperso,jr_refrescanteperso,jr_salvaslip,jr_sedadental,jr_tampones,jr_anticelulticos,jr_antiedadnutri,jr_antiojerasybolsas,jr_cabellonutri,jr_firmezapiel,jr_hidratantenutri,jr_preparacinsolar,jr_uasnutri,jr_aplicador,jr_brillante,jr_hidratantemaq,jr_largaduracin,jr_mate,jr_multiuso,jr_paleta,jr_proteccinuvmaq,jr_retractil,jr_satinado,jr_transparente,jr_waterproofmaq,jr_proteccionuvfac,jr_reafirmantefac,jr_mascarillaexfoliantefac,jr_prolongadordelbronceadonutri,jr_purificaciondelapielnutri,jr_biomaq,jr_bionutri,jr_caracteristicas,jr_formula,jr_tonos,jr_consejosutilisacion,jr_indicacion,jr_distribucion FROM jos_jreviews_content AS Listing WHERE Listing.contentid IN (2617,6458,8015,8027,8105,8242,8299,8322,8628) 299. SELECT Community.userid AS `Community.user_id`, Community.thumb AS `Community.avatar` FROM jos_community_users AS Community WHERE 1 = 1 AND ( userid IN (524,327,427,674,324) ) 300. SELECT Criteria.id AS `Criteria.criteria_id`, Criteria.title AS `Criteria.title`, Criteria.criteria AS `Criteria.criteria`, Criteria.required AS `Criteria.required`, Criteria.weights AS `Criteria.weights`, Criteria.tooltips AS `Criteria.tooltips`, Criteria.qty AS `Criteria.quantity`, Criteria.groupid AS `Criteria.group_id`, Criteria.state AS `Criteria.state`, Criteria.config AS `ListingType.config`, Criteria.groupid FROM jos_jreviews_criteria AS Criteria WHERE 1 = 1 AND ( Criteria.id IN (194,160,210,166,154,192,205,300) ) 301. SELECT groupid FROM jos_jreviews_groups WHERE groupid IN (1,2,3,17,18,19,163,172,180,185,187,220,534,535,537,4,1,2,3,17,18,19,161,172,177,183,185,189,218,220,222,4,1,3,17,18,19,162,167,172,176,179,189,191,197,215,220,223,539,2,4,1,3,322,371,385,563,2,4,1,3,17,324,344,350,354,358,359,369,374,382,563,2,4,1,2,3,17,18,226,228,230,231,233,241,248,249,252,4,1,3,234,251,256,2,4,1,2,3,17,296,297,298,299,300,301,302,303,561,562,582,4) AND type = 'review' 302. SELECT FIELD.fieldid AS `Field.field_id`, FIELD.groupid AS `Field.group_id`, FIELD.name AS `Field.name`, FIELD.title AS `Field.title`, FIELD.showtitle AS `Field.showTitle`, FIELD.description AS `Field.description`, FIELD.required AS `Field.required`, FIELD.type AS `Field.type`, FIELD.location AS `Field.location`, FIELD.options AS `Field.params`, FIELD.contentview AS `Field.contentView`, FIELD.listview AS `Field.listView`, FIELD.compareview AS `Field.compareView`, FIELD.listsort AS `Field.listSort`, FIELD.search AS `Field.search`, FIELD.access AS `Field.access`, FIELD.access_view AS `Field.accessView`, FIELD.published AS `Field.published`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle` FROM jos_jreviews_fields AS FIELD INNER JOIN jos_jreviews_groups AS `Group` ON (`Group`.groupid = FIELD.groupid AND `Group`.groupid IN (4) AND `Group`.type = 'review' ) WHERE FIELD.location = 'review' AND FIELD.published = 1 ORDER BY GROUP.ordering, FIELD.ordering 303. SELECT * FROM jos_jreviews_fieldoptions WHERE fieldid = 21 ORDER BY ordering ASC ,optionid ASC 304. SELECT Review.reviewid AS element_id,jr_puntospositivos,jr_puntosnegativos,jr_recomendacion,jr_otro FROM jos_jreviews_review_fields AS Review WHERE Review.reviewid IN (10342,10341,10340,10339,10338,10337,10336,10335,10334) 305. SELECT COUNT(DISTINCT Review.id) FROM jos_jreviews_comments AS Review LEFT JOIN jos_jreviews_ratings AS Rating ON Review.id = Rating.reviewid LEFT JOIN jos_users AS User ON Review.userid = User.id WHERE 1 = 1 AND ( Review.published > 0 ) 306. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8322' 307. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8322' 308. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='6458' 309. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='6458' 310. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=524' AND published=1 AND id='113' 311. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='524' 312. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8105' 313. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8105' 314. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=327' AND published=1 AND id='113' 315. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='327' 316. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2617' 317. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='2617' 318. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8242' 319. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8242' 320. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=427' AND published=1 AND id='113' 321. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='427' 322. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8628' 323. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8628' 324. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 325. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='674' 326. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8299' 327. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8299' 328. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 329. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8027' 330. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8027' 331. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=324' AND published=1 AND id='113' 332. 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, a.`profile_id` AS _profile_id, a.`storage` AS _storage, a.`watermark_hash` AS _watermark_hash, 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`='324' 333. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8015' 334. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='8015' 335. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=profile&userid=674' AND published=1 AND id='113' 336. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=frontpage' AND published=1 337. SELECT parent, alias AS name FROM jos_menu WHERE link='index.php?option=com_community&view=register' AND published=1 338. SELECT parent, alias AS name FROM jos_menu WHERE id='102' 339. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='192' 340. SELECT i.id AS article_id, i.title AS article, DATE_FORMAT(i.created,'%Y%m%d') AS article_date, c.title AS category, s.title AS section FROM jos_content AS i LEFT JOIN jos_categories AS c ON i.catid=c.id LEFT JOIN jos_sections AS s ON c.section=s.id WHERE i.id='191' 341. SELECT count(id) FROM jos_menu WHERE link LIKE 'index.php?option=com_contact&view=contact&id=%' AND published = 1 342. SELECT title FROM jos_categories WHERE id=12 343. SELECT name FROM jos_contact_details WHERE id=1-name