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_midlothian_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-10-18' AND p.permit_issue_date <= '2017-11-17 23:59:59' AND pt.type_id = '4' AND p.permit_type_code != '' AND ( 1 )  
157430
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_midlothian_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-10-18' AND p.permit_issue_date <= '2017-11-17 23:59:59' AND pt.type_id = '13' AND p.permit_type_code != '' AND ( 1 )  
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_midlothian_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-10-18' AND p.permit_issue_date <= '2017-11-17 23:59:59' AND pt.type_id = '10' AND p.permit_type_code != '' AND ( 1 )  
0
SELECT * FROM tbl_archive_permit AS tap WHERE 1 AND tap.permit_issue_date != '0000-00-00' AND tap.permit_issue_date >= '2017-10-18' AND tap.permit_issue_date <= '2017-11-17 23:59:59' AND tap.permit_type_id = '15' AND ( 1 )  
0
City of Midlothian's
Growth Profile Report
10/18/17 to 11/17/17
  Permit Applications Permits Issued Projects Completed CO's Issued Total SF Avg. SF Total Value Avg. Value
NEW SINGLE FAMILY DETACHED 59 59 0 53 157,430.00 2,668.31 $10,963,724.00 $185,825.83
COMMERCIAL ADDITION / ALTERATION 1 1 0 0 0.00 0.00 $30,000.00 $30,000.00
NEW COMMERCIAL BUILDING 2 2 0 1 0.00 0.00 $10,425,828.00 $5,212,914.00
CERTIFICATE OF OCCUPANCY 2 2 1 2 0.00 0.00 $0.00 $0.00
Totals 64 64 1 56 157,430.00 2,539.19 $21,419,552.00 $345,476.65
Average 16 0 14 39,357.50 634.80 $5,354,888.00 $86,369.16
MYGOV.US
Growth Profile Report
Printed 11/17/17 at 5:11 PM