this happens when I try to delete an element of the cart:
Speichernutzung
8931100
17 Abfragen protokolliert
SELECT *
FROM jos_session
WHERE session_id = 'd2acf491502d0941b51e270eb34d1a23'
DELETE
FROM jos_session
WHERE ( time < '1319018908' )
SELECT *
FROM jos_session
WHERE session_id = 'd2acf491502d0941b51e270eb34d1a23'
UPDATE `jos_session`
SET `time`='1319090908',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='1',`data`='__default|a:9:{s:15:\"session.counter\";i:41;s:19:\"session.timer.start\";i:1319049586;s:18:\"session.timer.last\";i:1319090902;s:17:\"session.timer.now\";i:1319090908;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:6:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:11:\"application\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}}s:10:\"com_cpanel\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:9:\"mtupgrade\";O:8:\"stdClass\":1:{s:7:\"checked\";b:1;}}}s:6:\"global\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"limit\";s:2:\"20\";}}}s:13:\"com_installer\";a:1:{s:4:\"data\";O:8:\"stdClass\":2:{s:10:\"limitstart\";O:8:\"stdClass\":4:{s:6:\"module\";i:0;s:6:\"plugin\";i:0;s:8:\"language\";i:0;s:8:\"template\";i:0;}s:9:\"templates\";O:8:\"stdClass\":1:{s:6:\"client\";s:2:\"-1\";}}}s:12:\"com_hikashop\";a:1:{s:4:\"data\";O:8:\"stdClass\":1:{s:8:\"category\";O:8:\"stdClass\":7:{s:9:\"filter_id\";s:2:\"30\";s:12:\"filter_order\";s:19:\"a.category_ordering\";s:16:\"filter_order_Dir\";s:3:\"asc\";s:10:\"limitstart\";i:0;s:6:\"search\";s:0:\"\";s:10:\"list_limit\";s:2:\"20\";s:11:\"filter_type\";i:0;}}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"erleseneweine@gmail.com\";s:8:\"password\";s:65:\"2b969b0fd2de2549592102a319821522:Weg6dbYBD3WvnmK82aoFHZwW1yWZXs7h\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-11-17 10:37:34\";s:13:\"lastvisitDate\";s:19:\"2011-10-19 18:46:30\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:56:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;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:81:\"/home/die-besten-weine-der-welt-de/htdocs/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\":5:{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:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"595a055a2237f09c74a9e02701f223ae\";s:17:\"application.queue\";a:1:{i:0;a:2:{s:7:\"message\";s:48:\"Die Konfiguration wurde erfolgreich gespeichert!\";s:4:\"type\";s:7:\"message\";}}}'
WHERE session_id='d2acf491502d0941b51e270eb34d1a23'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 1
ORDER BY position, ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 1
AND menuid = 0
SELECT COUNT(*)
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT username, time, userid, usertype, client_id
FROM jos_session
WHERE userid != 0
ORDER BY usertype, username
SELECT a.hits, a.id, a.sectionid, a.title, a.created, u.name
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id=a.created_by
WHERE a.state <> -2
ORDER BY hits DESC
LIMIT 0, 10
SELECT a.id, a.sectionid, a.title, a.created, a.modified, u.name, a.created_by_alias, a.created_by
FROM jos_content AS a
LEFT JOIN jos_users AS u
ON u.id = a.created_by
WHERE a.state <> -2
ORDER BY created DESC
LIMIT 0, 10
SELECT menutype, COUNT(id) AS numitems
FROM jos_menu
WHERE published = 1
GROUP BY menutype
SELECT a.*, SUM(b.home) AS home
FROM jos_menu_types AS a
LEFT JOIN jos_menu AS b
ON b.menutype = a.menutype
GROUP BY a.id
SELECT *
FROM jos_components
WHERE `option` <> "com_frontpage"
AND `option` <> "com_media"
AND enabled = 1
ORDER BY ordering, name
SELECT COUNT(*)
FROM jos_messages
WHERE state = 0
AND user_id_to = 62
SELECT COUNT( session_id )
FROM jos_session
WHERE guest <> 1
the following happens, when I try to hit the next button in the cart/checkout process:
SELECT *
FROM jos_session
WHERE session_id = '0f8e60921b7bf819ed5692237a750620'
DELETE
FROM jos_session
WHERE ( time < '1319019109' )
SELECT *
FROM jos_session
WHERE session_id = '0f8e60921b7bf819ed5692237a750620'
UPDATE `jos_session`
SET `time`='1319091109',`userid`='62',`usertype`='Super Administrator',`username`='admin',`gid`='25',`guest`='0',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:58;s:19:\"session.timer.start\";i:1319027777;s:18:\"session.timer.last\";i:1319090859;s:17:\"session.timer.now\";i:1319090917;s:22:\"session.client.browser\";s:74:\"Mozilla/5.0 (Windows NT 6.1; WOW64; rv:7.0.1) Gecko/20100101 Firefox/7.0.1\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:2:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}s:12:\"com_hikashop\";a:1:{s:4:\"data\";O:8:\"stdClass\":13:{s:7:\"cart_id\";i:245;s:11:\"currency_id\";i:1;s:7:\"user_id\";i:1;s:16:\"shipping_address\";s:1:\"6\";s:15:\"billing_address\";s:1:\"6\";s:15:\"shipping_method\";s:6:\"manual\";s:11:\"shipping_id\";s:1:\"1\";s:13:\"shipping_data\";O:8:\"stdClass\":17:{s:11:\"shipping_id\";s:1:\"1\";s:13:\"shipping_type\";s:6:\"manual\";s:21:\"shipping_zone_namekey\";s:18:\"country_Germany_81\";s:15:\"shipping_tax_id\";s:2:\"12\";s:14:\"shipping_price\";s:7:\"5.88000\";s:20:\"shipping_currency_id\";s:1:\"1\";s:13:\"shipping_name\";s:18:\"DHL Paket National\";s:20:\"shipping_description\";s:0:\"\";s:18:\"shipping_published\";s:1:\"1\";s:17:\"shipping_ordering\";s:1:\"1\";s:15:\"shipping_params\";O:8:\"stdClass\":8:{s:18:\"shipping_min_price\";s:0:\"\";s:18:\"shipping_max_price\";s:0:\"\";s:19:\"shipping_min_weight\";s:0:\"\";s:19:\"shipping_max_weight\";s:0:\"\";s:20:\"shipping_weight_unit\";s:2:\"kg\";s:19:\"shipping_min_volume\";s:0:\"\";s:19:\"shipping_max_volume\";s:0:\"\";s:18:\"shipping_size_unit\";s:1:\"m\";}s:15:\"shipping_images\";s:0:\"\";s:15:\"shipping_access\";s:3:\"all\";s:23:\"shipping_price_with_tax\";d:7;s:19:\"shipping_price_orig\";d:0;s:28:\"shipping_price_orig_with_tax\";d:0;s:5:\"total\";O:8:\"stdClass\":1:{s:6:\"prices\";a:1:{i:0;O:8:\"stdClass\":7:{s:28:\"price_value_without_discount\";d:0;s:11:\"price_value\";d:6536.8799999999964711605571210384368896484375;s:37:\"price_value_without_discount_with_tax\";d:0;s:20:\"price_value_with_tax\";d:7777.0000000000027284841053187847137451171875;s:17:\"price_currency_id\";i:1;s:37:\"price_value_without_shipping_with_tax\";d:7770.0000000000027284841053187847137451171875;s:28:\"price_value_without_shipping\";d:6530.99999999999636202119290828704833984375;}}}}s:14:\"payment_method\";s:6:\"paypal\";s:10:\"payment_id\";i:1;s:12:\"payment_data\";O:8:\"stdClass\":23:{s:10:\"payment_id\";s:1:\"1\";s:12:\"payment_name\";s:6:\"PayPal\";s:19:\"payment_description\";s:58:\"<p>Hier klicken, falls Sie per Paypal zahlen möchten.</p>\";s:14:\"payment_images\";s:0:\"\";s:14:\"payment_params\";O:8:\"stdClass\":12:{s:3:\"url\";s:37:\"https://www.paypal.com/cgi-bin/webscr\";s:5:\"email\";s:33:\"info@die-besten-weine-der-welt.de\";s:12:\"address_type\";s:8:\"shipping\";s:12:\"notification\";s:1:\"1\";s:5:\"debug\";s:1:\"1\";s:10:\"cancel_url\";s:0:\"\";s:10:\"return_url\";s:0:\"\";s:16:\"cpp_header_image\";s:0:\"\";s:3:\"ips\";a:4:{i:0;s:10:\"64.4.241.*\";i:1;s:12:\"66.211.169.*\";i:2;s:12:\"66.211.170.*\";i:3;s:13:\"216.113.191.*\";}s:14:\"invalid_status\";s:9:\"cancelled\";s:14:\"pending_status\";s:7:\"created\";s:15:\"verified_status\";s:9:\"confirmed\";}s:12:\"payment_type\";s:6:\"paypal\";s:20:\"payment_zone_namekey\";s:0:\"\";s:14:\"payment_access\";s:3:\"all\";s:24:\"payment_shipping_methods\";s:0:\"\";s:16:\"payment_currency\";s:0:\"\";s:2:\"id\";s:2:\"45\";s:4:\"name\";s:30:\"HikaShop Paypal payment plugin\";s:7:\"element\";s:6:\"paypal\";s:6:\"folder\";s:15:\"hikashoppayment\";s:6:\"access\";s:1:\"0\";s:8:\"ordering\";s:1:\"0\";s:9:\"published\";s:1:\"1\";s:6:\"iscore\";s:1:\"0\";s:9:\"client_id\";s:1:\"0\";s:11:\"checked_out\";s:1:\"0\";s:16:\"checked_out_time\";s:19:\"0000-00-00 00:00:00\";s:6:\"params\";s:0:\"\";s:7:\"enabled\";s:1:\"1\";}s:14:\"checkout_terms\";s:1:\"1\";s:12:\"ssl_redirect\";i:0;}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";s:2:\"62\";s:4:\"name\";s:13:\"Administrator\";s:8:\"username\";s:5:\"admin\";s:5:\"email\";s:23:\"erleseneweine@gmail.com\";s:8:\"password\";s:65:\"2b969b0fd2de2549592102a319821522:Weg6dbYBD3WvnmK82aoFHZwW1yWZXs7h\";s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";s:19:\"Super Administrator\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:3:\"gid\";s:2:\"25\";s:12:\"registerDate\";s:19:\"2010-11-17 10:37:34\";s:13:\"lastvisitDate\";s:19:\"2011-10-16 08:31:06\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:56:\"admin_language=\nlanguage=\neditor=\nhelpsite=\ntimezone=0\n\n\";s:3:\"aid\";i:2;s:5:\"guest\";i:0;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:81:\"/home/die-besten-weine-der-welt-de/htdocs/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\":5:{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:1:\"0\";}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"c7e9560ed204b11843e25567259ca0a4\";}'
WHERE session_id='0f8e60921b7bf819ed5692237a750620'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 2
ORDER BY ordering
SELECT m.*, c.`option` AS component
FROM jos_menu AS m
LEFT JOIN jos_components AS c
ON m.componentid = c.id
WHERE m.published = 1
ORDER BY m.sublevel, m.parent, m.ordering
SELECT *
FROM jos_hikashop_config
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 245
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
UPDATE `jos_hikashop_cart`
SET `user_id`='62',`session_id`='0f8e60921b7bf819ed5692237a750620',`cart_modified`='1319091110'
WHERE cart_id='245'
SELECT *
FROM jos_hikashop_product
WHERE product_id = '33'
LIMIT 1
INSERT INTO jos_hikashop_cart_product (cart_id,cart_product_modified,product_id,cart_product_parent_id,cart_product_quantity,cart_product_option_parent_id)
VALUES (245,1319091110,33,0,12,0)
SELECT a.*
FROM jos_hikashop_cart AS a
WHERE a.cart_id = 245
ORDER BY a.cart_modified DESC
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT currency_id
FROM jos_hikashop_currency
WHERE currency_published=1 OR currency_id = 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_zone
WHERE zone_namekey = 'country_Germany_81'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type = 'product'
SELECT a.*,b.*
FROM jos_hikashop_variant AS a
LEFT JOIN jos_hikashop_characteristic AS b
ON a.variant_characteristic_id=b.characteristic_id
WHERE a.variant_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY a.ordering,b.characteristic_value
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_currency
WHERE currency_id IN (1)
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_category AS a
LEFT JOIN jos_hikashop_taxation AS b
ON a.category_namekey=b.category_namekey
LEFT JOIN jos_hikashop_tax AS c
ON b.tax_namekey=c.tax_namekey
WHERE a.category_id = 12
AND b.taxation_published=1
AND ( taxation_type = '' OR taxation_type = 'individual' )
SELECT *
FROM jos_hikashop_zone
WHERE zone_id = 81
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type='product'
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_field AS a
WHERE a.`field_published` = 1
AND a.`field_frontcomp` = 1
AND a.field_table='address'
ORDER BY a.`field_ordering` ASC
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Germany_81');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Ger_203338886','payment_EU_1779881374','payment_WW_906302993','tax_europe_9728');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('payment_EU_1352161813');
SELECT *
FROM jos_hikashop_shipping
ORDER BY shipping_ordering ASC
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 0)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type = 'product'
SELECT a.*,b.*
FROM jos_hikashop_variant AS a
LEFT JOIN jos_hikashop_characteristic AS b
ON a.variant_characteristic_id=b.characteristic_id
WHERE a.variant_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY a.ordering,b.characteristic_value
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )
SELECT *
FROM jos_hikashop_file
WHERE file_ref_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
AND file_type='product'
ORDER BY file_id ASC
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Germany_81');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('country_Ger_203338886','payment_EU_1779881374','payment_WW_906302993','tax_europe_9728');
SELECT a.*
FROM jos_hikashop_zone_link AS a
WHERE a.zone_child_namekey IN ('payment_EU_1352161813');
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT *
FROM jos_hikashop_payment
WHERE (payment_shipping_methods IN ('','_') OR payment_shipping_methods LIKE '%manual_1%')
AND (payment_currency IN ('','_','all') OR payment_currency LIKE '%,1,%')
SELECT *,published AS enabled
FROM jos_plugins
WHERE element IN ('paypal','collectondelivery','banktransfer')
AND folder='hikashoppayment'
ORDER BY ordering ASC
SELECT id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 2
AND m.client_id = 0
AND ( mm.menuid = 0 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT *
FROM jos_hikashop_address
WHERE address_id = '6'
LIMIT 1
SELECT b.*,c.*
FROM jos_hikashop_cart_product AS b
LEFT JOIN jos_hikashop_product AS c
ON b.product_id=c.product_id
WHERE b.cart_id = 245
AND b.product_id > 0
ORDER BY c.product_parent_id ASC,b.cart_product_modified ASC
SELECT *
FROM jos_hikashop_price
WHERE price_currency_id IN (1,2)
AND price_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33)
ORDER BY price_value DESC
SELECT *
FROM jos_hikashop_discount
WHERE discount_type='discount'
AND discount_published=1
AND ( discount_quota>discount_used_times OR discount_quota=0 )
AND discount_start < 1319091110
AND ( discount_end > 1319091110 OR discount_end = 0 )
AND ( discount_product_id IN (33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33,33) OR discount_product_id=0 )
AND discount_zone_id IN (0,81)
AND ( discount_flat_amount!=0 OR discount_percent_amount!=0 )