string(278) "SELECT DISTINCT p.* FROM ecommerce_products p JOIN ecommerce_tag_product etp_tag ON p.id = etp_tag.product_id AND etp_tag.tag_id = 208 JOIN ecommerce_category_product ecp ON p.id = ecp.product_id AND ecp.category_id = 10 WHERE show_item = 1 order by id desc LIMIT 15 OFFSET 0"