SELECT
modules.*,
public_module_page_map.*,
public_pages.pageName AS pageName,
public_pages.defPageURLParams AS defPageURLParams,
public_module_page_map.priKeyID AS priKeyID,
IF(CHAR_LENGTH(public_module_page_map.primaryPmpmAddEditID) > 0, public_module_page_map.primaryPmpmAddEditID,modules.primaryPmpmAddEditID) AS primaryPmpmAddEditID
FROM modules
LEFT JOIN public_module_page_map
ON (modules.priKeyID = public_module_page_map.moduleID)
LEFT JOIN public_pages
ON (
public_module_page_map.pageID = public_pages.priKeyID OR
public_module_page_map.pageID = "shortcode"
)
WHERE (FIND_IN_SET('-6,-5,2560,2561' , public_module_page_map.pageID)
OR public_module_page_map.pageID IN (-6,-5,2560,2561)
OR (
(
public_pages.pageCode LIKE concat('%