SELECT DISTINCT b.* FROM brands b LEFT JOIN products p ON p.brand_id = b.id LEFT JOIN categories_link cl ON cl.product_id = p.id LEFT JOIN categories c ON c.id = cl.cat_id WHERE p.hide=0 AND b.hide=0 ORDER BY b.orderid
Got error 28 from storage engine
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/farmersdirect.ie/httpdocs/classes/dao.php on line 77
Got error 28 from storage engine Farmers Direct: Buy quality clothes online | Farmersdirect.ie

ALL ORDERS OVER €70 COME WITH FREE DELIVERY


MENStab farmers direct Men
WOMENStabfarmers direct Women
CHILDRENStabfarmers direct Children
SELECT products.* FROM products LEFT JOIN featured ON products.id = featured.product_id WHERE domain_id=1 AND products.hide=0 AND featured.hide=0 ORDER BY Rand() LIMIT 12
Got error 28 from storage engine
Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in /var/www/vhosts/farmersdirect.ie/httpdocs/classes/dao.php on line 77

Farmer Direct

Welcome to Farmers Direct where you can buy a range of clothes online through our online store. We offer an excellent selection of products for sale and an easy to use online clothes shopping experience.

Online Clothing Shop

Buy top quality cheap clothes and accessories from our online shop here at farmers direct.

Branded Clothing

You will not be disappointed with the large range of branded clothing we offer at farmers direct!