Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT COUNT(*) FROM "webdesk_equipmentrental"
- INNER JOIN "webdesk_equipment"
- ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
- INNER JOIN "webdesk_equipmentcategory" ON
- ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
- WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
- ;
- CREATE TEMP TABLE asdf AS
- SELECT "webdesk_equipmentrental".id FROM "webdesk_equipmentrental"
- INNER JOIN "webdesk_equipment"
- ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
- INNER JOIN "webdesk_equipmentcategory" ON
- ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
- WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
- ;
- DELETE FROM "webdesk_equipmentrental"
- WHERE id IN asdf
- ;
- SELECT COUNT(*) FROM "webdesk_equipmentrental"
- INNER JOIN "webdesk_equipment"
- ON ("webdesk_equipmentrental"."equipment_id" = "webdesk_equipment"."id")
- INNER JOIN "webdesk_equipmentcategory" ON
- ("webdesk_equipment"."category_id" = "webdesk_equipmentcategory"."id")
- WHERE "webdesk_equipmentcategory"."reception_desk_id" = 'hutchens'
Add Comment
Please, Sign In to add comment