I got this error...plz help
500 - An error has occurred.
JDatabaseMySQL::query: 1054 - Unknown column 'c.category_description' in 'field list' SQL=SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id` WHERE c.`published` = 1 AND cx.`category_parent_id` = 0 ORDER BY c.category_name ASC
Return to Control Panel
Call stack
# Function Location
1 JAdministrator->dispatch() /home/smilyo/public_html/saini/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/smilyo/public_html/saini/administrator/includes/application.php:153
3 require_once() /home/smilyo/public_html/saini/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/admin.virtuemart.php:61
5 VirtuemartControllerProduct->Product() /home/smilyo/public_html/saini/libraries/joomla/application/component/controller.php:684
6 VirtuemartViewProduct->display() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/controllers/product.php:68
7 ShopFunctions->categoryListTree() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/views/product/view.html.php:257
8 ShopFunctions->categoryListTreeLoop() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:628
9 VirtueMartModelCategory->getCategories() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:657
10 VmModel->exeSortSearchListQuery() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/models/category.php:288
11 JDatabase->loadObjectList() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/vmmodel.php:376
12 JDatabaseMySQLi->query() /home/smilyo/public_html/saini/libraries/joomla/database/database.php:975
13 JError::raiseError() /home/smilyo/public_html/saini/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home/smilyo/public_html/saini/libraries/joomla/error/error.php:250
Errors
JDatabaseMySQL::query: 1054 - Unknown column 'c.category_description' in 'field list' SQL=SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id` WHERE c.`published` = 1 AND cx.`category_parent_id` = 0 ORDER BY c.category_name ASC
Information
Backtrace
Call stack
# Function Location
1 JAdministrator->dispatch() /home/smilyo/public_html/saini/administrator/index.php:47
2 JComponentHelper::renderComponent() /home/smilyo/public_html/saini/administrator/includes/application.php:153
3 require_once() /home/smilyo/public_html/saini/libraries/joomla/application/component/helper.php:156
4 JController->execute() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/admin.virtuemart.php:61
5 VirtuemartControllerProduct->Product() /home/smilyo/public_html/saini/libraries/joomla/application/component/controller.php:684
6 VirtuemartViewProduct->display() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/controllers/product.php:68
7 ShopFunctions->categoryListTree() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/views/product/view.html.php:257
8 ShopFunctions->categoryListTreeLoop() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:628
9 VirtueMartModelCategory->getCategories() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/shopfunctions.php:657
10 VmModel->exeSortSearchListQuery() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/models/category.php:288
11 JDatabase->loadObjectList() /home/smilyo/public_html/saini/administrator/components/com_virtuemart/helpers/vmmodel.php:376
12 JDatabaseMySQLi->query() /home/smilyo/public_html/saini/libraries/joomla/database/database.php:975
13 JError::raiseError() /home/smilyo/public_html/saini/libraries/joomla/database/database/mysqli.php:535
14 JError::raise() /home/smilyo/public_html/saini/libraries/joomla/error/error.php:250
Profile Information
Application 0.001 seconds (+0.001); 0.51 MB (+0.515) - afterLoad
Application 0.044 seconds (+0.042); 3.30 MB (+2.789) - afterInitialise
Application 0.044 seconds (+0.000); 3.30 MB (+0.000) - afterRoute
Memory Usage
7.48 MB (7,840,140 Bytes)
17 Queries Logged
SELECT `data`
FROM `z2re8_session`
WHERE `session_id` = '483f5b6e8baa294df133ac87ce7088ac'
SELECT extension_id AS "id", element AS "option", params, enabled
FROM z2re8_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT folder AS type, element AS name, params
FROM z2re8_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1,2,3)
ORDER BY ordering
SELECT template, s.params
FROM z2re8_template_styles as s
LEFT JOIN z2re8_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
WHERE s.client_id = 1
AND home = 1
ORDER BY home
SELECT extension_id AS "id", element AS "option", params, enabled
FROM z2re8_extensions
WHERE `type` = 'component'
AND `element` = 'com_virtuemart'
SELECT `config`
FROM `z2re8_virtuemart_configs`
WHERE `virtuemart_config_id` = "1"
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_products`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_medias`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_ratings`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_categories`
SHOW FULL COLUMNS
FROM `z2re8_virtuemart_vendors`
SELECT SQL_CALC_FOUND_ROWS *
FROM `z2re8_virtuemart_products` AS p
ORDER BY p.virtuemart_product_id
LIMIT 0, 10
SELECT FOUND_ROWS()
SELECT `virtuemart_permgroup_id`,`group_name`,`group_level`
FROM `z2re8_virtuemart_permgroups`
ORDER BY `group_level`
SELECT `perms`
FROM z2re8_virtuemart_vmusers
WHERE virtuemart_user_id="42"
SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared`
FROM `z2re8_virtuemart_categories` AS c
LEFT JOIN `z2re8_virtuemart_category_categories` AS cx
ON c.`virtuemart_category_id` = cx.`category_child_id`
WHERE c.`published` = 1
AND cx.`category_parent_id` = 0
ORDER BY c.category_name ASC
UPDATE `z2re8_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:130;s:19:\"session.timer.start\";i:1323149931;s:18:\"session.timer.last\";i:1323153629;s:17:\"session.timer.now\";i:1323153636;s:22:\"session.client.browser\";s:99:\"Mozilla/5.0 (Windows NT 6.1) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.121 Safari/535.2\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":10:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:11:\"com_modules\";O:8:\"stdClass\":1:{s:7:\"modules\";O:8:\"stdClass\":1:{s:6:\"filter\";O:8:\"stdClass\":1:{s:18:\"client_id_previous\";i:0;}}}s:13:\"com_installer\";O:8:\"stdClass\":4:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:12:\"redirect_url\";N;s:6:\"manage\";O:8:\"stdClass\":4:{s:4:\"data\";a:1:{s:7:\"filters\";a:6:{s:6:\"search\";s:0:\"\";s:13:\"hideprotected\";s:1:\"1\";s:9:\"client_id\";s:0:\"\";s:7:\"enabled\";s:0:\"\";s:4:\"type\";s:8:\"template\";s:5:\"
group\";s:0:\"\";}}s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:4:\"name\";s:9:\"orderdirn\";s:3:\"asc\";}}s:11:\"com_content\";O:8:\"stdClass\":1:{s:4:\"edit\";O:8:\"stdClass\":1:{s:7:\"article\";O:8:\"stdClass\":2:{s:4:\"data\";N;s:2:\"id\";a:0:{}}}}s:9:\"com_menus\";O:8:\"stdClass\":2:{s:5:\"items\";O:8:\"stdClass\":2:{s:6:\"filter\";O:8:\"stdClass\":1:{s:8:\"menutype\";s:8:\"mainmenu\";}s:10:\"limitstart\";i:0;}s:4:\"edit\";O:8:\"stdClass\":1:{s:4:\"item\";O:8:\"stdClass\":4:{s:2:\"id\";a:0:{}s:4:\"data\";N;s:4:\"type\";N;s:4:\"link\";N;}}}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
limit\";i:10;}}s:22:\"com_virtuemartcategory\";O:8:\"stdClass\":3:{s:10:\"limitstart\";i:0;s:12:\"filter_order\";s:24:\"c.virtuemart_category_id\";s:16:\"filter_order_Dir\";s:0:\"\";}s:13:\"com_templates\";O:8:\"stdClass\":1:{s:9:\"templates\";O:8:\"stdClass\":3:{s:10:\"limitstart\";s:1:\"0\";s:8:\"ordercol\";s:9:\"a.element\";s:9:\"orderdirn\";s:0:\"\";}}s:14:\"com_virtuemart\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":2:{s:5:\"
limit\";i:10;s:10:\"limitstart\";i:0;}}s:21:\"com_virtuemartproduct\";O:8:\"stdClass\":1:{s:10:\"limitstart\";i:0;}}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:1;s:2:\"id\";s:2:\"42\";s:4:\"name\";s:11:\"Pankaj Jain\";s:8:\"username\";s:14:\"thehitechpanky\";s:5:\"email\";s:27:\"best.adminwebsite@gmail.com\";s:8:\"password\";s:65:\"6e7a626a3f917a2c5a10027a5986b067:rzXQNmnZIUzJSDojRUE93h3EvQPFqEGX\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:10:\"deprecated\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2011-12-03 15:06:25\";s:13:\"lastvisitDate\";s:19:\"2011-12-03 17:30:53\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";s:6:\"groups\";a:1:{s:11:\"Super Users\";s:1:\"8\";}s:5:\"guest\";i:0;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\0*\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"7ae2f2b16ac242aeb30557ca4681779c\";}__vm|a:1:{s:8:\"vmconfig\";s:5952:\"a:152:{s:15:\"shop_is_offline\";s:1:\"0\";s:15:\"offline_message\";s:100:\"T3VyIFNob3AgaXMgY3VycmVudGx5IGRvd24gZm9yIG1haW50ZW5hbmNlLiBQbGVhc2UgY2hlY2sgYmFjayBhZ2FpbiBzb29uLg==\";s:14:\"use_as_catalog\";s:1:\"0\";s:25:\"currency_converter_module\";s:14:\"convertECB.php\";s:15:\"order_mail_html\";s:1:\"1\";s:10:\"dateformat\";s:12:\"JW0vJWQvJXk=\";s:6:\"useSSL\";s:1:\"0\";s:14:\"dangeroustools\";i:0;s:12:\"debug_enable\";s:4:\"none\";s:13:\"google_jquery\";s:1:\"1\";s:6:\"multix\";s:4:\"none\";s:17:\"pdf_button_enable\";s:1:\"1\";s:16:\"show_emailfriend\";s:1:\"1\";s:14:\"show_printicon\";s:1:\"0\";s:26:\"show_out_of_stock_products\";s:1:\"1\";s:14:\"coupons_enable\";s:1:\"0\";s:22:\"coupons_default_expire\";s:3:\"1,D\";s:19:\"weight_unit_default\";s:2:\"KG\";s:16:\"lwh_unit_default\";s:1:\"m\";s:10:\"list_limit\";s:2:\"10\";s:13:\"showReviewFor\";s:3:\"all\";s:10:\"reviewMode\";s:10:\"registered\";s:13:\"showRatingFor\";s:3:\"all\";s:10:\"ratingMode\";s:10:\"registered\";s:19:\"reviews_autopublish\";s:1:\"1\";s:30:\"reviews_minimum_comment_length\";s:3:\"100\";s:30:\"reviews_maximum_comment_length\";s:4:\"2000\";s:10:\"vmtemplate\";s:7:\"default\";s:16:\"categorytemplate\";s:7:\"default\";s:12:\"showCategory\";s:1:\"1\";s:14:\"categorylayout\";s:7:\"default\";s:18:\"categories_per_row\";s:1:\"3\";s:13:\"productlayout\";s:7:\"default\";s:16:\"products_per_row\";s:1:\"3\";s:8:\"vmlayout\";s:7:\"default\";s:13:\"show_featured\";s:1:\"1\";s:25:\"featured_products_per_row\";s:1:\"3\";s:11:\"show_topTen\";s:1:\"1\";s:23:\"topten_products_per_row\";s:1:\"3\";s:11:\"show_recent\";s:1:\"1\";s:11:\"show_latest\";s:1:\"1\";s:19:\"assets_general_path\";s:33:\"components/com_virtuemart/assets/\";s:19:\"media_category_path\";s:35:\"images/stories/virtuemart/category/\";s:18:\"media_product_path\";s:34:\"images/stories/virtuemart/product/\";s:23:\"media_manufacturer_path\";s:39:\"images/stories/virtuemart/manufacturer/\";s:17:\"media_vendor_path\";s:33:\"images/stories/virtuemart/vendor/\";s:17:\"img_resize_enable\";s:1:\"1\";s:9:\"img_width\";s:2:\"90\";s:10:\"img_height\";s:2:\"90\";s:12:\"no_image_set\";s:11:\"noimage.gif\";s:14:\"no_image_found\";s:11:\"warning.png\";s:20:\"browse_orderby_field\";s:23:\"p.virtuemart_product_id\";s:21:\"browse_orderby_fields\";a:4:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:9:\"m.mf_name\";i:3;s:14:\"p.product_name\";}s:20:\"browse_search_fields\";a:6:{i:0;s:13:\"p.product_sku\";i:1;s:15:\"c.category_name\";i:2;s:22:\"c.category_description\";i:3;s:9:\"m.mf_name\";i:4;s:14:\"p.product_name\";i:5;s:16:\"p.product_s_desc\";}s:11:\"show_prices\";s:1:\"1\";s:28:\"price_access_level_published\";s:1:\"0\";s:31:\"price_show_packaging_pricelabel\";s:1:\"0\";s:8:\"show_tax\";s:1:\"1\";s:9:\"basePrice\";s:1:\"1\";s:13:\"basePriceText\";s:1:\"1\";s:17:\"basePriceRounding\";s:1:\"2\";s:19:\"variantModification\";s:1:\"1\";s:23:\"variantModificationText\";s:1:\"1\";s:27:\"variantModificationRounding\";s:1:\"2\";s:16:\"basePriceVariant\";s:1:\"1\";s:20:\"basePriceVariantText\";s:1:\"1\";s:24:\"basePriceVariantRounding\";s:1:\"2\";s:16:\"basePriceWithTax\";s:1:\"1\";s:20:\"basePriceWithTaxText\";s:1:\"1\";s:24:\"basePriceWithTaxRounding\";s:1:\"2\";s:25:\"discountedPriceWithoutTax\";s:1:\"1\";s:29:\"discountedPriceWithoutTaxText\";s:1:\"1\";s:33:\"discountedPriceWithoutTaxRounding\";s:1:\"2\";s:22:\"salesPriceWithDiscount\";s:1:\"1\";s:26:\"salesPriceWithDiscountText\";s:1:\"1\";s:30:\"salesPriceWithDiscountRounding\";s:1:\"2\";s:10:\"salesPrice\";s:1:\"1\";s:14:\"salesPriceText\";s:1:\"1\";s:18:\"salesPriceRounding\";s:1:\"2\";s:15:\"priceWithoutTax\";s:1:\"1\";s:19:\"priceWithoutTaxText\";s:1:\"1\";s:23:\"priceWithoutTaxRounding\";s:1:\"2\";s:14:\"discountAmount\";s:1:\"1\";s:18:\"discountAmountText\";s:1:\"1\";s:22:\"discountAmountRounding\";s:1:\"2\";s:9:\"taxAmount\";s:1:\"1\";s:13:\"taxAmountText\";s:1:\"1\";s:17:\"taxAmountRounding\";s:1:\"2\";s:11:\"check_stock\";s:1:\"0\";s:17:\"automatic_payment\";s:1:\"1\";s:18:\"automatic_shipping\";s:1:\"1\";s:20:\"agree_to_tos_onorder\";s:1:\"0\";s:26:\"oncheckout_show_legal_info\";s:1:\"1\";s:24:\"oncheckout_show_register\";s:1:\"1\";s:21:\"oncheckout_show_steps\";s:1:\"0\";s:29:\"oncheckout_show_register_text\";s:47:\"COM_VIRTUEMART_ONCHECKOUT_DEFAULT_TEXT_REGISTER\";s:12:\"seo_disabled\";s:1:\"0\";s:13:\"seo_translate\";s:1:\"0\";s:10:\"seo_use_id\";s:1:\"0\";s:14:\"soap_ws_cat_on\";s:1:\"0\";s:20:\"soap_ws_cat_cache_on\";s:1:\"1\";s:16:\"soap_auth_getcat\";s:1:\"1\";s:16:\"soap_auth_addcat\";s:1:\"1\";s:15:\"soap_auth_upcat\";s:1:\"1\";s:16:\"soap_auth_delcat\";s:1:\"1\";s:22:\"soap_auth_cat_otherget\";s:1:\"1\";s:22:\"soap_auth_cat_otheradd\";s:1:\"1\";s:25:\"soap_auth_cat_otherupdate\";s:1:\"1\";s:25:\"soap_auth_cat_otherdelete\";s:1:\"1\";s:15:\"soap_ws_user_on\";s:1:\"0\";s:21:\"soap_ws_user_cache_on\";s:1:\"1\";s:17:\"soap_auth_getuser\";s:1:\"1\";s:17:\"soap_auth_adduser\";s:1:\"1\";s:16:\"soap_auth_upuser\";s:1:\"1\";s:17:\"soap_auth_deluser\";s:1:\"1\";s:23:\"soap_auth_user_otherget\";s:1:\"1\";s:23:\"soap_auth_user_otheradd\";s:1:\"1\";s:26:\"soap_auth_user_otherupdate\";s:1:\"1\";s:26:\"soap_auth_user_otherdelete\";s:1:\"1\";s:15:\"soap_ws_prod_on\";s:1:\"0\";s:21:\"soap_ws_prod_cache_on\";s:1:\"1\";s:17:\"soap_auth_getprod\";s:1:\"1\";s:17:\"soap_auth_addprod\";s:1:\"1\";s:16:\"soap_auth_upprod\";s:1:\"1\";s:17:\"soap_auth_delprod\";s:1:\"1\";s:23:\"soap_auth_prod_otherget\";s:1:\"1\";s:23:\"soap_auth_prod_otheradd\";s:1:\"1\";s:26:\"soap_auth_prod_otherupdate\";s:1:\"1\";s:26:\"soap_auth_prod_otherdelete\";s:1:\"1\";s:16:\"soap_ws_order_on\";s:1:\"0\";s:22:\"soap_ws_order_cache_on\";s:1:\"1\";s:18:\"soap_auth_getorder\";s:1:\"1\";s:18:\"soap_auth_addorder\";s:1:\"1\";s:17:\"soap_auth_uporder\";s:1:\"1\";s:18:\"soap_auth_delorder\";s:1:\"1\";s:24:\"soap_auth_order_otherget\";s:1:\"1\";s:24:\"soap_auth_order_otheradd\";s:1:\"1\";s:27:\"soap_auth_order_otherupdate\";s:1:\"1\";s:27:\"soap_auth_order_otherdelete\";s:1:\"1\";s:14:\"soap_ws_sql_on\";s:1:\"0\";s:20:\"soap_ws_sql_cache_on\";s:1:\"1\";s:17:\"soap_auth_execsql\";s:1:\"1\";s:24:\"soap_auth_execsql_select\";s:1:\"1\";s:24:\"soap_auth_execsql_insert\";s:1:\"1\";s:24:\"soap_auth_execsql_update\";s:1:\"1\";s:17:\"soap_ws_custom_on\";s:1:\"0\";s:23:\"soap_ws_custom_cache_on\";s:1:\"1\";s:14:\"soap_EP_custom\";s:24:\"VM_CustomizedService.php\";s:16:\"soap_wsdl_custom\";s:18:\"VM_Customized.wsdl\";s:6:\"sctime\";d:1323150358.0862081050872802734375;s:6:\"vmlang\";s:5:\"en_gb\";s:20:\"virtuemart_config_id\";i:1;}\";}__liveupdate|a:0:{}', `time` = 1323153636
WHERE `session_id` = '483f5b6e8baa294df133ac87ce7088ac'
16 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT extension_id AS "id", element AS "option", params, enabled FROM z2re8_extensions
1 × SELECT `virtuemart_permgroup_id`,`group_name`,`group_level` FROM `z2re8_virtuemart_permgroups`
1 × SELECT `perms` FROM z2re8_virtuemart_vmusers
1 × SELECT c.`virtuemart_category_id`, c.`category_description`, c.`category_name`, c.`ordering`, c.`published`, cx.`category_child_id`, cx.`category_parent_id`, c.`shared` FROM `z2re8_virtuemart_categories` AS c LEFT JOIN `z2re8_virtuemart_category_categories` AS cx ON c.`virtuemart_category_id` = cx.`category_child_id`
1 × SELECT FOUND_ROWS(
1 × SELECT `config` FROM `z2re8_virtuemart_configs`
1 × SELECT folder AS type, element AS name, params FROM z2re8_extensions
1 × SELECT template, s.params FROM z2re8_template_styles as s LEFT JOIN z2re8_extensions as e ON e.type='template' AND e.element=s.template AND e.client_id=s.client_id
1 × SELECT `data` FROM `z2re8_session`
1 × SELECT SQL_CALC_FOUND_ROWS * FROM `z2re8_virtuemart_products` AS p
OTHER Tables:
Home
Forum
Extensions
Developer Portal
