public static function getStoreAddress() { if (!isset(self::$store)) { $db = JFactory::getDbo(); $query = $db->getQuery(true); $query->select('s.*, c.country_name, c.country_isocode_2, c.country_isocode_3, z.zone_name, z.zone_code'); $query->from('#__j2store_storeprofiles AS s'); $query->where('s.state=1'); $query->order('s.store_id ASC LIMIT 1'); $query->leftJoin('#__j2store_countries AS c ON s.country_id = c.country_id'); $query->leftJoin('#__j2store_zones AS z ON s.zone_id = z.zone_id'); $db->setQuery($query); self::$store = $db->loadObject(); } return self::$store; }