Shubb
Shubb is the name of a company that specialises in producing top-quality capos for all kinds of stringed instruments. The company was formed in 1974 by Rick Shubb and Dave Coontz. Both are practising banjoists.

Click Here to visit the Shubb web site.
We can supply any Shubb product that is currently available in the UK. If you are interested a product by Shubb that is not currently showing on PlayRecord.Net, simply let us know and we will put it on the site for you.
array(6) { [0]=> array(4) { ["file"]=> string(65) "/srv/playrecord.net/public/htdocs/includes/functions/database.php" ["line"]=> int(78) ["function"]=> string(12) "tep_db_error" ["args"]=> array(3) { [0]=> &string(935) "select p.products_image, pd.products_name, ps.wh_stock, p.products_id, p.url, p.variation_name, p.products_model, pd.products_short_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.expires_date, NULL) as expires_date, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m, main_site_products_to_categories p2c) left join products_stockdb ps on (p.products_id = ps.products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = '1' and p.products_level = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '556' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '122' order by wh_stock desc limit 0, 12" [1]=> &int(1) [2]=> &string(62) "Can't create/write to file '/tmp/#sql_bf7_0.MAI' (Errcode: 28)" } } [1]=> array(4) { ["file"]=> string(73) "/srv/playrecord.net/public/htdocs/includes/classes/split_page_results.php" ["line"]=> int(67) ["function"]=> string(12) "tep_db_query" ["args"]=> array(1) { [0]=> &string(935) "select p.products_image, pd.products_name, ps.wh_stock, p.products_id, p.url, p.variation_name, p.products_model, pd.products_short_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.expires_date, NULL) as expires_date, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m, main_site_products_to_categories p2c) left join products_stockdb ps on (p.products_id = ps.products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = '1' and p.products_level = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '556' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '122' order by wh_stock desc limit 0, 12" } } [2]=> array(7) { ["file"]=> string(70) "/srv/playrecord.net/public/htdocs/includes/modules/product_listing.php" ["line"]=> int(13) ["function"]=> string(16) "splitPageResults" ["class"]=> string(16) "splitPageResults" ["object"]=> object(splitPageResults)#11 (6) { ["sql_query"]=> string(935) "select p.products_image, pd.products_name, ps.wh_stock, p.products_id, p.url, p.variation_name, p.products_model, pd.products_short_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.expires_date, NULL) as expires_date, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m, main_site_products_to_categories p2c) left join products_stockdb ps on (p.products_id = ps.products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = '1' and p.products_level = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '556' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '122' order by wh_stock desc limit 0, 12" ["number_of_rows"]=> string(1) "0" ["current_page_number"]=> int(1) ["number_of_pages"]=> NULL ["number_of_rows_per_page"]=> string(2) "12" ["page_name"]=> string(4) "page" } ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> &string(923) "select p.products_image, pd.products_name, ps.wh_stock, p.products_id, p.url, p.variation_name, p.products_model, pd.products_short_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.expires_date, NULL) as expires_date, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m, main_site_products_to_categories p2c) left join products_stockdb ps on (p.products_id = ps.products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = '1' and p.products_level = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '556' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '122' order by wh_stock desc" [1]=> &string(2) "12" [2]=> &string(13) "p.products_id" } } [3]=> array(4) { ["file"]=> string(75) "/srv/playrecord.net/public/htdocs/templates/content/browse_products.tpl.php" ["line"]=> int(75) ["args"]=> array(1) { [0]=> string(70) "/srv/playrecord.net/public/htdocs/includes/modules/product_listing.php" } ["function"]=> string(7) "include" } [4]=> array(4) { ["file"]=> string(72) "/srv/playrecord.net/public/htdocs/templates/Playrecord/main_page.tpl.php" ["line"]=> int(135) ["args"]=> array(1) { [0]=> string(75) "/srv/playrecord.net/public/htdocs/templates/content/browse_products.tpl.php" } ["function"]=> string(7) "require" } [5]=> array(4) { ["file"]=> string(44) "/srv/playrecord.net/public/htdocs/browse.php" ["line"]=> int(349) ["args"]=> array(1) { [0]=> string(72) "/srv/playrecord.net/public/htdocs/templates/Playrecord/main_page.tpl.php" } ["function"]=> string(7) "require" } } 1 - Can't create/write to file '/tmp/#sql_bf7_0.MAI' (Errcode: 28)

select p.products_image, pd.products_name, ps.wh_stock, p.products_id, p.url, p.variation_name, p.products_model, pd.products_short_description, p.manufacturers_id, p.products_price, p.products_tax_class_id, IF(s.status, s.expires_date, NULL) as expires_date, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price from (products p, products_description pd, manufacturers m, main_site_products_to_categories p2c) left join products_stockdb ps on (p.products_id = ps.products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = '1' and p.products_level = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '556' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '122' order by wh_stock desc limit 0, 12

[TEP STOP]