No product found for slug: SELECT DISTINCT
p.*,
c.name AS category_name,
c.category_slug AS category_slug,
s.name AS subcategory_name,
s.category_slug AS subcategory_slug,
b.name AS brand_name,
i.image,
i.Alt
FROM
products p
LEFT JOIN
categories c ON p.category_id = c.id
LEFT JOIN
categories s ON p.subcategory_id = s.id
LEFT JOIN
brands b ON p.brand_id = b.id
LEFT JOIN
product_images i ON p.id = i.product_id
WHERE
p.slug = 'TUF-GAMING-1000G-Asus-TUF-GAMING-1000G-TUF-Gaming-1000W-Gold-(1000-Watt,-ATX-3.0-Compatible-Fully-Modular-Power-Supply,-80 -Gold-Certified,-Military-Grade)'