Розы

DEBUG ROSE:
=== DEBUG ROSE START ===
current_path: /catalog/tsvety/rozy/orangevie
rose_type_mid: 303
rose_subcat_slug: orangevie
rozy_mid: 120
Found items with rose_type=303 in categories: cat 32 (1 items)
debug_found_cats count: 1
debug_found_cats is empty: NO
all_rozy_cats_list (from GetChildSectionCat): 47
Added category 32 to rozy_cats (found items there)
items_found_in_any_category: YES
debug_found_cats count: 1
debug_found_cats empty check: NO
old_cat_filter_sql: (`cat` = 0 OR c.cat=32 OR c.cat=33 OR c.cat=36 OR c.cat=37 OR c.cat=38 OR c.cat=39 OR c.cat=40 OR c.cat=41 OR c.cat=42 OR c.cat=43 OR c.cat=44 OR c.cat=45 OR c.cat=56)
cat_q (original): (`cat` = 0 OR cat=32 OR cat=33 OR cat=36 OR cat=37 OR cat=38 OR cat=39 OR cat=40 OR cat=41 OR cat=42 OR cat=43 OR cat=44 OR cat=45 OR cat=56)
SQL before replacement (first 500 chars):
SELECT
`c`.*,
(
SELECT SUM(`price` * `cc`.`count`)
FROM `au_cat_comp` AS `cc`
LEFT JOIN `au_storage` AS `stor` ON `stor`.`id` = `cc`.`ids`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_price`,
(
SELECT COUNT(*)
FROM `au_cat_comp` AS `cc`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_count`,
(
SELECT SUM(stor.price * cc.count)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id

Replaced using str_replace (found old_cat_filter_sql)
SQL after replacement (first 500 chars):
SELECT
`c`.*,
(
SELECT SUM(`price` * `cc`.`count`)
FROM `au_cat_comp` AS `cc`
LEFT JOIN `au_storage` AS `stor` ON `stor`.`id` = `cc`.`ids`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_price`,
(
SELECT COUNT(*)
FROM `au_cat_comp` AS `cc`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_count`,
(
SELECT SUM(stor.price * cc.count)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id

SUCCESS: cat_q_rozy found in SQL
WHERE found but ORDER BY/LIMIT not found
rose_type_mid_int: 303
rozy_cats (final): 32, 47
cat_q_rozy: (`c`.`cat` = 32 OR `c`.`cat`=47)
Full SQL query length: 2315
Full SQL query (last 2000 chars): WHERE `cc`.`id` = `c`.`id`
) AS `comp_count`,
(
SELECT SUM(stor.price * cc.count)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id
JOIN au_storage AS stor ON stor.id = cc.ids
WHERE c2.id_parent = c.id
GROUP BY c2.id
ORDER BY SUM(stor.price * cc.count) ASC
LIMIT 1
) AS comp_add_price,
(
SELECT COUNT(*)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id
WHERE c2.id_parent = c.id
GROUP BY c2.id
ORDER BY COUNT(*) ASC
LIMIT 1
) AS comp_add_count,
(
SELECT `pname`
FROM `au_cat_photo` AS `cp`
WHERE `cp`.`id` = `c`.`id` AND `cp`.`pfirst` = "y"
LIMIT 0,1
) AS `pname`,
(
SELECT `pname`
FROM `au_cat_photo` AS `cp`
WHERE `cp`.`id` = `c`.`id` AND `cp`.`psecond` = "y"
LIMIT 0,1
) AS `s_pname`
,0 AS sales_units
FROM `au_catalog` AS `c`
LEFT JOIN `au_cat_color` AS `c_col` USING(color)
LEFT JOIN `au_category` AS `cc` USING(cat)
LEFT JOIN `au_cat_flowers` AS c_flowers USING(flowers)
LEFT JOIN `au_cat_country` AS c_country USING(country)
LEFT JOIN `au_cat_design` AS c_design USING(design)
LEFT JOIN `au_cat_rose_type` AS c_rose_type USING(rose_type)
LEFT JOIN `au_cat_reason` AS c_reason USING(reason)
LEFT JOIN `au_cat_whom` AS c_whom USING(whom)
LEFT JOIN `au_cat_color` AS i_color ON FIND_IN_SET("orangevie", i_color.title)LEFT JOIN `au_cat_flowers` AS i_flowers ON FIND_IN_SET("rozy", i_flowers.title) WHERE (`c`.`cat` = 32 OR `c`.`cat`=47) AND c.id_parent = 0 AND `c`.`sshow` = "y"
AND
(
SELECT SUM(price * cc.count)
FROM `au_cat_comp` AS `cc`
LEFT JOIN `au_storage` AS `stor` ON stor.id = cc.ids
WHERE cc.id = c.id
) > 0 AND `cat` <> 42 AND (`c`.`rose_type` IS NOT NULL AND `c`.`rose_type` != "" AND FIND_IN_SET(303, `c`.`rose_type`) > 0)
Simple test query (basic filters only) returned: 0 records
Test query executed successfully
Test query returned 1 records
First record: ID=6764, cat=32, rose_type=303,182
SQL query (first 1000 chars):
SELECT
`c`.*,
(
SELECT SUM(`price` * `cc`.`count`)
FROM `au_cat_comp` AS `cc`
LEFT JOIN `au_storage` AS `stor` ON `stor`.`id` = `cc`.`ids`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_price`,
(
SELECT COUNT(*)
FROM `au_cat_comp` AS `cc`
WHERE `cc`.`id` = `c`.`id`
) AS `comp_count`,
(
SELECT SUM(stor.price * cc.count)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id
JOIN au_storage AS stor ON stor.id = cc.ids
WHERE c2.id_parent = c.id
GROUP BY c2.id
ORDER BY SUM(stor.price * cc.count) ASC
LIMIT 1
) AS comp_add_price,
(
SELECT COUNT(*)
FROM au_cat_comp AS cc
JOIN au_catalog AS c2 ON c2.id = cc.id
WHERE c2.id_parent = c.id
GROUP BY c2.id
ORDER BY COUNT(*) ASC
LIMIT 1
) AS comp_add_count,
(
SELECT `pname`
FROM `au_cat_photo` AS
=== DEBUG ROSE END ===