|
|
| |
|
Gurgaon Property |
|
SELECT T9.csublocationname, P.filename_Heading, P.nPropertyId, P.cPropertyName, P.nAccociateId, P.nType, P.nLocationId, P.cPropertyDetail, P.cLocationFile,
P.filename, P.cLocationName, P.active, P.add_date,
T2.cPromoterName, T3.cAccociateName, T4.cCityName, T5.cTypeName, T6.pro_status
FROM hsn_property P
LEFT JOIN hsn_promoter T2 on (P.nPromoterId = T2.nPromoterId)
LEFT JOIN hsn_promoter_accociate T3 on (T2.nPromoterId = T3.nPromoterId)
LEFT JOIN hsn_city T4 on (P.nCityId = T4.nCityId)
LEFT JOIN hsn_property_type T5 on (P.nType = T5.nTypeId)
LEFT JOIN hsn_property_status T6 on (P.property_status = T6.pro_st_id)
LEFT JOIN hsn_sub_location T9 on (P.nsublocationid = T9.nsublocationid)
WHERE T4.nCityId ='46' AND P.active='1' limit -15, 15
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 '-15, 15' at line 11 | | | |
