English French German
Sign In |   Shopping Basket  |  Checkout   
Ryco Products
Paperback Book Covers
  PolyWrap Heavy

Rhino Retail Packs

White Boards
  Black Chalkboard
  Green Chalkboard
  Whiteboard Rolls

Hardback Book Covers

Ryco Essentials
  Cutting Tools

Automated Machines
Guides Section

Whiteboard Roll

3065 - Expression #2 of ORDER BY clause is not in SELECT list, references column 'ryco.xp.products_id' which is not in SELECT list; this is incompatible with DISTINCT

select distinct p.products_id, p.products_image, p.products_price, p.manufacturers_id, pd.products_name, p.products_tax_class_id, if (isnull(pg.customers_group_price), p.products_price, pg.customers_group_price) as products_price, p.products_date_added, p.products_image , xp.xsell_id products_price from ((products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id = 'G') left join specials s on p.products_id = s.products_id), products_xsell xp, products_description pd where xp.products_id = '166' and p.products_id = xp.xsell_id and pd.products_id = xp.xsell_id and pd.language_id = '1' and p.products_status = '1' and p.products_group_access like '%G%' order by rand(), xp.products_id asc limit 4




PolyPockets and PolyCorners - self-adhesive welded pockets are designed to offer a simple and easy method of holding a date or label card in your paperback or hardback book. Available in rolls of 500 Initially repositionable - turning permanent.


  • Multiple uses around the home or office.
  • Environmentally friendly.
  • An excellent way to avoid obscuring text and title pages.
  • Simple to mount – initially repositionable, turning permanent.

How to Order:

To add one or more items to your basket, simply type the quantity in the box labeled "Quantity" and click on the "Add to Basket" button at the bottom of the page.Price per roll of 500.


Price excludes VAT which is calculated at Checkout. 

Holders - Add to del.icio.us del.icio.us Holders - Add to Digg Digg Holders - Share with facebook Share with facebook Holders - Add to Google Bookmark Google Bookmark Holders - Add to Reddit Reddit Holders - Add to Ask Ask

Details: PolyCorners - H75mm x W75mm - 1 Roll of 8 Model: CPK Price : $3.38 Quantity :
PolyCorners - H80mm x W80mm - 1 Roll of 500 Details: PolyCorners - H80mm x W80mm - 1 Roll of 500 Model: PCORNERS Price : $29.22 Quantity :
Details: PolyPocket - H135mm x W95mm - 1 Roll of 10 Model: PPK Price : $4.25 Quantity :
PolyPocket - H135mm x W95mm - 1 Roll of 500 Details: PolyPocket - H135mm x W95mm - 1 Roll of 500 Model: PPOCKETS Price : $53.12 Quantity :
Reviews Add to Wish List