Re: Query needs to be optimized

[Rick James]

To assist in analyzing slow SELECTs, please provide
* SHOW CREATE TABLE tbl\G -- engine, indexes
* SHOW TABLE STATUS LIKE 'tbl'\G -- sizes
* EXPLAIN SELECT ...\G -- clues of inefficiencies
* SHOW VARIABLES LIKE '%buffer%'; -- cache size
and surround them with [ code ] and [ / code ]

Do you really need LEFT JOIN, not just JOIN?

AND p.timestamp >='2010-02-02' AND p.timestamp<='2010-06-02' -- Is that a TIMESTAMP or a DATE? If a TIMESTAMP, do you really want midnight at both ends?