APP_NAME=parrot
SQL_LST_BULLETS=SELECT wp_posts.ID, wp_posts.post_title FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE wp_terms.name = 'Project_Description_Bullet' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.ID
SQL_LST_SHORT_STORIES=SELECT wp_posts.ID, wp_posts.post_title FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE wp_terms.name = 'Project_Description_Short' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.ID
SQL_LST_LONG_STORIES=SELECT wp_posts.ID, wp_posts.post_title FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE wp_terms.name = 'Project_Description_Long' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.ID
SQL_LST_SPECIAL_STORIES=SELECT wp_posts.ID, wp_posts.post_title FROM wp_posts LEFT JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id) LEFT JOIN wp_term_taxonomy ON (wp_term_relationships.term_taxonomy_id = wp_term_taxonomy.term_taxonomy_id) LEFT JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id) WHERE wp_terms.name = 'Project_Description_Special' AND wp_posts.post_status = 'publish' ORDER BY wp_posts.ID
SQL_VIEW_STORY=SELECT wp_posts.post_title, wp_posts.post_content FROM wp_posts WHERE wp_posts.ID = ?
SQL_LST_CONTRACTS=SELECT c1.name AS 'c1/contractor', c1.city AS 'c1/city', c1.state AS 'c1/state', c2.name AS 'c2/client' , c2.city AS 'c2/city', c2.state AS 'c2/state', c.job_title, c.start_date, c.end_date, c.`wp_tag` FROM company AS c1, company AS c2, contract AS c WHERE c.contract_company = c1.id AND c.client_company = c2.id ORDER BY c.`start_date` DESC;
SQL_DESC_EXPERIENCE=SELECT t.name, p.post_name, p.post_content FROM wp_posts AS p, wp_term_relationships AS r, wp_term_taxonomy AS z, wp_terms AS t WHERE t.term_id = z.term_taxonomy_id AND z.term_taxonomy_id = r.term_taxonomy_id AND r.object_id = p.id AND t.name = ?;
SQL_LST_SKILLSET=SELECT t.name FROM wp_term_taxonomy AS z, wp_terms AS t, wp_term_relationships AS r, wp_posts AS p WHERE t.term_id = z.term_taxonomy_id AND z.term_taxonomy_id = r.term_taxonomy_id AND r.`object_id` = p.`ID` AND z.taxonomy = 'post_tag' AND t.name LIKE 'ss%' AND p.post_name = ?;