Revision 11998
Added by Aaron Marcuse-Kubitza about 11 years ago
| trunk/schemas/vegbien.sql | ||
|---|---|---|
| 830 | 830 |
AS $_$ |
| 831 | 831 |
SELECT commdescription |
| 832 | 832 |
FROM commclass |
| 833 |
LEFT JOIN commdetermination USING (commclass_id) |
|
| 833 |
/* inner-join to commdetermination instead of left-joining, so that this does |
|
| 834 |
not produce community entries (which occur because there is one commclass per |
|
| 835 |
locationevent, but only some commclasses will then have a commdetermination) */ |
|
| 836 |
JOIN commdetermination USING (commclass_id) |
|
| 834 | 837 |
LEFT JOIN commconcept USING (commconcept_id) |
| 835 | 838 |
WHERE locationevent_id = $1 |
| 836 | 839 |
ORDER BY commdescription |
Also available in: Unified diff
bugfix: schemas/vegbien.sql: locationevent__communities(): inner-join to commdetermination instead of left-joining, so that this does not produce community entries (which occur because there is one commclass per locationevent, but only some commclasses will then have a commdetermination)