Zildjian Cymbals: Splash
The Avedis Zildjian Company is one of the worlds largest manufacturer of cymbals, along with Paiste, Meinl and Sabian. At nearly 400 years old, Zildjian remains one of the oldest operating companies in the world. They also sell drum-related accessories, such as drum sticks.

Click Here to visit the Zildjian Cymbals web site.
We can supply any Zildjian Cymbals product that is currently available in the UK. If you are interested a product by Zildjian 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(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 = '515' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '642' 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 = '515' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '642' 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 = '515' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '642' order by wh_stock desc limit 0, 12" ["number_of_rows"]=> string(1) "1" ["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 = '515' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '642' 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 = '515' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '642' order by wh_stock desc limit 0, 12

[TEP STOP]