SELECT `description`, `description_bottom`
FROM `category_seo_data`
WHERE `category_seo_data`.`category_id` = 413SELECT 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`
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(413)
LIMIT 5000
) CI_count_all_results
Best sunscreen in india - sunscreen lotion - Imported Products from USA - iBhejo
We're back with exclusive offers – grab them now before they're gone!
