gctools-outilsgc /
gcconnex
| @@ 1339-1347 (lines=9) @@ | ||
| 1336 | $selects = ''; |
|
| 1337 | } |
|
| 1338 | ||
| 1339 | if (!$options['count']) { |
|
| 1340 | $distinct = ''; |
|
| 1341 | if ($options['require_distinct']) { |
|
| 1342 | $distinct = ' DISTINCT'; |
|
| 1343 | } |
|
| 1344 | $query = "SELECT{$distinct} e.guid FROM {$CONFIG->dbprefix}entities e "; |
|
| 1345 | } else { |
|
| 1346 | $query = "SELECT count(DISTINCT e.guid) as total FROM {$CONFIG->dbprefix}entities e "; |
|
| 1347 | } |
|
| 1348 | ||
| 1349 | // add joins |
|
| 1350 | foreach ($joins as $j) { |
|
| @@ 1491-1499 (lines=9) @@ | ||
| 1488 | $selects = ''; |
|
| 1489 | } |
|
| 1490 | ||
| 1491 | if (!$options['count']) { |
|
| 1492 | $distinct = ''; |
|
| 1493 | if ($options['require_distinct']) { |
|
| 1494 | $distinct = ' DISTINCT'; |
|
| 1495 | } |
|
| 1496 | $query = "SELECT{$distinct} e.guid{$selects} FROM {$CONFIG->dbprefix}entities e "; |
|
| 1497 | } else { |
|
| 1498 | $query = "SELECT count(DISTINCT e.guid) as total FROM {$CONFIG->dbprefix}entities e "; |
|
| 1499 | } |
|
| 1500 | ||
| 1501 | // add joins |
|
| 1502 | foreach ($joins as $j) { |
|
