Europa (54584)

Afrika (248)

Noord-Amerika (1691)

Zuid-Amerika (32)

Azië (99)

Australië (1)

Error opgetreden

Er is een probleem opgetreden waardoor wij geen gegevens uit de database kunnen halen.
De mysql error is:Unknown column 'continent_id' in 'where clause'
Query: SELECT count(*) AS total, count(distinct(ads.id)) AS total FROM ads WHERE continent_id="1" AND status_id = 1

Application stack

#0 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/base/db.php(58): DB->Query('SELECT count(*)...')
#1 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/base/activerecord.php(225): DB->FetchInArray('SELECT count(*)...')
#2 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/models/ad.php(9): ActiveRecord::find('Ad', 'ads', 3, Array)
#3 /home/tweedewoni/domains/tweedewoning.eu/public_html/app/controllers/woningen_controller.php(55): Ad::find(3, Array)
#4 /home/tweedewoni/domains/tweedewoning.eu/public_html/dispatcher.php(85): WoningenController->index()
#5 {main}

Database SQL stack

SELECT count(*) AS total, count(distinct(ads.id)) AS total FROM ads WHERE continent_id="1" AND status_id = 1
SELECT * FROM continents WHERE 1 ORDER BY id
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 1 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 2 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 3 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 4 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 5 ORDER BY name
SELECT *, (SELECT count(*) FROM ads WHERE country_id = countries.id AND status_id = 1) AS aantal FROM countries WHERE continent_id = 6 ORDER BY name