Search Result

Current search phrase:-  
loft  bed  

select MATCH (pd.products_name) AGAINST ('loftbed' IN BOOLEAN MODE) AS relevance_0, MATCH (pd.search_name) AGAINST ('loftbed' IN BOOLEAN MODE) AS relevance_00, MATCH (pd.products_name) AGAINST ('loft bed' IN BOOLEAN MODE) AS relevance_1, MATCH (pd.search_name) AGAINST ('loft bed' IN BOOLEAN MODE) AS relevance_11, p.products_model, p.products_image, p.products_image_thmb, products_image_lrg, pd.products_name, p.products_quantity, p.products_id, p.manufacturers_id, m.manufacturers_name, m.manufacturers_status, p.products_price, p.products_date_added, p.products_weight, p.products_tax_class_id, p.products_sort_order, p.items_group,p.main_product, p.product_is_always_free_shipping, products_price_percent, p.products_image_thmb_size, p.products_image_size, p.products_image_lrg_size, p.more_image1_size, p.more_image2_size, p.more_image3_size, p.more_image4_size, p.more_image5_size from (((products p) , products_description pd) left join manufacturers m on p.manufacturers_id = m.manufacturers_id) where p.products_status = 1 and p.main_product = 1 and p.products_id = pd.products_id and ( pd.search_name like '%loft bed%' or pd.search_name like '%loftbed%' ) group by p.products_id ORDER BY relevance_0 DESC, relevance_00 DESC, relevance_1 DESC, relevance_11 DESC, p.products_id DESC

Keyword: loft bed
Items: 1 - 48 of 68

Items: 1 - 48 of 68

Have a Question About an Item or Order
Remodeling and Home Design