Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- p.partnerid
- FROM
- partners AS p
- LEFT JOIN
- partner_appointment_types AS pat ON pat.partner_id = p.partnerid
- LEFT JOIN
- partners_details AS pd ON pd.id = p.partnerid
- JOIN
- appointment_types AS at ON at.id = pat.appointment_type_id
- JOIN
- client_pending AS cp ON cp.partnerid = p.partnerid
- WHERE
- cp.datetime NOT BETWEEN '2010-10-28 14:30:00' AND ( '2010-10-28 14:30:00' + INTERVAL at.length_of_time MINUTE )
- AND
- pd.location_id = 1
- AND
- pat.appointment_type_id = 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement