SHOW:
|
|
- or go back to the newest paste.
| 1 | - | SELECT DISTINCT astops.name, subquery.name FROM |
| 1 | + | SELECT DISTINCT astops.name, bbstops.name FROM |
| 2 | route a JOIN route b ON a.company=b.company AND a.num = b.num | |
| 3 | JOIN stops astops ON a.stop = astops.id | |
| 4 | JOIN stops bstops ON b.stop = bstops.id | |
| 5 | WHERE astops.name = 'Craiglockhart' AND bstops.name IN ( | |
| 6 | SELECT aastops.name FROM | |
| 7 | route aa JOIN route bb ON aa.company=bb.company | |
| 8 | AND aa.num = bb.num | |
| 9 | JOIN stops aastops ON aa.stop = aastops.id | |
| 10 | JOIN stops bbstops ON bb.stop = bbstops.id | |
| 11 | WHERE bbstops.name = 'Sighthill' | |
| 12 | ) |
