-

select order_type, ordertype_old, slno, theme_color, phone, url, config_path, web_hosting, dealsin, prodDisp , host_name, domain_name, domain_basedir, catalog_inq_basket, catalog_search, catalog_prod_disp_num, domain_ftpuser, domain_ftppass, server_type, comp_name, username, username1, copyright_status, order_id, transfered_server, trust_code, cart_status, slno, content_copying_prevention, member_id, site_type, dynamic_catalog_footer_url, user_activation_date, temp_block, call_free, sms_service, google_map, misc_panel, modify_status, pi_vac_status, rmv_frm_google, YEAR(hp_catg_date) as hp_catg_date_year, upd_date as member_activation_dt, YEAR(expiry_date) as member_end_dt, search_options, mobile_website, biz_status, file_name, file_name_iyp, catalog_resolution, remote_ip, catalog_feedback, pi_theme, other_site_mem_id, member_catalog_shift_status, responsive_status, multiple_website_status, active_status, state, country from member where domain_name='http://www.thejobsindia.com' && copied_membership ='N' && active_status IN ('Y', 'E') && (biz_status='Y' || biz_status='R' || biz_status='S') and order_type IN ('10015','10016') order by active_status

[TEP STOP]