|
|
|
|
| Advanced filtering system |
| * | Mark desired categories and the system will filter results for you | |
|
|
weekend vacancies
|
|
|
|
| |
|
|
59:s3 Incorrect DATE value: ''
SELECT SQL_CALC_FOUND_ROWS sites.siteID, sites.unit_desc_eng, sites.totalNumRooms_txt_eng as `rnum`, sites.unit_price_eng, sites.unit_priceTo_eng, sites.phone1, sites.phone2, sites.prPicture1, sites.link_type,sites.newSelect, sites.newSearchPic1, sites.newSearchPic2, sites.enableOutLinks, sites.typeID, sites.shortDesc_eng AS shortDesc, sites.longDesc_eng AS longDesc, sites.TITLE_eng AS TITLE, settlements.TITLE_eng as settlement_name, main_areas.TITLE_eng as area_name, IF(sites.link_type = 1,sites.link,'') as `link`, SitesPartnerPhones.zphone, '1' as `nw`, COUNT(DISTINCT dates.dateID) as `dates`, UNIX_TIMESTAMP(sites.upd_time) as `upd_time`
FROM `sitesTypes` INNER JOIN `sites` USING(`siteID`) INNER JOIN `settlements` USING(`settlementID`) INNER JOIN `areas` USING(`areaID`) INNER JOIN `main_areas` USING(`main_areaID`)
INNER JOIN `Deals` ON (Deals.siteID = sites.siteID AND Deals.Deal_type_ID = 1)
LEFT JOIN `dates` ON (dates.siteID = sites.siteID AND dates.dateType = sites.freeType AND dates.date BETWEEN '' AND '')
LEFT JOIN `sitesLocations` ON (sites.siteID = sitesLocations.siteID)
LEFT JOIN `SitesPartnerPhones` ON (sites.siteID = SitesPartnerPhones.siteID AND SitesPartnerPhones.partnerID = 0)
WHERE sites.if_show = '1' AND Deals.Active = 1 AND (CURDATE() BETWEEN Deals.startDate AND Deals.endDate) AND (dates.A > 0 OR dates.A IS NULL) AND sitesTypes.typeID = 1
GROUP BY sites.siteID
ORDER BY `nw`, `upd_time` DESC /*sites.upd_free DESC*/
LIMIT 0 , 14 |
Contact us
Facebook
Application
Add to favorites
Send to friend
