# monster us impressions targeted TO Market-Segments ONLY
SELECT
    SUM(kvraw.impressions) AS Impressions,
    SUM(kvraw.impressions)*0.0085 / 1000 AS Rate
FROM kvrawreport kvraw
INNER JOIN page ON kvraw.pageId = page.id
WHERE
    kvraw.dt = '2012-08-01' AND
    page.remoteId LIKE 'us.monster.en%' AND
    (
        kvraw.partOfRequest LIKE '%__seg=%' OR
        kvraw.partOfRequest LIKE '%lid=%'
    )