Stagg: Clearance Products
Buy Stagg Clearance Products from PlayRecord.Net, the UK's Stagg Shop. Do not forget our commitment to offering you a wide range of Stagg Clearance Products at the very best prices. Simply use the Best Price form on the product page to ensure you get the best deal on Stagg from PlayRecord.Net.

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

[TEP STOP]