string(5) "hello"
string(2) "db"
string(229) "SELECT p.id AS product_id, (SELECT GROUP_CONCAT(tag_id) FROM products_tags_association WHERE product_id = p.id) AS tags FROM products p WHERE p.online="1" AND p.deleted=0 AND p.type="2" AND p.regonlyp=0 HAVING tags IS NOT NULL;"
string(5) "hello"
string(2) "db"
string(546) "SELECT pta.product_id, GROUP_CONCAT(pta.tag_id) AS tags FROM products p INNER JOIN (
SELECT pta_f.product_id
FROM products_tags_association pta_f
WHERE pta_f.tag_id IN ("1")
GROUP BY pta_f.product_id
HAVING MAX(pta_f.tag_id IN ("1")) = 1
) AS matched_tags ON p.id = matched_tags.product_id STRAIGHT_JOIN products_tags_association pta ON pta.product_id = p.id WHERE p.online="1" AND p.deleted=0 AND p.type="2" AND p.regonlyp=0 GROUP BY pta.product_id;"
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 20480 bytes) in /home/creoconcept/www/plat04/confs.php on line 1504