SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_pharr_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-11' AND p.permit_issue_date <= '2017-12-12 23:59:59' AND pt.type_id = '39' AND p.permit_type_code != '' AND ( EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '1'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '2'  AND tds1.store_value LIKE '%%' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '3'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        ) )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_pharr_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-11' AND p.permit_issue_date <= '2017-12-12 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '1'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '2'  AND tds1.store_value LIKE '%%' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '3'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        ) )  
1835
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_pharr_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-11' AND p.permit_issue_date <= '2017-12-12 23:59:59' AND pt.type_id = '16' AND p.permit_type_code != '' AND ( EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '1'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '2'  AND tds1.store_value LIKE '%%' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '3'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        ) )  
0
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_pharr_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-11' AND p.permit_issue_date <= '2017-12-12 23:59:59' AND pt.type_id = '35' AND p.permit_type_code != '' AND ( EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '1'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '2'  AND tds1.store_value LIKE '%%' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '3'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        ) )  
561
SELECT * FROM tbl_permit AS p JOIN tbl_permit_type AS pt ON pt.code = SUBSTR(p.permit_id, 4, INSTR(SUBSTR(p.permit_id, 4, LENGTH(p.permit_id)),'-')-1) LEFT JOIN mygov_pharr_tx__lm.tbl_location AS l ON p.location_id = l.location_id WHERE 1 AND p.permit_issue_date != '0000-00-00' AND p.permit_issue_date >= '2017-12-11' AND p.permit_issue_date <= '2017-12-12 23:59:59' AND pt.type_id = '8' AND p.permit_type_code != '' AND ( EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '1'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '2'  AND tds1.store_value LIKE '%%' ) )        )  AND EXISTS (SELECT * FROM mygov_pharr_tx__lm.tbl_datastore AS tds1         WHERE tds1.location_id = l.location_id         AND ( (tds1.type_id = '3'  AND tds1.store_value REGEXP '^[[:space:]]*$' ) )        ) )  
0
City of Pharr's
Inspections Summary - By Region
12/11/17 to 12/12/17
  Permit Applications Permits Issued Total Value
NEW BUSINESS 1 1 $0.00
NEW HOME PERMIT 1 1 $64,225.00
FENCE 1 1 $0.00
PARKING/DRIVEWAY 1 1 $4,488.00
Garage Sale Permit 14 14 $0.00
Totals 18 18 $68,713.00
Average 4 $13,742.60
MYGOV.US
Inspections Summary - By Region
Printed 12/12/17 at 3:41 PM