#page {
background: url(../images/body-bg.png) repeat-x 0 111px;
}
For instance, mon() gives the Civil month, cwday() gives the Commercial day of the week, and yday() gives the Ordinal day of the year. SELECT `test`.*
FROM `test`
LEFT JOIN
(SELECT `date`, `operator_id`
FROM `test`
GROUP BY `date`, `operator_id`
HAVING COUNT(*)>1) as `tbl`
ON
`test`.`date`=`tbl`.`date` AND
`test`.`operator_id` = `tbl`.`operator_id`
WHERE `tbl`.`date` IS NOT NULL