Regions of Italy
Database Error; SQL: SELECT
DISTINCT
`t`.*
FROM `wp_posts` AS `t`
LEFT JOIN `wp_postmeta` AS `macro_region` ON
`macro_region`.`meta_key` = ‘macro_region’
AND `macro_region`.`post_id` = `t`.`ID`
LEFT JOIN `wp_postmeta` AS `macro_region_meta_value` ON
`macro_region_meta_value`.`meta_key` = ‘meta_value’
AND `macro_region_meta_value`.`post_id` = `macro_region`.`post_id`
LEFT JOIN `wp_icl_translations` AS `wpml_translations`
ON `wpml_translations`.`element_id` = `t`.`ID`
AND `wpml_translations`.`element_type` = ‘post_pod_origin’
AND `wpml_translations`.`language_code` = ‘en’
LEFT JOIN `wp_icl_languages` AS `wpml_languages`
ON `wpml_languages`.`code` = `wpml_translations`.`language_code` AND `wpml_languages`.`active` = 1
WHERE ( ( post_parent<>0 ) AND ( `t`.`post_type` = “pod_origin” ) AND ( `wpml_languages`.`code` IS NOT NULL ) AND ( `t`.`post_status` IN ( “publish” ) ) )
ORDER BY `macro_region`.`meta_value` ASC, `t`.`menu_order`, `t`.`post_title`, `t`.`post_date`; Response: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ‘;>0 ) AND ( `t`.`post_type` = “pod_origin” ) AND ( `wpml_languages`.`code` IS’ at line 26

