Message: | MySQL Query fail:
SELECT
A.`id_trow`, A.`link_type`, A.`child_id`, A.`dad_id`, A.`if_flex`,
B.`item_class`, B.`item_status`, B.`view_child`, B.`item_type`, B.`design_modul`,
B.`item_name`, B.`item_makat`, B.`item_subject`, B.`item_if_stock`,B.`shop_status`,B.`event_start`,B.`event_end`,
C.`design_type`, C.`link_add`, C.`furl_pg`
FROM `tree_general` AS A
LEFT JOIN `items_list` AS B
ON (
A.`child_id`=B.`item_id`
)
LEFT JOIN `items_setting_pg` AS C
ON (
A.`child_id`=C.`item_id`
)
WHERE A.`CompID`='2' AND A.`dad_id`='72' AND A.`child_id`>'0' AND A.`date_out` IS NULL
AND ( B.`event_start` IS NULL OR ( B.`event_start`<=NOW() AND B.`event_end`>=NOW() ))
ORDER BY A.`child_sort` ASC; |