ivankatliarchuk

SELECT product.model, count(pc.model) FROM product
LEFT OUTER JOIN pc
ON product.model = pc.model
GROUP BY product.model;


SELECT model FROM product
WHERE model NOT IN (
SELECT model FROM pc);

ivankatliarchuk

SELECT * FROM asterisk.cdr main
WHERE DATE(main.calldate) BETWEEN '2015-07-01' AND '2015-07-30'
AND main.record_id IN (
  SELECT item.record_id FROM asterisk.cdr item
  WHERE item.calldate IS NOT NULL
        AND HOUR(item.calldate) BETWEEN '8:00:00' AND '21:00:00'
);