$query: SELECT * FROM dmp_product_cache WHERE (`lan_code` = :lan_code) AND (`prd_id` NOT IN ( 2527, 2528, 2529, 2530, 2531, 2532, 2533, 2537 )) AND (prd_id IN( SELECT object_id FROM dmp_group_relations WHERE context LIKE 'Product' AND lan_code = 1033 AND grp_id = :grp_id)) ORDER BY `pos` ASC$parameters: Array ( [:lan_code] => 1033 [:grp_id] => 1913-high-force-safety-air-guns )