Abills

Queries: 7

Queries:

1  ===================================
      SELECT 
      0,
      a.full_log,
      a.id AS a_login,
      a.disable,
      a.web_options,
      a.gid,
      a.position,
      a.domain_id,
      a.max_credit,
      a.max_rows,
      a.credit_days,
      a.expire,
      COUNT(ag.aid) AS gids_,
      COUNT(aa.aid) AS admin_access,
      a.aid,
      a.name AS a_fio
     FROM
      admins a
     LEFT JOIN admins_groups ag ON (a.aid=ag.aid)
     LEFT JOIN domains d ON (a.domain_id=d.id)
     LEFT JOIN admins_access aa ON (aa.aid=a.aid)
     WHERE a.aid= ? 
     GROUP BY a.aid
     ORDER BY a.aid DESC
     LIMIT 1;
 2  ===================================
      SELECT param, value FROM config WHERE domain_id = ?
 3  ===================================
      SELECT  c.user_name, c.framed_ip_address,
    c.uid,c.nas_id,c.acct_session_id,c.user_name
      FROM internet_online c
      LEFT JOIN users u ON (u.uid=c.uid)
      LEFT JOIN internet_main service ON (service.id = c.service_id)
      
      WHERE (c.framed_ip_address=INET_ATON('3.239.236.140')) AND ((c.status=1 OR c.status>=3) AND c.status<11)
      GROUP BY c.acct_session_id, c.uid, c.service_id
      ORDER BY 1 
      ;
 4  ===================================
      SELECT param, value FROM config WHERE (param LIKE 'ifu%') and domain_id='0' ORDER BY 2 
 5  ===================================
      SELECT COUNT(*) AS total FROM config WHERE (param LIKE 'ifu%') and domain_id='0'
 6  ===================================
      SELECT
       u.id AS login,internet.ip AS ip_num, 
      u.uid,
      internet.tp_id,
      internet.id
     FROM users u
     INNER JOIN internet_main internet ON (u.uid=internet.uid)
     LEFT JOIN tarif_plans tp ON (tp.tp_id=internet.tp_id)
     
     WHERE u.deleted='0' AND (internet.ip=INET_ATON('3.239.236.140')) AND u.deleted=0
     GROUP BY u.uid
     ORDER BY 1  LIMIT 0, 25;
 7  ===================================
      SELECT COUNT( DISTINCT u.id) AS total, COUNT(u.id) AS total_services FROM users u
    INNER JOIN internet_main internet ON (u.uid=internet.uid)
    LEFT JOIN tarif_plans tp ON (tp.tp_id=internet.tp_id)
    
    WHERE u.deleted='0' AND (internet.ip=INET_ATON('3.239.236.140')) AND u.deleted=0