SELECT *
FROM tab_session
WHERE session_id = '37175d260f23da1e6a12e9e0de1a18bd'
DELETE
FROM tab_session
WHERE ( time < '1337446527' )
SELECT *
FROM tab_session
WHERE session_id = '37175d260f23da1e6a12e9e0de1a18bd'
INSERT INTO `tab_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '37175d260f23da1e6a12e9e0de1a18bd','1337448327','','0','1','0' )
SELECT *
FROM tab_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM tab_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM tab_sef_subdomains
SELECT Itemid_titlepage
FROM tab_sef_subdomains
WHERE subdomain = 'taburetka'
LIMIT 1
SELECT `a`.`vars`, `u`.`sefurl`
FROM `tab_sefaliases` AS `a`
INNER JOIN `tab_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = ''
AND `u`.`trashed` = '0'
SELECT `id`
FROM `tab_plugins`
WHERE `element` = 'joomsef'
AND `folder` = 'system'
AND `published` = '1'
SELECT *
FROM `tab_sefurls`
WHERE (`sefurl` = '' OR `sefurl` = 'index.php')
AND `trashed` = '0'
LIMIT 1
SELECT `file`, `params`
FROM `tab_sefexts`
SELECT template
FROM tab_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 3)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, title, module, position, content, showtitle, control, params
FROM tab_modules AS m
LEFT JOIN tab_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 = 3 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT group_id,group_name,group_level
FROM `tab_vm_auth_group`
ORDER BY group_level
SELECT tab_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `tab_vm_shopper_group`
WHERE tab_vm_shopper_group.vendor_id='1'
AND `default`='1'
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 (`tab_vm_vendor` v, `tab_vm_country` c)
LEFT JOIN tab_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 user_info_id
FROM `tab_vm_user_info`
WHERE user_id='0'
AND address_type='BT'
SELECT id, params
FROM tab_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT id
FROM tab_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT `catid`
FROM `tab_content`
WHERE `id` = '1'
SELECT *
FROM `tab_sefurls`
WHERE `origurl` = 'index.php?option=com_virtuemart&page=shop.cart'
AND (`Itemid` = '1' OR `Itemid` IS NULL)
AND (`trashed` = '0')
LIMIT 2
SELECT a.*, 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
FROM tab_content AS a
LEFT JOIN tab_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN tab_categories AS cc
ON cc.id = a.catid
INNER JOIN tab_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-05-19 17:25:27' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:25:27' )
AND s.id > 0
AND f.content_id IS NULL
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT *
FROM `tab_sefurls`
WHERE `origurl` = 'index.php?option=com_content&catid=2&id=33&view=article'
AND (`Itemid` = '6' OR `Itemid` IS NULL)
AND (`trashed` = '0')
LIMIT 2
SELECT cc.id, cc.userid, cc.comment, cc.name, cc.username, cc.email, cc.date, cc.object_id, cc.object_group, '' AS avatar
FROM tab_jcomments AS cc
LEFT JOIN tab_content AS c
ON c.id = cc.object_id
WHERE cc.published = 1
AND c.access <= '0'
AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2012-05-19 17:25:27')
AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2012-05-19 17:25:27')
AND cc.object_group = 'com_content'
ORDER BY cc.date DESC
LIMIT 5
SELECT *
FROM tab_session
WHERE session_id = '37175d260f23da1e6a12e9e0de1a18bd'
DELETE
FROM tab_session
WHERE ( time < '1337446527' )
SELECT *
FROM tab_session
WHERE session_id = '37175d260f23da1e6a12e9e0de1a18bd'
INSERT INTO `tab_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` )
VALUES ( '37175d260f23da1e6a12e9e0de1a18bd','1337448327','','0','1','0' )
SELECT *
FROM tab_components
WHERE parent = 0
SELECT folder AS type, element AS name, params
FROM tab_plugins
WHERE published >= 1
AND access <= 0
ORDER BY ordering
SELECT *
FROM tab_sef_subdomains
SELECT Itemid_titlepage
FROM tab_sef_subdomains
WHERE subdomain = 'taburetka'
LIMIT 1
SELECT `a`.`vars`, `u`.`sefurl`
FROM `tab_sefaliases` AS `a`
INNER JOIN `tab_sefurls` AS `u`
ON `u`.`id` = `a`.`url`
WHERE `a`.`alias` = ''
AND `u`.`trashed` = '0'
SELECT `id`
FROM `tab_plugins`
WHERE `element` = 'joomsef'
AND `folder` = 'system'
AND `published` = '1'
SELECT *
FROM `tab_sefurls`
WHERE (`sefurl` = '' OR `sefurl` = 'index.php')
AND `trashed` = '0'
LIMIT 1
SELECT `file`, `params`
FROM `tab_sefexts`
SELECT template
FROM tab_templates_menu
WHERE client_id = 0
AND (menuid = 0 OR menuid = 3)
ORDER BY menuid DESC
LIMIT 0, 1
SELECT id, title, module, position, content, showtitle, control, params
FROM tab_modules AS m
LEFT JOIN tab_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 = 3 OR mm.menuid = 0 )
ORDER BY position, ordering
SELECT group_id,group_name,group_level
FROM `tab_vm_auth_group`
ORDER BY group_level
SELECT tab_vm_shopper_group.shopper_group_id, show_price_including_tax, `default`, shopper_group_discount
FROM `tab_vm_shopper_group`
WHERE tab_vm_shopper_group.vendor_id='1'
AND `default`='1'
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 (`tab_vm_vendor` v, `tab_vm_country` c)
LEFT JOIN tab_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 user_info_id
FROM `tab_vm_user_info`
WHERE user_id='0'
AND address_type='BT'
SELECT id, params
FROM tab_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT id
FROM tab_menu
WHERE link='index.php?option=com_virtuemart'
AND published=1
SELECT `catid`
FROM `tab_content`
WHERE `id` = '1'
SELECT *
FROM `tab_sefurls`
WHERE `origurl` = 'index.php?option=com_virtuemart&page=shop.cart'
AND (`Itemid` = '1' OR `Itemid` IS NULL)
AND (`trashed` = '0')
LIMIT 2
SELECT a.*, 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
FROM tab_content AS a
LEFT JOIN tab_content_frontpage AS f
ON f.content_id = a.id
INNER JOIN tab_categories AS cc
ON cc.id = a.catid
INNER JOIN tab_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-05-19 17:25:27' )
AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2012-05-19 17:25:27' )
AND s.id > 0
AND f.content_id IS NULL
AND s.published = 1
AND cc.published = 1
ORDER BY a.created DESC
LIMIT 0, 5
SELECT *
FROM `tab_sefurls`
WHERE `origurl` = 'index.php?option=com_content&catid=2&id=33&view=article'
AND (`Itemid` = '6' OR `Itemid` IS NULL)
AND (`trashed` = '0')
LIMIT 2
SELECT cc.id, cc.userid, cc.comment, cc.name, cc.username, cc.email, cc.date, cc.object_id, cc.object_group, '' AS avatar
FROM tab_jcomments AS cc
LEFT JOIN tab_content AS c
ON c.id = cc.object_id
WHERE cc.published = 1
AND c.access <= '0'
AND (c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2012-05-19 17:25:27')
AND (c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2012-05-19 17:25:27')
AND cc.object_group = 'com_content'
ORDER BY cc.date DESC
LIMIT 5