=> 132
SELECT i.*,c.name AS categoryname,c.id AS categoryid, c.alias AS categoryalias, c.params AS categoryparams FROM #__k2_items as i RIGHT JOIN #__k2_categories c ON c.id = i.catid WHERE i.published = 1 AND i.access IN(1,1) AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.trash = 0 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2018-09-23 16:10:23' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2018-09-23 16:10:23' ) AND i.catid IN (132,133,134,135,136,138,139,140,141,142,143,144,145,146,151,152,153) AND c.language IN ('en-GB', '*') AND i.language IN ('en-GB', '*') ORDER BY i.id DESC
The Organization for the Care and Protection of Stray Animals-Stray.gr is a non-profit organization which aims to provide support to the stray animals in Greece. Since its inception in 2001, Stray.gr has helped more than 2,000 stray animals in the wider area of Attica,
Genelabs are equipped with the latest high-tech machines across the diagnostic spectrum of research and clinical diagnostics to ensure the processing and identification of any kind of biological material. The diagnostic results are being reached through the highest standards of quality and reliability.
Social Street Work is our main and most crucial activity. It follows the basic principles of the organisation ‘ Dynamo International ‘ which coordinates the national network of street workers. It addresses people who have found themselves in the streets.
The Solidarity Night Centre is open every Saturday and Wednesday at synAthina (Athinas Street 57, across Varvakeios Market). The Centre offers board games, counselling, legal support and, most important of all, a warm, friendly and safe environment to people who face the harsh reality of homelessness and are forced to survive in the streets. The business hours are from 00:00 to 06:00 and during summer from 21:30 to 00:30.
At Checkpoint you can take a free and anonymous fast test for HIV. You can book an appointment by phone or by visiting our premises. If HIV antibodies are detected, additional time is offered in order for you to get all the information and directions you need.