select products.slug, ptags.name from products inner join products_ptags on products.id = products_ptags.product_id inner join ptags on ptags.id = products_ptags.ptag_id