lib/db/connect.php
lib/conf/conf.php
lib/inc/address.search.php
  $q = "SELECT foretaksnr, markedsnavn, x_koordinat, y_koordinat, adresse FROM firma "
lib/inc/telefon/telefon.php
  $query = "SELECT SQL_CALC_FOUND_ROWS foretaksnr,markedsnavn,tlf,mobil,x_koordinat,y_koordinat,sted "
lib/inc/test.php
lib/inc/imagefunctions.php
lib/inc/vis/vis.php
lib/inc/vis/noresults.php
lib/inc/vis/companyinfo.class.php
  private $foretaksnr;
    $this->foretaksnr = (int) $ftknr + 0;
      ."LEFT JOIN firma_har_url fu ON (f.foretaksnr=fu.foretaksnr) "
      ."WHERE f.foretaksnr={$this->foretaksnr}";
      ."WHERE foretaksnr={$this->foretaksnr} ORDER BY imageid";
    return $this->foretaksnr;
lib/inc/info/firmainfo.class.php
  private $foretaksnr;
    $this->foretaksnr    = $firma['foretaksnr'];
    $q = "SELECT f.foretaksnr, firmanavn, markedsnavn, adresse, postnr, sted, infotekst, "
      ."LEFT JOIN firma_har_url fu ON (f.foretaksnr=fu.foretaksnr) "
      ."WHERE f.foretaksnr=$ftknr";
    $q = "SELECT moduletype FROM company_modules WHERE foretaksnr = {$this->foretaksnr}";
      ."WHERE kf.keywordid=k.keywordid AND foretaksnr={$this->foretaksnr} "
    return $this->foretaksnr;
lib/inc/info/imagegallery.class.php
        ."WHERE foretaksnr = {$this->ftknr} "
lib/inc/info/info.php
lib/inc/browser.php
lib/inc/sted.class.php
lib/inc/tagcloud.class.php
  private $foretaksnr;
lib/inc/selgerlogin.php
lib/inc/head.php
lib/inc/sales/sales.php
  $q = "INSERT INTO log_sales (userid, foretaksnr, logdate, event, text, sql) "
      ."WHERE kf.keywordid=k.keywordid AND foretaksnr=$ftknr ORDER BY keyword ";
  $q = "SELECT sted_rank FROM keyword_har_firma WHERE foretaksnr=$ftknr ORDER BY sted_rank desc ";
      ."WHERE l.userid=u.userid AND foretaksnr=$ftknr ORDER BY logdate DESC $lim";
  $q = "SELECT f.foretaksnr, firmanavn, markedsnavn, adresse, postnr, sted, kunde, kommunenr, infotekst, "
      ."LEFT JOIN firma_har_url fu ON (f.foretaksnr=fu.foretaksnr) "
      ."WHERE f.foretaksnr=$ftknr";
      ."WHERE b.bransjekode=fb.bransjekode AND fb.foretaksnr=$ftknr";
  $q = "SELECT foretaksnr FROM keyword_har_firma "
  $q = "INSERT INTO company_imagegallery (foretaksnr, filename, title, description ) "
lib/inc/sales/head.php
lib/inc/sales/imagegallery.class.php
        ."WHERE foretaksnr = {$this->ftknr} "
lib/inc/sales/companyinfo.class.php
  public  $foretaksnr;
    $q = "SELECT f.foretaksnr, firmanavn, markedsnavn, adresse, postnr, sted, kunde, kommunenr, infotekst, "
      ."LEFT JOIN firma_har_url fu ON (f.foretaksnr=fu.foretaksnr) "
      ."WHERE f.foretaksnr=$ftknr";
    $this->foretaksnr    = $ftknr;
      ."WHERE b.bransjekode=fb.bransjekode AND fb.foretaksnr={$this->foretaksnr}";
    $q = "SELECT moduletype FROM company_modules WHERE foretaksnr = {$this->foretaksnr}";
    $out = "<b>Foretaksnr:</b> {$this->foretaksnr}<br />\n"
lib/inc/main.php
  $q = "SELECT SQL_CALC_FOUND_ROWS foretaksnr, keywordid "
    $q = "INSERT INTO log_popup (foretaksnr, keywordid, hits) "
        ."VALUES( {$res['foretaksnr']}, {$res['keywordid']}, 1 ) ON DUPLICATE KEY UPDATE hits=hits+1";
  $q = "SELECT SQL_CALC_FOUND_ROWS foretaksnr, keyword, sted_rank "
  $q = "SELECT f.foretaksnr, firmanavn, markedsnavn, adresse, postnr, sted, infotekst, "
      ."LEFT JOIN firma_har_url fu ON (f.foretaksnr=fu.foretaksnr) "
      ."WHERE f.foretaksnr=$ftknr";
lib/inc/keyword.class.php
lib/inc/login.php
lib/inc/rest.php
  $firmaer[] = new CompanyInfo( $db, $i, $results[$i-1]['foretaksnr'] );
lib/inc/firmanavn/firmanavn.php
                $query = "SELECT SQL_CALC_FOUND_ROWS foretaksnr,markedsnavn,x_koordinat,y_koordinat,sted FROM `firma` WHERE `foretaksnr`='$search'";
                $query = "SELECT SQL_CALC_FOUND_ROWS foretaksnr,markedsnavn,x_koordinat,y_koordinat,sted "