[SHOW COLUMNS FROM `pt_products` LIKE 'param_search'][][SHOW TABLES LIKE ''][][SHOW COLUMNS FROM `pt_products` LIKE 'param_search'][][SELECT COUNT(*) AS resultcount FROM (SELECT search_name FROM `pt_products` WHERE param1_value LIKE '%' OR param2_value LIKE '%' OR param3_value LIKE '%' OR param4_value LIKE '%' OR param5_value LIKE '%' GROUP BY search_name LIMIT 501) AS search_count_cap][][SELECT * FROM (SELECT id,COUNT(id) AS numMerchants,MIN(price) as minPrice FROM `pt_products` WHERE param1_value LIKE '%' OR param2_value LIKE '%' OR param3_value LIKE '%' OR param4_value LIKE '%' OR param5_value LIKE '%' GROUP BY search_name ORDER BY minPrice DESC LIMIT 500) AS search_results_capped LIMIT 0,40][]