Parish Resources

splitPageResults Object ( [sql_query] => SELECT m.*, pd.*, p.*, IF(s.status, s.specials_new_products_price, NULL) AS specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) AS base_price, p.products_quantity AS in_stock, IF(s.status, 1, 0) AS is_special, IF(s.status, s.expires_date, NULL) AS special_expiration, IF(COALESCE(a.attribute_count, 0) > 0, 1, 0) AS has_attributes FROM products p LEFT JOIN specials s ON p.products_id = s.products_id INNER JOIN products_description pd ON p.products_id = pd.products_id LEFT JOIN (SELECT products_id, COUNT(*) AS attribute_count FROM products_attributes GROUP BY products_id) a ON p.products_id = a.products_id INNER JOIN manufacturers m ON p.manufacturers_id = m.manufacturers_id INNER JOIN products_to_categories p2c ON p.products_id = p2c.products_id WHERE p.products_status = 1 AND m.manufacturers_id = 5 AND pd.language_id = 1 AND p2c.categories_id = 1416 ORDER BY pd.products_name LIMIT 0, 500 [number_of_rows] => 9 [current_page_number:protected] => 1 [number_of_pages:protected] => 1 [number_of_rows_per_page:protected] => 500 [page_name:protected] => page )