Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- mysql> select * from australian_public_number_directory_information where number = '61286654543'\G
- *************************** 1. row ***************************
- number: 61286654543
- service_status_date: NULL
- service_status: D
- customer_name_1:
- customer_name_2:
- long_name:
- customer_title:
- finding_name_1:
- finding_name_2:
- finding_title:
- service_building_type:
- service_building_1st_number:
- service_building_1st_suffix:
- service_building_2nd_number:
- service_building_2nd_suffix:
- service_building_floor_type:
- service_building_floor_number:
- service_building_floor_number_suffix:
- service_building_property:
- service_building_location:
- service_street_house_number_1:
- service_street_house_number_1_suffix:
- service_street_house_number_2:
- service_street_house_number_2_suffix:
- service_street_name_1:
- service_street_type_1:
- service_street_suffix_1:
- service_street_name_2:
- service_street_type_2:
- service_street_suffix_2:
- service_address_locality: NULL
- service_address_post_code: NULL
- service_address_province_id: NULL
- service_address_country_id: NULL
- directory_building_type:
- directory_building_1st_number:
- directory_building_1st_suffix:
- directory_building_2nd_number:
- directory_building_2nd_suffix:
- directory_building_floor_type:
- directory_building_floor_number:
- directory_building_floor_number_suffix:
- directory_building_property:
- directory_building_location:
- directory_street_house_number_1:
- directory_street_house_number_1_suffix:
- directory_street_house_number_2:
- directory_street_house_number_2_suffix:
- directory_street_name_1:
- directory_street_type_1:
- directory_street_suffix_1:
- directory_street_name_2:
- directory_street_type_2:
- directory_street_suffix_2:
- directory_address_locality: NULL
- directory_address_post_code: NULL
- directory_address_province_id: NULL
- directory_address_country_id: NULL
- customer_contact_name_1:
- customer_contact_name_2:
- customer_contact_number:
- actor_type_id: 1
- type_of_service_id: Fixed
- latest_synchronize_time: NULL
- last_updated: 2017-07-25 17:22:02
- current_details_automatically_populated: 0
- valid: 0
- state_id: 2
- carriage_service_provider_code: NULL
- actor_id: NULL
- last_sent: NULL
- list_code_id: UL
- sync_state_id: 2
- sync_error:
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement