Sabian Cymbals
Sabian is a collection of dedicated and very talented individuals whose only focus is to create the finest cymbals and percussion instruments possible. Our ultimate goal is to help drummers and percussionists express themselves the way they want to be heard. How do we do it? By combining traditional values with modern vision and creative innovation to develop a full range of cymbals and sounds for players of all styles.

Click Here to visit the Sabian Cymbals web site.
We can supply any Sabian Cymbals product that is currently available in the UK. If you are interested a product by Sabian Cymbals 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(829) "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) 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '492' 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(829) "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) 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '492' 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(829) "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) 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '492' 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(817) "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) 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '492' 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) 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 pd.products_id = p.products_id and pd.language_id = '1' and p.manufacturers_id = m.manufacturers_id and m.manufacturers_id = '492' order by wh_stock desc limit 0, 12

[TEP STOP]