Unknown column 'is_approved' in 'where clause' SELECT count(*)
FROM entry
WHERE is_approved = 1
Unknown column 'category_id' in 'where clause' SELECT count(*) FROM entry e
INNER JOIN city cc ON e.city_id = cc.id
WHERE category_id = 145 AND is_approved = 1 AND city_id = 12 AND 1=1
Unknown column 'e.id' in 'field list' SELECT e.id,
e.name,
e.description,
e.address,
e.contact_person,
e.contact_mail,
e.phone,
e.fax,
e.mail,
e.url,
e.category_id,
e.city_id,
e.is_approved,
e.is_confirmed,
e.is_vip,
e.date,
e.image,
e.code,
cc.name city_name, cc.code city_code FROM entry e
INNER JOIN city cc ON e.city_id = cc.id
WHERE category_id = 145 AND is_approved = 1 AND city_id = 12 AND 1=1 ORDER BY is_vip DESC, name LIMIT 0, 30
Uslugi.bg - услуги.бг : Каталогът на бизнеса в България - The Bulgarian business-pages - Der bulgarische Businesskatalog