You are here:  Home

Your Cart is currently empty.

• Home
• Our Online-Shop
• Artists
• Contact Us
• About B-stick
• Dealers
• Endorsement

Queen B-stick Taffel

Top Sellers

01	King 5A
02	King 5B
03	King 3A
04	King 2B King Size
05	King B-stick Ball Head

Online-Shop

Drum Sticks Timbale Sticks Brushes Other products Custom Design SECONDS - 2. Selection (2 for 1)

List All Products

Username Password

Lost Password?

No account yet? Register

King 5B *SECONDS* (2 Pairs)

DKK95,00

King 7A

DKK95,00

Custom Design 25 Pairs

DKK3.000,00

Queen 2B *SECONDS* (2 Pairs)

DKK95,00

King 4A Shorty

DKK95,00

 

Hello, you either have JavaScript turned off or an old version of Macromedia's Flash Player. Get the latest flash player.

To B-stick or not to B-stick? B-stick delivers the best and most tested drumstick anywhere. Handcrafted in Denmark of the finest raw materials using the most resource intensive processes to ensure consistent quality. RIGHT NOW:  Read more  www.myspace.com/BstickOfDenmark   We proudly present the first official US B-stick endorsement... Jeremy just got interviewed by sickdrummer.com - check it out here.

We welcome Nick from Decending and Die Without to the team. Read more...   Vincent Kreyder from Decline of Sanity, Fairyland & Novagreen joins the B-stick family.   Read more...   John Vooren from Code, Grand Alchemist and Dødheimsgard joins B-stick! Read more...   K.L.M: from Hysteresys joins B-stick Read more...   We proudly announce that Ryan from the UK band, Omertta has joined the B-stick team. Read more...   We are proud to announce that Elisabeth has joined the B-stick team.   Mike Cotton from Canadian band Deathmarch Joins B-stick roster Read more...   Erhan Karaca, Heretic Soul joins the B-stick ranks!   It is with appropriate enthusiasm and humiliation that we can announce Adam as part of the B-stick team.

More... Jarle Byberg aka URUZ

<< Start < Prev 1 2 3 4 Next > End >>

Results 1 - 13 of 45

HomeContact UsTerms & Conditions

Copyright © 2010 B-stick of Denmark - Handmade Drum Sticks. Best drumstick in the world. Trommestikker - stikker..  Site by COMPUNIAC

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT id, link
 FROM jos_menu
 WHERE menutype = 'mainmenu'
 AND published = 1
 ORDER BY parent, ordering
LIMIT 1
4
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 1 )
 ORDER BY menuid DESC
LIMIT 1
5
DELETE FROM jos_session
 WHERE (
 ( time < '1268278976' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1268278976' )
 AND guest = 1
 AND userid = 0
 )
6
SELECT *
 FROM jos_menu
 WHERE id = 1
7
SELECT COUNT(a.id)
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 04:57' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 04:57' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
8
SELECT a.id, a.title, a.title_alias, a.introtext, a.sectionid, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,
 a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.ordering, a.metakey, a.metadesc, a.access, a.hits,
 CHAR_LENGTH( a.fulltext ) AS readmore, u.name AS author, u.usertype, s.name AS section, cc.name AS category, g.name AS groups
, s.id AS sec_id, cc.id as cat_id
 FROM jos_content AS a
 INNER JOIN jos_content_frontpage AS f ON f.content_id = a.id
 INNER JOIN jos_categories AS cc ON cc.id = a.catid
 INNER JOIN jos_sections AS s ON s.id = a.sectionid
 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.state = 1
 AND ( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2010-03-11 04:57' )
 AND ( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2010-03-11 04:57' )
 AND s.published = 1
 AND cc.published = 1
 AND a.access <= 0
 AND s.access <= 0
 AND cc.access <= 0
 ORDER BY  f.ordering
LIMIT 13
9
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE access <= 0
 AND folder = 'content'
 ORDER BY ordering
10
SELECT params
 FROM jos_mambots
 WHERE element = 'mosimage'
 AND folder = 'content'
11
SELECT group_id,group_name,group_level FROM `jos_vm_auth_group` ORDER BY group_level
12
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'
13
SELECT `name` FROM `jos_core_acl_aro_groups` WHERE `group_id` =29
14
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Frontend'
15
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_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
16
SELECT `lft`, `rgt` FROM `jos_core_acl_aro_groups` WHERE `name`='Public Backend'
17
SELECT g1.group_id, g1.name, COUNT(g2.name) AS level
FROM jos_core_acl_aro_groups AS g1
INNER JOIN jos_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
18
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`);
19
SELECT params FROM jos_menu WHERE id='1'
20
SELECT * FROM jos_menu
WHERE menutype='mainmenu' AND published='1' AND access <= '0' AND parent=0
ORDER BY ordering
21
SELECT * FROM jos_menu
WHERE menutype='mainmenu' AND published='1'
22
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_typed'
 AND published = 1
23
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=96'
24
SELECT COUNT( id )
 FROM jos_menu 
 WHERE type = 'content_item_link'
 AND published = 1
25
SELECT id
 FROM jos_menu
 WHERE type = 'content_item_link'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=96'
26
SELECT * FROM jos_menu
WHERE menutype='mainmenu' AND published='1' AND access <= '0'
AND parent > 0
ORDER BY parent,ordering
27
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0 OR mm.menuid = 1 )
 ORDER BY ordering
28
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
29
SELECT * FROM `jos_jstats_configuration`
30
SELECT exclude, type, tld, id FROM jos_jstats_ipaddresses WHERE ip = '38.107.191.106' AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
31
SELECT country_code2 FROM jos_jstats_iptocountry WHERE inet_aton('38.107.191.106') >= ip_from AND inet_aton('38.107.191.106') <= ip_to
32
SELECT LENGTH(browser_string) AS strlen, browser_string, browser_fullname FROM jos_jstats_browsers ORDER BY strlen DESC
33
SELECT LENGTH(bot_string) AS strlen, bot_string,bot_fullname FROM jos_jstats_bots ORDER BY strlen DESC
34
SELECT LENGTH(sys_string) AS strlen, sys_string, sys_fullname FROM jos_jstats_systems ORDER BY strlen DESC
35
INSERT INTO jos_jstats_ipaddresses (ip, nslookup, useragent, tld, system, browser, type) VALUES ('38.107.191.106', '38.107.191.106', 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)', 'us', '', 'Unknown robot (identified by crawl)', 2)
36
SELECT id
 FROM jos_jstats_ipaddresses
 WHERE ip = '38.107.191.106'
 AND useragent = 'ccbot/1.0 (+http://www.commoncrawl.org/bot.html)'
37
SELECT id
 FROM jos_jstats_visits
 WHERE month = MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR))
 AND year = YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR))
 AND ip_id = '30481'
 AND time >= DATE_ADD(DATE_ADD(NOW(), INTERVAL -1 HOUR), INTERVAL -15 MINUTE)
38
INSERT INTO jos_jstats_visits (ip_id, hour, day, month, year, time, userid)
 VALUES (30481, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DATE_ADD(NOW(), INTERVAL -1 HOUR), '0')
39
SELECT page_id, page_title
 FROM jos_jstats_pages
 WHERE page = '/cms/index.php'
40
INSERT INTO jos_jstats_page_request (page_id, hour, day, month, year, ip_id)
 VALUES (9, HOUR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), DAYOFMONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), MONTH(DATE_ADD(NOW(), INTERVAL -1 HOUR)), YEAR(DATE_ADD(NOW(), INTERVAL -1 HOUR)), 114009)
41
SELECT id, name, link, parent, type, menutype, access
 FROM jos_menu
 WHERE published = 1
 AND access <= 0
 ORDER BY menutype, parent, ordering
42
SELECT id FROM jos_menu WHERE link='index.php?option=com_virtuemart' AND published=1
43
SELECT DISTINCT product_sku FROM jos_vm_product, jos_vm_product_category_xref, jos_vm_category WHERE product_parent_id=''AND jos_vm_product.product_id=jos_vm_product_category_xref.product_id AND jos_vm_category.category_id=jos_vm_product_category_xref.category_id AND jos_vm_product.product_publish='Y' ORDER BY jos_vm_product.product_id DESC LIMIT 0, 1
44
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='QTAFFEL'
45
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='71' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
46
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='71'
47
SELECT *
 FROM jos_banner
 WHERE showBanner=1 
 AND ( cid=5 )
48
SELECT p.product_id, p.product_sales as sales, p.product_parent_id, p.product_name, c.category_id, c.category_flypage FROM jos_vm_product p, jos_vm_product_category_xref pc, jos_vm_category c WHERE p.product_publish='Y' AND pc.product_id = p.product_id AND pc.category_id = c.category_id AND p.product_sales > 0 GROUP BY p.product_id ORDER BY sales DESC, p.product_name  LIMIT 0, 5
49
SELECT category_id, category_description, category_name,category_child_id as cid, category_parent_id as pid,list_order, category_publish
						FROM jos_vm_category, jos_vm_category_xref WHERE jos_vm_category.category_publish='Y' AND jos_vm_category.category_id=jos_vm_category_xref.category_child_id ORDER BY jos_vm_category.list_order ASC, jos_vm_category.category_name ASC
50
SELECT group_id,group_name,group_level FROM `jos_vm_auth_group` ORDER BY group_level
51
SELECT published FROM jos_modules WHERE module='mod_virtuemart_cart'
52
SELECT p.product_sku FROM jos_vm_product AS p
JOIN jos_vm_product_category_xref as pc ON p.product_id=pc.product_id
JOIN jos_vm_category as c ON pc.category_id=c.category_id
 WHERE p.product_publish = 'Y' AND c.category_publish = 'Y' AND product_parent_id=0 
 ORDER BY RAND() LIMIT 5
53
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='K5B-S'
54
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='54' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
55
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='54'
56
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=54
57
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='54' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
58
SELECT product_parent_id FROM jos_vm_product WHERE product_id=54
59
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
60
SELECT vendor_id FROM jos_vm_product WHERE product_id='54'
61
SELECT shopper_group_id,shopper_group_discount FROM jos_vm_shopper_group WHERE vendor_id='1' AND `default`='1'
62
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=54 AND shopper_group_id=5   ORDER BY price_quantity_start
63
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='54'
64
SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=54
65
SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=54
66
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='K7A'
67
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='33' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
68
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='33'
69
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=33
70
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='33' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
71
SELECT product_parent_id FROM jos_vm_product WHERE product_id=33
72
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
73
SELECT vendor_id FROM jos_vm_product WHERE product_id='33'
74
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=33 AND shopper_group_id=5   ORDER BY price_quantity_start
75
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='33'
76
SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=33
77
SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=33
78
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='CUSTOM'
79
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='47' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
80
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='47'
81
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=47
82
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='47' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
83
SELECT product_parent_id FROM jos_vm_product WHERE product_id=47
84
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
85
SELECT vendor_id FROM jos_vm_product WHERE product_id='47'
86
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=47 AND shopper_group_id=5   ORDER BY price_quantity_start
87
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='47'
88
SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=47
89
SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=47
90
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='Q2B-S'
91
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='65' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
92
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='65'
93
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=65
94
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='65' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
95
SELECT product_parent_id FROM jos_vm_product WHERE product_id=65
96
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
97
SELECT vendor_id FROM jos_vm_product WHERE product_id='65'
98
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=65 AND shopper_group_id=5   ORDER BY price_quantity_start
99
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='65'
100
SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=65
101
SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=65
102
SELECT product_id, product_name, product_parent_id, product_thumb_image FROM jos_vm_product WHERE product_sku='K4ASHORTY'
103
SELECT jos_vm_category.category_id FROM jos_vm_category,jos_vm_product_category_xref WHERE product_id='30' AND jos_vm_category.category_id = jos_vm_product_category_xref.category_id
104
SELECT
                                `jos_vm_product`.`product_parent_id` AS product_parent_id,
                                `jos_vm_category`.`category_flypage`
                        FROM
                                `jos_vm_product`

                        LEFT JOIN `jos_vm_product_category_xref` ON `jos_vm_product_category_xref`.`product_id` = `jos_vm_product`.`product_id`
                        LEFT JOIN `jos_vm_category` ON `jos_vm_product_category_xref`.`category_id` = `jos_vm_category`.`category_id`

                        WHERE `jos_vm_product`.`product_id`='30'
105
SELECT product_id, `jos_vm_product`.* FROM `jos_vm_product` WHERE `product_id`=30
106
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='30' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
107
SELECT product_parent_id FROM jos_vm_product WHERE product_id=30
108
SELECT amount,is_percent FROM jos_vm_product,jos_vm_product_discount WHERE product_id='0' AND (start_date<='1268279876' OR start_date=0) AND (end_date>='1268260560' OR end_date=0) AND product_discount_id=discount_id
109
SELECT vendor_id FROM jos_vm_product WHERE product_id='30'
110
SELECT `product_price`, `product_price_id`, `product_currency` FROM `jos_vm_product_price` WHERE product_id=30 AND shopper_group_id=5   ORDER BY price_quantity_start
111
SELECT product_weight, tax_rate FROM jos_vm_product, jos_vm_tax_rate WHERE product_tax_id=tax_rate_id AND product_id='30'
112
SELECT `product_id` FROM `jos_vm_product_attribute_sku` WHERE `product_id`=30
113
SELECT `attribute`,`custom_attribute` FROM `jos_vm_product` WHERE `product_id`=30
114
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
115
SELECT id
 FROM jos_menu
 WHERE type = 'content_typed'
 AND published = 1
 AND link = 'index.php?option=com_content&task=view&id=5'