| SQLSTATE |
42000 |
| SQL |
SELECT
TBL_ClientManage.ClientM_ID,
TBL_ClientManage.SW_URL_Link,
TBL_ClientManage.SW_More_Info_Link,
TBL_ClientManage.COMPANYNAMEDISPLAY,
TBL_ClientManage.DisplayAddress,
TBL_ClientManage.ClientWebsiteStatus,
TBL_ClientManage.LoyalRewards,
TBL_ClientManage.SW_SameSex,
TBL_ClientCity.Phone,
TBL_ClientCity.Address,
TBL_ClientCity.City,
TBL_ClientCity.COUNTRY,
TBL_ClientCity.PROVINCE,
TBL_ClientCity.tollFree,
TBL_ClientCity.Email,
TBL_ClientCity.CityID,
TBL_ClientCity.URL,
TBL_WedClientCat.CatID,
TBL_Category.MasterCategoryID,
TBL_Category.CategoryName,
TBL_Category.SectionID,
TBL_City.CityName,
TBL_City.Online,
TBL_ClientCity.LONG_LAT,
TBL_City.tabStatus
FROM TBL_ClientManage INNER JOIN
TBL_WedClientCat ON TBL_ClientManage.ClientM_ID = TBL_WedClientCat.ClientM_ID
INNER JOIN
TBL_ClientCity ON TBL_ClientManage.ClientM_ID = TBL_ClientCity.ClientM_ID
INNER JOIN
TBL_Category ON TBL_WedClientCat.CatID = TBL_Category.CatID
INNER JOIN
TBL_City ON TBL_ClientCity.CityID = TBL_City.CityID
WHERE
TBL_WedClientCat.CatID IN ()
AND TBL_ClientManage.SW_Online = 1
AND TBL_ClientCity.CityID IN (30,69,70,65,19,44,73,52,53,71,72)
AND ((TBL_City.tabStatus = 0 AND TBL_Category.SectionID = 1) OR TBL_City.tabStatus = 1)
AND TBL_ClientManage.MembershipLevel IN (4,2,3)
AND TBL_City.Online = 1
ORDER BY TBL_City.Province, TBL_City.CityName, TBL_ClientManage.MembershipLevel DESC, TBL_ClientManage.CompanyNameDISPLAY;
|
| VENDORERRORCODE |
1064 |
| DATASOURCE |
weddingswest |
|