---rufinsql---

select GROUP_CONCAT(distinct eterms.value) as dir_categ_id_list, group_concat(distinct t.slug separator ',') as dir_categ_slug_list, GROUP_CONCAT(concat('https://www.afrothentik.com//wp-content/uploads/', pthumb.meta_value)) as attachment_list, concat('[', GROUP_CONCAT(CONCAT(' {"day":"', hours.day, '", "start":"',hours.start,'", "end":"',hours.end,'", "weight":"',hours.weight,'", "all_day":"',hours.all_day,'"}')), ']') hours_json, concat('[', GROUP_CONCAT(CONCAT(' {"phone":"', staff_entity.phone, '", "name":"', staff_entity.name,'"}')), ']') staffs_json, p.*, CONCAT(addr.city, ',', addr.province) as area, concat(addr.city, ',', addr.province, ' ', addr.zip ) as address_locality, '' as area_list, addr.address, GROUP_CONCAT(DISTINCT addr.address ORDER BY addr.weight ASC SEPARATOR '|') as address_list, addr.lat as latitude, addr.lng as longitude, phon.value as phone, u.user_email, post_logo.guid as logo, post_banner_1.guid as banner_1, post_favicon.guid as favicon, sbtitle.value as subtitle, smo_ig.value as instagram, smo_tiktok.value as tiktok, smo_fb.value as facebook, '' as youtube, '' as linkedin, greviews.value as google_reviews_link, reviews.meta_value as reviews_json, reviews_url.meta_value as reviews_link, menu.*, pm_store_json.meta_value as pm_store_json, COALESCE(pm_store_json.meta_value, menu.store_json) as store_json, IFNULL(NULLIF(menu.meta_title,''),meta.meta_title) as meta_title, IFNULL(NULLIF(menu.meta_keywords,''),meta.meta_keywords) as meta_keywords, IFNULL(NULLIF(menu.meta_description,''),meta.meta_description) as meta_description, p.ID AS entity_id, pm_clone_entity_id.meta_value as aftk_clone_entity_id from wp_posts p left join wp_postmeta pm_clone_entity_id on (pm_clone_entity_id.post_id = p.ID and pm_clone_entity_id.meta_key = 'aftk_clone_entity_id') left join z_html_menu menu on (menu.entity_id = p.ID or (pm_clone_entity_id.meta_value IS NOT NULL and menu.entity_id = pm_clone_entity_id.meta_value) ) LEFT JOIN z_html_meta meta ON meta.slug = menu.meta_slug left join wp_drts_entity_field_wp_image pimg on (pimg.entity_id = p.ID and pimg.field_name = 'directory_photos') left join wp_postmeta pthumb on (pthumb.post_id = pimg.attachment_id and pthumb.meta_key = '_wp_attached_file') left join wp_postmeta reviews on (reviews.post_id = p.ID and reviews.meta_key = '_afrotk_store_reviews') left join wp_postmeta reviews_url on (reviews_url.post_id = p.ID and reviews_url.meta_key = '_afrotk_store_reviews_url') left join wp_postmeta pm_store_json on (pm_store_json.post_id = p.ID and pm_store_json.meta_key = '_afrotk_listing_store_json') left join wp_drts_entity_field_entity_terms eterms on (eterms.entity_id = p.ID) left join wp_terms t on (t.term_id = eterms.value) left join wp_drts_entity_field_location_address addr on (addr.entity_id = p.ID) left join wp_drts_entity_field_phone phon on (phon.entity_id = p.ID) left join wp_posts post_logo on (post_logo.post_parent = p.ID and post_logo.post_title='logo') left join wp_posts post_banner_1 on (post_banner_1.post_parent = p.ID and post_banner_1.post_title='banner_1') left join wp_posts post_favicon on (post_favicon.post_parent = p.ID and post_favicon.post_title='favicon') left join wp_drts_entity_field_time hours on (hours.entity_id = p.ID) left join wp_drts_entity_field_string sbtitle on (sbtitle.entity_id = p.ID and sbtitle.bundle_name = 'businesses_dir_ltg' and sbtitle.field_name = 'field_sub_title') left join wp_drts_entity_field_string greviews on (greviews.entity_id = p.ID and greviews.bundle_name = 'businesses_dir_ltg' and greviews.field_name = 'field_google_reviews_link') left join wp_drts_entity_field_social_accounts smo_fb on (smo_fb.entity_id = p.ID and smo_fb.bundle_name = 'businesses_dir_ltg' and smo_fb.field_name = 'facebook') left join wp_drts_entity_field_social_accounts smo_ig on (smo_ig.entity_id = p.ID and smo_ig.bundle_name = 'businesses_dir_ltg' and smo_ig.field_name = 'instagram') left join wp_drts_entity_field_social_accounts smo_tiktok on (smo_tiktok.entity_id = p.ID and smo_tiktok.bundle_name = 'businesses_dir_ltg' and smo_tiktok.field_name = 'tiktok') left join z_crm_staff_entity staff_entity on staff_entity.entity_id = p.ID inner join wp_users u on u.ID = p.post_author where p.ID = 10554 and p.post_status = 'publish' group by p.ID ;
preloader
Abigael Hair Braiding is the #1 African Hair Braiding in ,
[aftk_mini_cart]
  • [aftk_mini_cart]
Book Now
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
!! Year End Sale !!
On all services of $200 & up Get $10 Discount
PHP Code Snippets Powered By : XYZScripts.com
[aftk_get_quote]