Sign in
0
  • د.إ AED
  • $ USD
  • £ GBP
  • € EUR
  • ر.س SAR
  • د.ك KWD
  • ₽ RUB
  • ﷼ OMR
  • ¥ CNY
  • ₹ INR
  • .د.ب BD
  • ر.ق QAR
SELECT sc.*, b.name AS brandname, b.page_alias AS brand_page_alias FROM sub_category sc LEFT JOIN brands b ON sc.parent = b.id WHERE sc.alias = '' AND sc.status = 1 LIMIT 1