SELECT DISTINCT post.id,post.code,post.created,post.updated,post.slug,post.title,post.content,post.image,post.properties,post.active,product.price,product.stock FROM post JOIN product ON product.post_id = post.id JOIN post_taxonomy ON post_taxonomy.post_id = post.id JOIN taxonomy ON taxonomy.id = post_taxonomy.taxonomy_id JOIN vocabulary ON vocabulary.id = taxonomy.vocabulary_id JOIN term ON term.id = taxonomy.term_id WHERE vocabulary.slug = 'brand' AND term.slug = 'adzkia' AND post.slug = 'ghaida-mocca' AND post.code = 'a27a'
Location: App\Controller\Product->details()