protected static function getPageViewQuery() { if (null !== self::$pageViewQueryCache) { return self::$pageViewQueryCache; } return self::$pageViewQueryCache = dmDb::query('DmPageView pv, pv.Areas a')->select('pv.id, a.id')->where('pv.module = ?')->andWhere('pv.action = ?'); }
protected static function getZonesQuery() { if (null !== self::$zonesQueryCache) { return self::$zonesQueryCache; } return self::$zonesQueryCache = dmDb::query('DmZone z')->leftJoin('z.Widgets w')->innerJoin('w.Translation wTranslation WITH wTranslation.lang = ?')->select('z.dm_area_id, w.module, w.action, wTranslation.value')->where('z.dm_area_id = ?'); }