DB Error: no such field # 1 City, 2 Type, 3 status, 4 Lang, 5 Limit, 6 Offset, 7 toshow
# a.itemid, a.price, a.area, a.created, a.toshow
SELECT
a.itemid,
a.price,
a.area,
a.created,
a.toshow,
a.img,
a.rooms,
b.title,
b.description,
c.districtname,
f.districtname as endistrictname,
d.typename,
g.typename as entypename,
e.statusname,
h.statusname as enstatusname,
special,
to_days(now()) - to_days(created) as days
FROM
icatalogItems a,
icatalogItemDetails b,
icatalogItemDistricts c,
icatalogItemTypes d,
icatalogItemStatus e,
icatalogItemDistricts f,
icatalogItemTypes g,
icatalogItemStatus h
WHERE
a.itemid = b.itemid
AND ( (a.toshow = 1) OR (a.toshow = 1) )
AND a.districtid = c.districtid
AND a.typeid = d.typeid
AND a.statusid = e.statusid
AND b.langid = 'en'
AND c.langid = 'en'
AND d.langid = 'en'
AND e.langid = 'en'
AND f.langid = 'en'
AND g.langid = 'en'
AND h.langid = 'en'
AND c.districtid = f.districtid
AND d.typeid = g.typeid
AND e.statusid = h.statusid
AND ( (SOUNDEX(f.districtname) = SOUNDEX('%')) OR (f.districtname LIKE '%') )
AND ( (SOUNDEX(g.typename) = SOUNDEX('%')) OR (g.typename LIKE '%') )
AND ( (SOUNDEX(h.statusname) = SOUNDEX('For%20sale')) OR (h.statusname LIKE 'For%20sale') )
AND a.rooms = marinos.css
#Omit hidden items
ORDER BY itemid, districtname, typename, statusname
LIMIT 0, 5
[nativecode=1054 ** Unknown column 'marinos.css' in 'where clause'] DB Error: no such field # 1 City, 2 Type, 3 status, 4 Lang, 5 toshow
# a.itemid, a.price, a.area, a.created, a.toshow
SELECT count(*)
FROM
icatalogItems a,
icatalogItemDetails b,
icatalogItemDistricts c,
icatalogItemTypes d,
icatalogItemStatus e,
icatalogItemDistricts f,
icatalogItemTypes g,
icatalogItemStatus h
WHERE
a.itemid = b.itemid
AND ( (a.toshow = 1) OR (a.toshow = 1) )
AND a.districtid = c.districtid
AND a.typeid = d.typeid
AND a.statusid = e.statusid
AND b.langid = 'en'
AND c.langid = 'en'
AND d.langid = 'en'
AND e.langid = 'en'
AND f.langid = 'en'
AND g.langid = 'en'
AND h.langid = 'en'
AND c.districtid = f.districtid
AND d.typeid = g.typeid
AND e.statusid = h.statusid
AND ( (SOUNDEX(f.districtname) = SOUNDEX('%')) OR (f.districtname LIKE '%') )
AND ( (SOUNDEX(g.typename) = SOUNDEX('%')) OR (g.typename LIKE '%') )
AND ( (SOUNDEX(h.statusname) = SOUNDEX('For%20sale')) OR (h.statusname LIKE 'For%20sale') )
AND a.rooms = marinos.css
[nativecode=1054 ** Unknown column 'marinos.css' in 'where clause'] Cyprus Property Online, Cyprus Real Estate Properties, Cyprus Villa Rentals Available in Larnaca.
