Salacgrīvas municipality Salacgrīvas municipality 
../../../../../ Lapas karte e-pasts
  • LAT
  • RUS
  • ENG

07.03.2021, Sunday

Ella, Elmīra

SalacgrīvaSalacgrīvaAinažiAinažiLiepupeLiepupe
  • Visit Salacgriva
  • Video
  • District municipality
    • Salacgriva Town hall
    • History
    • Culture and recreation
    • Map
    • Salacgriva port
    • Salacgriva Tourism information centre
    • Museum
    • Youth
    • Green Municipality Decleration
  • Find company in Salacgrivas district
  • Invalid query: Disk full (/var/tmp/#sql_a3b_2); waiting for someone to free some space... SELECT DISTINCT b.id, b.name, b.path, b.width, b.height, b.url, b.priority, b.body_text FROM banner b JOIN banner_has_category hc ON b.id=hc.banner_id AND ( -- banner in self and child categories (hc.with_childs=1 AND hc.category_id IN (0, 1281, 1284, 1376, 1377, 1438)) OR -- banner in only my category (hc.with_childs=0 AND hc.category_id=1438) ) WHERE b.status > 0 AND b.type=0 ORDER BY b.priority DESC