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
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 = '1044' 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


Rhino Retail Pack - Large $7.00 

Introducing our new Rhino Retail Pack This cover is used extensively in libraries through out the Uk and Ireland and is now available in this new retail pack format. The Rhino Cover is an easy to apply cover and will take the hassle out of book covering. Once fitted the cover will offer unmatched protection. Books are covered in less than a minute with no Air bubbles and minimal waste with clear instructions on each pack for ease of use Each pack contains 3 book covers.

Each cover in the Large pack is 320mm in height and 510mm in width.

Measuring Guide:

Remember, our Rhino.1 cover can be trimmed to fit any size book perfectly.

Click here to download Ryco Book Measuring Guide.

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 3 Pack. Price excludes VAT which is calculated at Checkout.

Rhino Retail Pack - Large - Add to del.icio.us del.icio.us Rhino Retail Pack - Large - Add to Digg Digg Rhino Retail Pack - Large - Share with facebook Share with facebook Rhino Retail Pack - Large - Add to Google Bookmark Google Bookmark Rhino Retail Pack - Large - Add to Reddit Reddit Rhino Retail Pack - Large - Add to Ask Ask

Reviews Add to Wish List