SELECT * FROM _type WHERE type = 'nightlife'
Table 'smme_joburg_db._type' doesn't exist
SELECT location_city.city_id,location_city.city,CONCAT("CACHE_THIS")
FROM location_city
INNER JOIN ON .city_id = location_city.city_id
WHERE location_city.province_id='3'
GROUP BY location_city.city ASC
ORDER BY location_city.city ASC
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 'ON .city_id = location_city.city_id
WHERE location_city.province_id='3' at line 3
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "a"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "b"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "c"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "d"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "e"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "f"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "g"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "h"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "i"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "j"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "k"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "l"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "m"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "n"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "o"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "p"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "q"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "r"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "s"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "t"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "u"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "v"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "w"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "x"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "y"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4
SELECT count(*),CONCAT("CACHE_THIS") c
FROM
INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN _type
ON _type.type_id = .type_id
LEFT JOIN location_city
ON location_city.city_id = .city_id
WHERE active_yn = "1"
AND deleted_yn = "0"
AND seo_perma_link != ""
AND _rel_portal.portal_id="1"
AND .type_id IN ("-1")
AND SUBSTRING(name,1,1) LIKE "z"
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 'INNER JOIN _rel_portal
ON ._id = _rel_portal._id
LEFT JOIN ' at line 4


