Array
(
[code] => 1
[value] => Resource id #149
[numrows] =>
[sql] => SELECT ptt.* FROM propertytype AS pt
LEFT JOIN propertytypetype AS ptt USING(propertytypetypeid)
LEFT JOIN property AS p USING(propertyid)
LEFT JOIN client_prop_room AS cpr USING (propertyid)
WHERE p.cityid='15'
AND cpr.client_id = '5000'
AND cpr.prop_disabled = 0
AND cpr.prop_inactive = 0
AND cpr.room_disabled = 0
AND cpr.room_inactive = 0
GROUP BY ptt.propertytypetypeid;
)
- Rate must be for the exact same property, quality level, number of guests, property management, and in the same currency. - There must be availability at that property, in that same category, and for identical vacation dates. (Arrival and depart ure dates must remain the same). - Refund and payment policies must be identical. - Bulk rates for groups, organizations or membership clubs are not included in this offer. - Convention, award redemption program, coupons, package or travel industry rates are not included in this offer.
Array
(
[code] => 1
[value] => Resource id #175
[numrows] =>
[sql] => SELECT ptt.* FROM propertytype AS pt
LEFT JOIN propertytypetype AS ptt USING(propertytypetypeid)
LEFT JOIN property AS p USING(propertyid)
LEFT JOIN client_prop_room AS cpr USING (propertyid)
WHERE p.cityid='15'
AND cpr.client_id = '5000'
AND cpr.prop_disabled = 0
AND cpr.prop_inactive = 0
AND cpr.room_disabled = 0
AND cpr.room_inactive = 0
GROUP BY ptt.propertytypetypeid;
)