Product

SELECT p.* ,c.url_ID AS url_cat_ID ,c.url_EN AS url_cat_EN FROM myp_products p INNER JOIN myp_products_category c ON (p.id_kategori=c.id) WHERE c.url_EN='cone-fan'