A PHP Error was encountered

Severity: Notice

Message: Undefined variable: pagetitle

Filename: includes/inc_header.php

Line Number: 124

- izudoo Local Business Directory for Derry-Londonderry
Search
Search for local businesses by name or category.
Look
Look for special offers to help you save money.
Discover
Discover the best businesses as recommended by others.
Support
Support local trade & recommend your favourite local businesses.

Welcome to izudoo.com, your number one website to find great deals from local businesses in L'Derry. 

 

At present we have over £300 of money of deals for you so save money, just type 'special offers' in the search box to view them altogether, or alternatively search by business category.

 

Over the next few months our range of special offers will grow as we add more businesses from clothes shops to restaurants. Keep up to date with the latest special offers as they are posted, by adding us as a fan on Facebook using the button on the right or subscribe to our weekly special offers email. 

The izudoo team

A PHP Error was encountered

Severity: Notice

Message: Undefined variable: psearch

Filename: home/index.php

Line Number: 716

Database Error

An Error Was Encountered

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LEAD INNER JOIN izu_regions AS REGION ON LEAD.`actual_postcode` = REGION.`postal' at line 4

SELECT izu_category_counter.id,izu_category_counter.category,izu_category_counter.counter, itc.url_category_name FROM `izu_category_counter` inner join (SELECT TRIM(AC.category_c) as cat FROM `accounts` AS ACCOUNT INNER JOIN izu_regions AS REGION ON ACCOUNT.`actual_postcode` = REGION.`postalcode` INNER JOIN accounts_cstm AS AC ON AC.id_c=ACCOUNT.id WHERE ACCOUNT.`deleted` =0 and REGION.region IN ('Londonderry') UNION SELECT TRIM(LC.category_c) as cat FROM `leads` AS LEAD INNER JOIN izu_regions AS REGION ON LEAD.`actual_postcode` = REGION.`postalcode` INNER JOIN leads_cstm AS LC ON LC.id_c=LEAD.id WHERE LEAD.`deleted` =0 and LEAD.is_active=1 and REGION.region IN ('Londonderry')) as T1 ON T1.cat=izu_category_counter.category LEFT JOIN izu_temp_category AS itc ON itc.category_name = izu_category_counter.category where izu_category_counter.counter =0 ORDER BY rand() limit 0,15