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


Fiskars Scissors

Fiskars high-quality scissors, when used in conjunction with any of our book covers, will ensure a smooth professional finish to your books.

  • Available in multi soft-touch, right-hand, left-hand and general use.
  • Contoured, offset handles.
  • True left-handed and right-handed blades.
  • Precision ground and hardened blades.

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

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

Fiskars Scissors General Use Details: Fiskars Scissors General Use Model: SC121CGP Price : $23.04 Quantity :
Fiskars Scissors Left Hand Details: Fiskars Scissors Left Hand Model: SCLEFT Price : $23.04 Quantity :
Details: Fiskars Scissors Multi-Use Soft Touch Model: SCSOFT Price : $36.90 Quantity :
Reviews Add to Wish List