SELECT TOP 200 * , ( CASE WHEN [Charity Name] LIKE '%35%' AND [Charity Name] LIKE '%Kildare%' AND [Charity Name] LIKE '%Rd%' THEN 1 ELSE 0 END) AS [priority]
FROM advanced_search
WHERE (
( [Charity Name] LIKE '%35%' AND [Charity Name] LIKE '%Kildare%' AND [Charity Name] LIKE '%Rd%' )
OR ( [how purposes were pursued] LIKE '%35%' AND [how purposes were pursued] LIKE '%Kildare%' AND [how purposes were pursued] LIKE '%Rd%' )
OR [Full Address] LIKE '%35 Kildare Rd%'
OR [Operating Countries List] LIKE '%35 Kildare Rd%'
) AND [Latitude] IS NOT NULL AND [Logitude] IS NOT NULL AND [Charity Name] IS NOT NULL ORDER BY [priority] DESC
See list of 2 results below
| Charity Name and Details | Size | Financials | More Details | Main Address |
|---|---|---|---|---|
UKRAINIAN AUTOCEPHALIC ORTHODOX CHURCH COMMUNITY OF HOLY TRANSFIGURATION IN BLACKTOWN INCORPORATEDMain beneficiaries Adults - aged 25 to under 65; Adults - aged 65 and over; Children - aged 6 to under 15; Early childhood - aged under 6; Families; Youth - 15 to under 25 Extra Small$13.7k income $9.9k expenses 0% staff costs 20 volunteers 35 Kildare Rd |
Extra Small |
$13.7k income $9.9k expenses 0% staff costs |
20 volunteers |
|
RUSSIAN ORTHODOX CHURCHMain beneficiaries Adults - aged 65 and over Children - aged 6 to under 15 Families Youth - 15 to under 25 Small$79.5k income $56.5k expenses 0% staff costs 12 volunteers 135 Kildare Rd |
Small |
$79.5k income $56.5k expenses 0% staff costs |
12 volunteers |
