Email   Phone+44 (0)7976 281 875 Contact Us
  Login Latest News  
Worldwide Shipping
Tax Free Shopping

 Searching for ⊂category3=∨derby=default For-the-horse

Showing: 1–1 of 1 items

SELECT SUM(p.stock)+SUM(p.warehouse_stock) as totalStock, p.category_level_1 as category_level_1, p.brand as brand, p.type as type, p.id as id, p.title as title, p.brand as brand, p.year as year, p.size as size, p.colour, p.url, p.stock, p.warehouse_stock, p.imageFile_tmb, p.sale_price as sale_price, p.sale_date_start, p.sale_date_end, p.rrp as rrp, ((p.rrp-p.sale_price)/p.rrp)*100 as percentage, MATCH (p.title, p.brand, p.description) AGAINST ('+" ⊂category3=∨derby=default"' IN NATURAL LANGUAGE MODE) AS title_relevance, p.linked_id FROM products p WHERE ( ( ( MATCH (p.title, p.brand, p.description) AGAINST ('+" ⊂category3=∨derby=default"' IN NATURAL LANGUAGE MODE) ) OR (p.description like '% ⊂category3=∨derby=default%') ) AND (p.active=1 AND p.deleted=0 AND p.stock>=1) ) GROUP BY p.linked_id, p.colour ORDER BY title_relevance DESC, totalStock DESC
SELECT SUM(prod.stock)+SUM(prod.warehouse_stock) as totalStock, prod.category_level_1 as category_level_1, prod.brand as brand, prod.type as type, prod.id as id, prod.title as title, prod.brand as brand, prod.year as year, prod.size as size, prod.colour, prod.url, prod.stock, prod.warehouse_stock, prod.imageFile_tmb, prod.sale_price as sale_price, prod.sale_date_start, prod.sale_date_end, prod.rrp as rrp, ((prod.rrp-prod.sale_price)/prod.rrp)*100 as percentage, sum(ind.rank) as rank from search_index as ind JOIN products as prod ON prod.id = ind.pid WHERE prod.deleted=0 AND prod.active=1 AND (brand ='Cavalleria Toscana') AND ( term LIKE '%⊂category3=∨derby=default%') GROUP BY prod.linked_id, prod.colour ORDER BY rank DESC
SELECT SUM(prod.stock)+SUM(prod.warehouse_stock) as totalStock, prod.category_level_1 as category_level_1, prod.brand as brand, prod.type as type, prod.id as id, prod.title as title, prod.brand as brand, prod.year as year, prod.size as size, prod.colour, prod.url, prod.stock, prod.warehouse_stock, prod.imageFile_tmb, prod.sale_price as sale_price, prod.sale_date_start, prod.sale_date_end, prod.rrp as rrp, ((prod.rrp-prod.sale_price)/prod.rrp)*100 as percentage, sum(ind.rank) as rank from search_index as ind JOIN products as prod ON prod.id = ind.pid WHERE prod.deleted=0 AND prod.active=1 AND (brand ='Cavalleria Toscana') AND ( term LIKE '%⊂category3=∨derby=default%') GROUP BY prod.linked_id, prod.colour ORDER BY rank DESC
SELECT SUM(prod.stock)+SUM(prod.warehouse_stock) as totalStock, prod.category_level_1 as category_level_1, prod.brand as brand, prod.type as type, prod.id as id, prod.title as title, prod.brand as brand, prod.year as year, prod.size as size, prod.colour, prod.url, prod.stock, prod.warehouse_stock, prod.imageFile_tmb, prod.sale_price as sale_price, prod.sale_date_start, prod.sale_date_end, prod.rrp as rrp, ((prod.rrp-prod.sale_price)/prod.rrp)*100 as percentage, sum(ind.rank) as rank from search_index as ind JOIN products as prod ON prod.id = ind.pid WHERE prod.deleted=0 AND prod.active=1 AND (brand ='Cavalleria Toscana') AND ( term LIKE '%⊂category3=∨derby=default%') GROUP BY prod.linked_id, prod.colour ORDER BY rank DESC