SELECT `description`, `description_bottom`
FROM `category_seo_data`
WHERE `category_seo_data`.`category_id` = 706SELECT COUNT(*) AS `numrows`
FROM (
SELECT `products`.*, `users`.`username` AS `user_username`, `users`.`shop_name` AS `shop_name`, `users`.`role` AS `user_role`, `users`.`slug` AS `user_slug`, round(products.price - ((products.price * products.discount_rate)/100)) AS price_final, (SELECT title FROM product_details WHERE product_details.product_id = products.id AND product_details.lang_id = 1 LIMIT 1) AS title, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1) AS image, (SELECT CONCAT(storage, '::', image_small) FROM images WHERE products.id = images.product_id ORDER BY is_main DESC LIMIT 1, 1) AS image_second, (SELECT COUNT(wishlist.id) FROM wishlist WHERE products.id = wishlist.product_id) AS wishlist_count, (SELECT variations.id FROM variations WHERE products.id = variations.product_id LIMIT 1) AS has_variation, 0 AS `is_in_wishlist`
FROM `products`
JOIN `users` ON `products`.`user_id` = `users`.`id`
JOIN `product_details` ON `product_details`.`product_id` = `products`.`id`
LEFT JOIN `brands` ON `brands`.`id` = `products`.`brand_id`
WHERE `users`.`banned` = 0
AND `products`.`status` = 1
AND `products`.`visibility` = 1
AND `products`.`is_draft` = 0
AND `products`.`is_deleted` = 0
AND products.category_id IN(706)
AND `product_details`.`lang_id` = 1
AND (
`product_details`.`title` LIKE 'Fresh%' ESCAPE '!'
OR `brands`.`name` = 'Fresh'
OR `products`.`gtn_upc` = 'Fresh'
OR `products`.`mpn` = 'Fresh'
AND `product_details`.`title` LIKE 'Himalayan%' ESCAPE '!'
OR `brands`.`name` = 'Himalayan'
OR `products`.`gtn_upc` = 'Himalayan'
OR `products`.`mpn` = 'Himalayan'
OR `products`.`sku` = 'Fresh-Himalayan'
)
LIMIT 5000
) CI_count_all_results
Wrist band for gym - Wrist support band - Imported Products from USA - iBhejo
We're back with exclusive offers – grab them now before they're gone!
