File: /home/ime13678/public_html/library/filters/product_filters.php
Line: 61
string(721) "SELECT records.*, pages.Page_Name, pages.Page_Name_Print, pages.Page_ID, count(records.Rec_ID) as Filter_Count
FROM records,related_records,pages
WHERE
records.Rec_ID=related_records.Related_Rec_ID
AND Page_ID=Rec_Page_ID
AND related_records.Rec_Table='1'
AND records.Rec_Page_ID IN (SELECT records.Rec_Page_ID from pages WHERE Page_Section='product_filters' )
AND (
related_records.Rec_ID IN (SELECT Rec_ID FROM records WHERE Rec_Page_ID='348')
OR related_records.Rec_ID IN (SELECT Related_Rec_ID FROM related_pages WHERE Related_Page_ID = 348)
)
GROUP BY records.Rec_ID
ORDER BY Page_Order Asc, records.Rec_Order ASC"