Buy Clearance Products from the PlayRecord.Net Clearance Products Shop
Have a surf through the collection of Clearance Products available here at PlayRecord.Net - the UK's Clearance Products Shop. If you have any questions or are looking for a particular make model or style of Clearance Products then simply get in touch and we will gladly help you out.

Do not forget our commitment to offering you the Best Priced Clearance Products. If you have seen any of our Clearance Products cheaper anywhere else (including delivery) then use the best price request form which you can get to by clicking on the Best Price logo. Alternatively send us an email with a link to where you have seen it cheaper and we will update our pricing 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(763) "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.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 left join products_stockdb ps using(products_id) left join products_description pd using(products_id) left join main_site_products_to_categories p2c using(products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = 1 and p.products_level = '1' and p2c.categories_id = '741' order by wh_stock desc limit 36, 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(763) "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.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 left join products_stockdb ps using(products_id) left join products_description pd using(products_id) left join main_site_products_to_categories p2c using(products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = 1 and p.products_level = '1' and p2c.categories_id = '741' order by wh_stock desc limit 36, 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(763) "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.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 left join products_stockdb ps using(products_id) left join products_description pd using(products_id) left join main_site_products_to_categories p2c using(products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = 1 and p.products_level = '1' and p2c.categories_id = '741' order by wh_stock desc limit 36, 12" ["number_of_rows"]=> string(4) "1887" ["current_page_number"]=> string(1) "4" ["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(750) "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.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 left join products_stockdb ps using(products_id) left join products_description pd using(products_id) left join main_site_products_to_categories p2c using(products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = 1 and p.products_level = '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.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 left join products_stockdb ps using(products_id) left join products_description pd using(products_id) left join main_site_products_to_categories p2c using(products_id) left join specials s on (p.products_id = s.products_id) where p.products_status = 1 and p.products_level = '1' and p2c.categories_id = '741' order by wh_stock desc limit 36, 12

[TEP STOP]