Skip to content

Instantly share code, notes, and snippets.

@DemitryT

DemitryT/sql.sql

Created July 12, 2012 20:39
Show Gist options
  • Save DemitryT/3100810 to your computer and use it in GitHub Desktop.
Save DemitryT/3100810 to your computer and use it in GitHub Desktop.
Download ZIP
sql.sql
Raw
sql.sql
SELECT `companies`.* FROM `companies` INNER JOIN `company_services`
ON `company_services`.`company_id` = `companies`.`id`
WHERE (company_services.id is not null) AND (active = 1 AND staging = 0 AND trulia_feed = 1);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment