I have turned on debug mode on Joomla, however when I press the comment buttpn the page is blank without any debug report? Really strange
Here is the debug report of following page
www.sporthaus1.de/blog.html
SELECT *
FROM jos1514_session
WHERE session_id = '1a600d2c441aaad31e841640498be00d'
DELETE
FROM jos1514_session
WHERE ( time < '1342294285' )
SELECT *
FROM jos1514_session
WHERE session_id = '1a600d2c441aaad31e841640498be00d'
UPDATE `jos1514_session`
SET `time`='1342295185',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1342294879;s:18:\"session.timer.last\";i:1342294884;s:17:\"session.timer.now\";i:1342295018;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20100101 Firefox/13.0.1\";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\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";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:60:\"/www/htdocs/w00ebe4b/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:13:\"session.token\";s:32:\"3ceb35b3fb85ad5b9f0a5cc6faff407c\";}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";fakeItemid|s:1:\"1\";vmMiniCart|b:1;product_sess|a:12:{i:2599;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"5.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:732;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"4.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:2960;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"24.05\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1944;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"20.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:986;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:6:\"146.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:2424;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.96\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:3609;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"7.45\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1552;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"14.99\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:782;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"1.50\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1756;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"5.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:3215;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.95\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:652;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.95\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}}'
WHERE session_id='1a600d2c441aaad31e841640498be00d'
SELECT *
FROM jos1514_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos1514_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT name,player_id,ripper_id,postreplace
FROM jos1514_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jos1514_avr_tags
SELECT *
FROM jos1514_ccvaom_configuration
LIMIT 1
SELECT *
FROM jos1514_migration_backlinks
WHERE url LIKE 'blog.html%' OR sefurl LIKE 'blog.html%'
SELECT template
FROM jos1514_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 415)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT m.*
FROM jos1514_modules AS m
LEFT JOIN jos1514_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 = 415 OR mm.menuid = 0 )
ORDER BY m.position, m.ordering
SELECT group_id,group_name,group_level
FROM `jos1514_vm_auth_group`
ORDER BY group_level
SELECT jos1514_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `jos1514_vm_shopper_group`
WHERE jos1514_vm_shopper_group.vendor_id='1'
AND `default`='1'
SELECT `lft`, `rgt`
FROM `jos1514_core_acl_aro_groups`
WHERE `name`='Public Frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos1514_core_acl_aro_groups AS g1
INNER JOIN jos1514_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 12
GROUP BY g1.name
ORDER BY g1.lft
SELECT `lft`, `rgt`
FROM `jos1514_core_acl_aro_groups`
WHERE `name`='Public Backend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos1514_core_acl_aro_groups AS g1
INNER JOIN jos1514_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 13
AND 20
GROUP BY g1.name
ORDER BY g1.lft
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
FROM (`jos1514_vm_vendor` v, `jos1514_vm_country` c)
LEFT JOIN jos1514_vm_state s
ON (v.vendor_state=s.state_2_code
AND s.country_id=c.country_id)
WHERE `v`.`vendor_id`=1
AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT *
FROM jos1514_vm_magiczoomplus_config
SELECT *
FROM jos1514_acymailing_config
SELECT *
FROM jos1514_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",cc.id,cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos1514_content AS a
INNER JOIN jos1514_categories AS cc
ON cc.id = a.catid
INNER JOIN jos1514_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-07-14 19:46:25' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-07-14 19:46:25' )
AND a.access <= 0
AND a.catid IN ("69")
ORDER BY a.ordering DESC
LIMIT 15
SELECT *
FROM jos1514_content
WHERE id = '274'
SELECT *
FROM jos1514_content
WHERE id = '275'
SELECT *
FROM jos1514_content
WHERE id = '280'
SELECT *
FROM jos1514_content
WHERE id = '281'
SELECT *
FROM jos1514_content
WHERE id = '282'
SELECT *
FROM jos1514_content
WHERE id = '283'
SELECT *
FROM jos1514_content
WHERE id = '284'
SELECT *
FROM jos1514_content
WHERE id = '285'
SELECT *
FROM jos1514_content
WHERE id = '286'
SELECT *
FROM jos1514_content
WHERE id = '287'
SELECT *
FROM jos1514_content
WHERE id = '288'
SELECT *
FROM jos1514_content
WHERE id = '289'
35 Abfragen im Legacy-Modus protokolliert
SELECT *
FROM jos1514_session
WHERE session_id = '1a600d2c441aaad31e841640498be00d'
DELETE
FROM jos1514_session
WHERE ( time < '1342294285' )
SELECT *
FROM jos1514_session
WHERE session_id = '1a600d2c441aaad31e841640498be00d'
UPDATE `jos1514_session`
SET `time`='1342295185',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:3;s:19:\"session.timer.start\";i:1342294879;s:18:\"session.timer.last\";i:1342294884;s:17:\"session.timer.now\";i:1342295018;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:13.0) Gecko/20100101 Firefox/13.0.1\";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\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:15:\"Public Frontend\";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:60:\"/www/htdocs/w00ebe4b/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:13:\"session.token\";s:32:\"3ceb35b3fb85ad5b9f0a5cc6faff407c\";}auth|a:11:{s:11:\"show_prices\";i:1;s:7:\"user_id\";i:0;s:8:\"username\";s:4:\"demo\";s:5:\"perms\";s:0:\"\";s:10:\"first_name\";s:5:\"guest\";s:9:\"last_name\";s:0:\"\";s:16:\"shopper_group_id\";s:1:\"5\";s:22:\"shopper_group_discount\";s:4:\"0.00\";s:24:\"show_price_including_tax\";s:1:\"1\";s:21:\"default_shopper_group\";i:1;s:22:\"is_registered_customer\";b:0;}cart|a:1:{s:3:\"idx\";i:0;}recent|a:1:{s:3:\"idx\";i:0;}ps_vendor_id|i:1;minimum_pov|s:4:\"0.00\";vendor_currency|s:3:\"EUR\";fakeItemid|s:1:\"1\";vmMiniCart|b:1;product_sess|a:12:{i:2599;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"5.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:732;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"4.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:2960;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"24.05\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294879;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1944;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"20.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:986;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:6:\"146.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:2424;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.96\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:3609;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"7.45\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1552;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:5:\"14.99\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:782;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"1.50\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:1756;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"5.00\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:3215;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.95\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}i:652;a:4:{s:7:\"flypage\";s:11:\"flypage.tpl\";s:13:\"discount_info\";a:3:{s:6:\"amount\";s:4:\"9.95\";s:10:\"is_percent\";s:1:\"0\";s:11:\"create_time\";i:1342294880;}s:9:\"vendor_id\";s:1:\"1\";s:8:\"tax_rate\";s:6:\"0.1900\";}}'
WHERE session_id='1a600d2c441aaad31e841640498be00d'
SELECT *
FROM jos1514_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos1514_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT name,player_id,ripper_id,postreplace
FROM jos1514_avr_tags
SELECT name,player_id,ripper_id,postreplace
FROM jos1514_avr_tags
SELECT *
FROM jos1514_ccvaom_configuration
LIMIT 1
SELECT *
FROM jos1514_migration_backlinks
WHERE url LIKE 'blog.html%' OR sefurl LIKE 'blog.html%'
SELECT template
FROM jos1514_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 415)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT m.*
FROM jos1514_modules AS m
LEFT JOIN jos1514_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 = 415 OR mm.menuid = 0 )
ORDER BY m.position, m.ordering
SELECT group_id,group_name,group_level
FROM `jos1514_vm_auth_group`
ORDER BY group_level
SELECT jos1514_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `jos1514_vm_shopper_group`
WHERE jos1514_vm_shopper_group.vendor_id='1'
AND `default`='1'
SELECT `lft`, `rgt`
FROM `jos1514_core_acl_aro_groups`
WHERE `name`='Public Frontend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos1514_core_acl_aro_groups AS g1
INNER JOIN jos1514_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 3
AND 12
GROUP BY g1.name
ORDER BY g1.lft
SELECT `lft`, `rgt`
FROM `jos1514_core_acl_aro_groups`
WHERE `name`='Public Backend'
SELECT g1.id, g1.name, COUNT(g2.name) AS level
FROM jos1514_core_acl_aro_groups AS g1
INNER JOIN jos1514_core_acl_aro_groups AS g2
ON g1.lft BETWEEN g2.lft
AND g2.rgt
WHERE g1.lft BETWEEN 13
AND 20
GROUP BY g1.name
ORDER BY g1.lft
SELECT vendor_id, vendor_min_pov,vendor_name,vendor_store_name,contact_email,vendor_full_image, vendor_freeshipping,
vendor_address_1,vendor_address_2, vendor_url, vendor_city, vendor_state, vendor_country, country_2_code, country_3_code,
vendor_zip, vendor_phone, vendor_store_desc, vendor_currency, vendor_currency_display_style,
vendor_accepted_currencies, vendor_address_format, vendor_date_format, state_name
FROM (`jos1514_vm_vendor` v, `jos1514_vm_country` c)
LEFT JOIN jos1514_vm_state s
ON (v.vendor_state=s.state_2_code
AND s.country_id=c.country_id)
WHERE `v`.`vendor_id`=1
AND (`v`.`vendor_country`=`c`.`country_2_code` OR `v`.`vendor_country`=`c`.`country_3_code`);
SELECT *
FROM jos1514_vm_magiczoomplus_config
SELECT *
FROM jos1514_acymailing_config
SELECT *
FROM jos1514_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASC
SELECT a.*,cc.description AS catdesc, cc.title AS cattitle,s.description AS secdesc, s.title AS sectitle, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":",cc.id,cc.alias) ELSE cc.id END AS catslug, CASE WHEN CHAR_LENGTH(s.alias) THEN CONCAT_WS(":", s.id, s.alias) ELSE s.id END AS secslug
FROM jos1514_content AS a
INNER JOIN jos1514_categories AS cc
ON cc.id = a.catid
INNER JOIN jos1514_sections AS s
ON s.id = a.sectionid
WHERE a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-07-14 19:46:25' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-07-14 19:46:25' )
AND a.access <= 0
AND a.catid IN ("69")
ORDER BY a.ordering DESC
LIMIT 15
SELECT *
FROM jos1514_content
WHERE id = '274'
SELECT *
FROM jos1514_content
WHERE id = '275'
SELECT *
FROM jos1514_content
WHERE id = '280'
SELECT *
FROM jos1514_content
WHERE id = '281'
SELECT *
FROM jos1514_content
WHERE id = '282'
SELECT *
FROM jos1514_content
WHERE id = '283'
SELECT *
FROM jos1514_content
WHERE id = '284'
SELECT *
FROM jos1514_content
WHERE id = '285'
SELECT *
FROM jos1514_content
WHERE id = '286'
SELECT *
FROM jos1514_content
WHERE id = '287'
SELECT *
FROM jos1514_content
WHERE id = '288'
SELECT *
FROM jos1514_content
WHERE id = '289'