SELECT *
FROM jos_session
WHERE session_id = '46dc17b784444bb4fd930a3191b519ce'
DELETE
FROM jos_session
WHERE ( time < '1328554356' )
SELECT *
FROM jos_session
WHERE session_id = '46dc17b784444bb4fd930a3191b519ce'
UPDATE `jos_session`
SET `time`='1328555256',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='I3MMgWNfTPris6IvzZJE4gErYrDOTGJK_xu6eE65b2av2Ii0dI94OZ5ZaQmIGgG0FHYng27fm7crlT2fxTs0RJJfM5iFWrqohtBgfbjWxjXkXxn9WMd-s6eZBu6O1WBHL1mJIQ2673_9y9DmTBOu9Sq_CD0-L1tb8grWLv68jahiceTjkDCE02mwzzCCUZVwIu0BtsfH-15NW5IaThGTkJNOEJ_MOq4NZqJPw-v1VMW9voOKejRjQnoyebKwq_U4HOPsFFVVpvnIQxH0MYWYlSSRfR4tv8BA-kNJUjP1Xt-bZp_xwmraQtRe2NtmKn0YBR10rpBIajXEIlw1qhVzUBla_3vYM1AwWiVTAQ4QvRyNEUUTn-hOfDw7-YkLILeY882x5OGwADsl0H-VpaxCEm1ajeW4N9DRL4WejlMDmvhRUDDzsdp_O7ddjvNnMrtnkPHU-EWxBlDpcg2VT5l4c34wskySoATQFYDrB-WGSy0S9vDtQI_98mez3iyrl5-YS32NIafHRf5gyFf141Cl3Z1_Mbz_uhVuDOsnsuy8hBPdZfqqHJHKHbLwp89eDvHhzzs_2hmgMdkGX7sieNcqkaOV6dPb5FgiKqmgfpURiYwAIfPP5YlHgIQOE7RYzwQB9Ai0iEkbcVzqv7I6DUwCir-FC5CPXhIlbybiGSX3tKbwWsivhyyywU9HY2qlIc_Rz6_rmav5L70VKiRLGUVp_AV0BNxbchg1x0d6iUIxqp45rQlegDUIOuqZbk8NCPTZ1IwEHdBosajeGSybyHLPiaTUxC3fnCX0KuPbeFZAqHpSCEyYppNAl1VdJrC35M3VGX56M3zoklq9gufugPvA4_k3wQODjP8hVUUNxAX81GwkCfE0THJlQHElU8p-w9o8ql5FGjo81_uyLPMYAKwc59E3IsZ3M1bUFqVqlV4f-AxnXoh4w1QMos79wyS_RUi9FruN5ZxLG-Noxosh0RBBPkoqa1ShldvmGIOEXP1hpNE6dVs3gSA3bd2LGEmdSzhIkDkZKrQywQKu80z5mgd-bwVQgkgDDXCsoMe7n3kPVJ9rdcTQnqhS-XXnhRTC0qKA2CDm-ZCkYEBI3aeAfy3NKSKm7wxesvzPyAVwvtzW1E5CowsyhRNCm4q0eYty7Ksd8ElOlVm8c2962cH_z9J-U_3N7x4GRQpqNJx3BvSYi2nR7JKjVzMmA-pRFKtakCub7M8V2hn_F3u9tdugLCEUxnhnmXpH3FWnyrktICjgfwRhU5TCjtII6o1XWj0I3UeVuhEscxpkWej9NYdAmc4ztAAgnej_6y_asNPiQ3CTHfsLiorKBrFHWe81V1BYINQSJuC7s8wKDbbvrCaYC_BPoXDYd1au4Mv4mMTaquBLOWP6hH8VRPW462hEx9IehiSC4etjNM1J2n9adGQcwz117iD78pBVT6shwGcWSl0qVXb34v7QQVgteOH3_SD3RyLPL1I4WKtrGOiYX2puwaC0UQ..'
WHERE session_id='46dc17b784444bb4fd930a3191b519ce'
SELECT *
FROM jos_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM jos_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT template
FROM jos_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 161)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, 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, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access
FROM jos_content AS a
LEFT JOIN jos_categories AS cc
ON cc.id = a.catid
LEFT JOIN jos_sections AS s
ON s.id = cc.section
AND s.scope = "content"
LEFT JOIN jos_users AS u
ON u.id = a.created_by
LEFT JOIN jos_groups AS g
ON a.access = g.id
WHERE a.id = 352
AND ( ( a.created_by = 0 ) OR ( a.state = 1
AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2012-02-06 19:07:36' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-02-06 19:07:36' ) ) OR ( a.state = -1 ) )
UPDATE jos_content
SET hits = ( hits + 1 )
WHERE id='352'
SELECT group_id,group_name,group_level
FROM `jos_vm_auth_group`
ORDER BY group_level
SELECT jos_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `jos_vm_shopper_group`
WHERE jos_vm_shopper_group.vendor_id='1'
AND `default`='1'
SELECT `name`
FROM `jos_core_acl_aro_groups`
WHERE `id` =29
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 (`jos_vm_vendor` v, `jos_vm_country` c)
LEFT JOIN jos_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 id, title, module, position, content, showtitle, control, params
FROM jos_modules AS m
LEFT JOIN jos_modules_menu AS mm
ON mm.moduleid = m.id
WHERE m.published = 1
AND m.access <= 0
AND m.client_id = 0
AND ( mm.menuid = 161 OR mm.menuid = 0 )
ORDER BY position, ordering
