Stuff

gistfile1.txt

SELECT
	core_events.id AS id, 
	core_events.name AS name, 
	core_events.description AS description, 
	core_events.start_time AS start_time, 
	core_events.end_time AS end_time,
	core_events.price AS price,
	core_events.booking_url AS booking_url,
	core_events.room AS room,
	core_events.availability AS availability,
	core_events.spaces AS spaces,
	core_events.external_id AS external_id,
	core_events.kit_requirements AS kit_requirements,
	core_events.created_at AS created_at,
	core_events.updated_at AS updated_at,
	
	core_organisations.id AS organisation_id, YES
	core_organisations.name AS organisation_name, YES
	core_organisations.description AS organisation_description, YES
	core_organisations.owner_id AS organisation_owner_id, NO
	core_organisations.email AS organisation_email, NOT REALLY
	core_organisations.phone AS organisation_phone, YES
	core_organisations.website AS organisation_website, NO
	core_organisations.logo_url AS organisation_logo_url, YES
	core_organisations.instagram_account_name AS organisation_instagram_account_name, YES
	core_organisations.min_price AS organisation_min_price, NO
	core_organisations.max_price AS organisation_max_price, NO
	core_organisations.avg_price AS organisation_avg_price, NO
	core_organisations.created_at AS organisation_created_at, NO
	core_organisations.updated_at AS organisation_updated_at, NO
	
	core_venues.id AS venue_id, YES
	core_venues.name AS venue_name, YES
	core_venues.address AS venue_address, YES
	core_venues.phone AS venue_phone, YES
	core_venues.logo_url AS venue_logo_url, YES
	core_venues.latitude AS venue_latitude, YES
	core_venues.longitude AS venue_longitude, YES
	core_venues.exclusive AS venue_exclusive, NO 
	core_venues.showers AS venue_showers, YES
	core_venues.towels AS venue_towels, YES
	core_venues.yoga_mat AS venue_yoga_mat, NO
	core_venues.cycling_shoes AS venue_cycling_shoes, YES
	core_venues.trainers AS venue_trainers, YES
	core_venues.half_day_cancellation AS venue_half_day_cancellation, YES
	core_venues.full_day_cancellation AS venue_full_day_cancellation, YES
	core_venues.created_at AS venue_created_at, NO
	core_venues.updated_at AS venue_updated_at NO