API tools faq
paste
Guest User

Query S

a guest
Mar 13th, 2018
206
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 10.19 KB | None | 0 0
raw download clone embed print report
  1. Quiz Users (Total for selected date range: 160,658)
  2. Time taken:51998 ms
  3. Query:
  4. SET NAMES 'utf8'
  5. SELECT DISTINCT btq_user.lead_from as lead_from FROM `btq_user` WHERE btq_user.LEAD_FROM IS NOT NULL
  6.  
  7. SELECT btq_call_status.id as id, btq_call_status.title as title, btq_call_status.color as color, btq_call_status.label_title_color as label_color FROM `btq_call_status`
  8.  
  9. SELECT COUNT(*) FROM (SELECT btq_user.id as id, btq_user.drid as drid, btq_user.name as name, btq_user.email as email, btq_user.active as active, btq_user.lead_from as lead_from, btq_user.source as source, btq_user.http_referer as http_referer, btq_user.sms_status as sms_status, btq_user.telefon as telefon, btq_user.datain as datain, btq_user.kall as kall, btq_user.ip_address as ip_address, count(btq_user_track_blog_video.counter) as total_video_viewed, btq_doctors.id as dr_id, btq_doctors.drname as dr_name, btq_doctors.drphone as dr_phone, btq_doctors.initials as dr_initials, btq_doctors.drmail as dr_mail, event_data.btq_user_id as event_user_id, count(if(event_data.event_parent_id=2, event_data.event_parent_id, null)) as kms_total_video_viewed, count(if(event_data.event_parent_id=1, event_data.event_parent_id, null)) as kms_total_blog_viewed, state.pres as pres, state.state as state, btq_user_sales_choice.type as choice_type, btq_user_sales_choice.opt_value as choice_value, btq_user_sales_choice.opt_text as choice_text, btq_user.pfu_customer_id as pfu_customer_id, lead_schedule.id as schedule_id, lead_schedule.created_at as schedule_date FROM `btq_user` LEFT JOIN state ON (btq_user.STATE_ID=state.ID) LEFT JOIN btq_user_sales_choice ON (btq_user.BTQ_USER_SALES_CHOICE_ID=btq_user_sales_choice.ID) LEFT JOIN lead_schedule ON (btq_user.ID=lead_schedule.LEAD_ID) LEFT JOIN btq_doctors ON (btq_user.DRID=btq_doctors.ID) LEFT JOIN btq_user_track_blog_video ON (btq_user.ID=btq_user_track_blog_video.USER_ID) LEFT JOIN event_data ON (btq_user.ID=event_data.BTQ_USER_ID) WHERE btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') GROUP BY btq_user.EMAIL) AS propelmatch4cnt
  10.  
  11.  
  12. SELECT btq_user.id as id, btq_user.drid as drid, btq_user.name as name, btq_user.email as email, btq_user.active as active, btq_user.lead_from as lead_from, btq_user.source as source, btq_user.http_referer as http_referer, btq_user.sms_status as sms_status, btq_user.telefon as telefon, btq_user.datain as datain, btq_user.kall as kall, btq_user.ip_address as ip_address, count(btq_user_track_blog_video.counter) as total_video_viewed, btq_doctors.id as dr_id, btq_doctors.drname as dr_name, btq_doctors.drphone as dr_phone, btq_doctors.initials as dr_initials, btq_doctors.drmail as dr_mail, event_data.btq_user_id as event_user_id, count(if(event_data.event_parent_id=2, event_data.event_parent_id, null)) as kms_total_video_viewed, count(if(event_data.event_parent_id=1, event_data.event_parent_id, null)) as kms_total_blog_viewed, state.pres as pres, state.state as state, btq_user_sales_choice.type as choice_type, btq_user_sales_choice.opt_value as choice_value, btq_user_sales_choice.opt_text as choice_text, btq_user.pfu_customer_id as pfu_customer_id, lead_schedule.id as schedule_id, lead_schedule.created_at as schedule_date FROM `btq_user` LEFT JOIN state ON (btq_user.STATE_ID=state.ID) LEFT JOIN btq_user_sales_choice ON (btq_user.BTQ_USER_SALES_CHOICE_ID=btq_user_sales_choice.ID) LEFT JOIN lead_schedule ON (btq_user.ID=lead_schedule.LEAD_ID) LEFT JOIN btq_doctors ON (btq_user.DRID=btq_doctors.ID) LEFT JOIN btq_user_track_blog_video ON (btq_user.ID=btq_user_track_blog_video.USER_ID) LEFT JOIN event_data ON (btq_user.ID=event_data.BTQ_USER_ID) WHERE btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') GROUP BY btq_user.EMAIL ORDER BY btq_user.DATAIN DESC LIMIT 20
  13.  
  14. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='jrmundorf@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  15.  
  16.  
  17. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='cafecaron@hotmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  18.  
  19. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='ivaylo1984@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  20.  
  21. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='mphuze@comcast.net' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  22.  
  23. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='cleaver' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  24.  
  25. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='winchser' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  26.  
  27. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='mustafagb18@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  28. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='johnson.jasmyn4@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  29.  
  30. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='ru4nyy2@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  31.  
  32. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='kenright78@hotmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  33.  
  34. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='julie.storm@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  35.  
  36. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='plj2575@gmail.gom' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  37.  
  38. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='ect810@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  39.  
  40. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='mikerhondawhite1987@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  41.  
  42. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='michellejpaul66@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  43.  
  44. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='astrid.mary@yahoo.co.nz' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  45.  
  46. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='melinbakar@hotmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  47.  
  48. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='dswaltrip@aol.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  49.  
  50. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='russ.robison@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
  51.  
  52. SELECT IF( COUNT(btq_user.id) > 1, GROUP_CONCAT(CONCAT(btq_user.id),'~',CONCAT(btq_user.datain)) , null) as quizes FROM `btq_user` WHERE btq_user.EMAIL='jrabbit0159@gmail.com' AND btq_user.IS_DUMMY_DETAIL<>1 AND (btq_user.DATAIN>='2008-03-11 00:00:00' AND btq_user.DATAIN<='2018-03-13 23:59:59') ORDER BY btq_user.DATAIN DESC
Add Comment
Please, Sign In to add comment
Public Pastes
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!