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 = ?');
}