GX-Bug #44611 » Filter_Performance_Fix.patch
| src/system/classes/filter/FeatureSetSource.inc.php (revision ) | ||
|---|---|---|
| 838 | 838 |
$t_categories_where_part = $t_product_finder->get_categories_index_search_string(array($p_category_id)); |
| 839 | 839 |
|
| 840 | 840 |
$t_query = 'SELECT |
| 841 |
*
|
|
| 841 |
p.products_id
|
|
| 842 | 842 |
FROM |
| 843 | 843 |
categories_index AS ci |
| 844 | 844 |
LEFT JOIN products AS p ON (ci.products_id = p.products_id) |
| ... | ... | |
| 849 | 849 |
else |
| 850 | 850 |
{
|
| 851 | 851 |
$t_query = 'SELECT |
| 852 |
*
|
|
| 852 |
p.products_id
|
|
| 853 | 853 |
FROM |
| 854 | 854 |
products_to_categories AS ptc |
| 855 | 855 |
LEFT JOIN products AS p ON (ptc.products_id = p.products_id) |