no results select * from contacts, accommrecs, bandbrecs where contacts.refno=accommrecs.refno and accommrecs.accomref=bandbrecs.accomref and accommrecs.activeaccom=1 and accommrecs.accomtype>2 and not (accommrecs.northing<3000 or accommrecs.easting=0) and accommrecs.accomtype=4 and (( * + accommrecs.easting * accommrecs.easting - 2 * accommrecs.easting * ) + ( * + accommrecs.northing * accommrecs.northing - 2 * accommrecs.northing * )) < 0 order by bandbrecs.ranking, accommrecs.location, accommrecs.name

google plus

facebook