| SQL |
SELECT DISTINCT (va.propertyid) AS propertyID, p.name AS pname, v.name AS vname, c.name AS cname, r.name AS rname
,MIN(va.minprice) AS price, MAX(maxprice) AS maxprice,
MIN(va.sleeps) AS sleeps, va.sortOrder, p.mainpictureroot,
p.mainpicture, pc.includestravel, pc.includesflights, pc.includesferry, pc.includeseurotunnel, pc.includescarhire,
pc.accommonly, va.regioncode, va.countrycode, MAX(va.lastmodified) AS lastModified, va.regioncode as rcode
,
min(va.unitid) as unitid
FROM avail_write.prod_villasAvail_2 va, avail_write.property p, avail_write.village v, avail_write.region r, avail_write.country c, avail_write.pricecode pc ,igluvillasnewDB..propertyfeature pf
WHERE 0 = 0
AND va.propertyID = p.propertyID
AND p.villageID = v.villageID
AND v.regionCode = r.regionCode
AND r.countryCode = c.countryCode
AND va.pricecode = pc.pricecode
AND va.regioncode not in (
'PO',
'LB',
'BU',
'DO',
'LO',
'MI',
'TT',
'TK',
'TS',
'UM',
'')
AND p.publish = 1
AND va.propertyid = pf.propertyid
AND pf.featurecode in (
'BNB',
'')
GROUP BY va.propertyid, p.name, v.name, r.name, c.name,
va.sortOrder, p.mainpictureroot, p.mainpicture,
pc.includestravel, pc.includesflights, pc.includesferry,
pc.includeseurotunnel, pc.includescarhire, pc.accommonly,
va.regioncode, va.countrycode
ORDER BY va.sortorder ASC
|
| DATASOURCE |
villasAvailability |
| SQLSTATE |
08001 |
|