asked on
SELECT
DISTINCT `contacts`.`contactID`,
`contacts`.`first`,
`contacts`.`last`,
`contacts`.`email`
FROM
`suspended_inventory` si, `reservations`,`contacts`
WHERE
`si`.`reservationID` = `reservations`.`reservationID`
AND `reservations`.`reservation_date` BETWEEN '20110101' AND '20141231'
AND `si`.`contactID` = `contacts`.`contactID`
AND `contacts`.`email` != ''
AND `contacts`.`deceased` != 'Y'
AND `contacts`.`omit_from_future_mailings` != 'Y'
ORDER BY `contacts`.`contactID`
SELECT
COUNT(`inventory`.`reservationID`) AS 'total'
FROM
`inventory`,`reservations`
WHERE
`inventory`.`passengerID` = '99'
AND `inventory`.`reservationID` = `reservations`.`reservationID`
AND `reservations`.`reservation_date` BETWEEN '20110101' AND '20141231'