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


Medium Rhino Retail Book Covers $5.60 

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 medium pack is 258mm in height and 410mm 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.

Medium Rhino Retail Book Covers - Add to del.icio.us del.icio.us Medium Rhino Retail Book Covers - Add to Digg Digg Medium Rhino Retail Book Covers - Share with facebook Share with facebook Medium Rhino Retail Book Covers - Add to Google Bookmark Google Bookmark Medium Rhino Retail Book Covers - Add to Reddit Reddit Medium Rhino Retail Book Covers - Add to Ask Ask

Reviews Add to Wish List