| 1 | New Entry | 3 | 3 | 3404 | en | Ajman | 66 | 848 | 848-Masfout | 1 | 123 | Adnoc | - | - | M | M | M | 0 | 0 | 0 | Indian | | 2011-09-09 | 36.00 | 1 | 1 | 2011-09-09 13:09:00 | 2011-09-09 13:22:00 | 13:01-17:00 | 1 | 2 | -1 | 4 | 2 | 0 | 5 | 5 | -1 | 5 | 5 | 4 | 5 | 6 | -1 | 6 | 6 | 0 | 5 | 6 | -1 | 3 | 3 | 2 | 2 | 2 | 2 | -1 | | | | | | | he was inside came afterseeing me. | | | | | | I can't read it | | | | | | | | | | | | | | | | | 2011-09-09 |
select
service_detail.id,service_detail.serial_no,service_detail.interviewer_no as operator_code,service_detail.lang,service_detail.emirate,
service_detail.site_id,service_station_master.ss_no,service_station_master.ss_name,service_detail.service_id,service_detail.shopper_id,service_detail.co_name,service_detail.csa_name,service_detail.csa_number,service_detail.gender,service_detail.height,service_detail.built,service_detail.specs,service_detail.beard,service_detail.mustache,service_detail.eth_group,service_detail.eth_group_others,service_detail.date,service_detail.
amount,service_detail.veh,service_detail.staff,service_detail.time_in,service_detail.time_out,service_detail.time_of_visit,
service_detail.approach1,service_detail.approach2,service_detail.approach3,service_detail.approach4,service_detail.approach5,service_detail.
greeting1,service_detail.greeting2,service_detail.greeting3,service_detail.greeting4,service_detail.greeting5,service_detail.
appearance1,service_detail.appearance2,service_detail.appearance3,service_detail.appearance4,service_detail.
service1,service_detail.service2,service_detail.service3,service_detail.service4,service_detail.service5,service_detail.service6,service_detail.service7,service_detail.
rest1,service_detail.rest2,service_detail.rest3,service_detail.rest4,service_detail.rest5,service_detail.rest6,service_detail.rest7,service_detail.
approach1_com,service_detail.approach2_com,service_detail.approach3_com,service_detail.approach4_com,service_detail.approach5_com,service_detail.
greeting2_com,service_detail.greeting1_com,service_detail.greeting3_com,service_detail.greeting4_com,service_detail.greeting5_com,service_detail.
appearance1_com,service_detail.appearance2_com,service_detail.appearance3_com,service_detail.appearance4_com,service_detail.
service1_com,service_detail.service2_com,service_detail.service3_com,service_detail.service4_com,service_detail.service5_com,service_detail.service6_com,service_detail.service7_com,service_detail.
rest1_com,service_detail.rest2_com,service_detail.rest3_com,service_detail.rest4_com,service_detail.rest5_com,service_detail.rest6_com,service_detail.rest7_com,service_detail.comment as comment_com,service_detail. c_date
from service_detail_bakup_dec09 service_detail left join service_station_master on service_detail.site_id = service_station_master.ss_id
where service_id=1 and service_detail.site_id = 66 and service_detail.co_name = 'Adnoc' and service_detail.date = '2011-09-09' and service_detail.time_in = '2011-09-09 13:09:00' and service_detail.shopper_id = 123 and service_detail.service_id = 1