Hi.
I’m testing these two query
SELECT `np_petition`.`id`, count(np_sign.id) AS `total_sign`
FROM `np_petition`
INNER JOIN `np_sign` ON np_petition.id = np_sign.petition_id
WHERE (np_petition.status = 'approved' or np_petition.status = 'confirmed' or np_petition.status = 'stopped')
GROUP BY `np_petition`.`id`
ORDER BY `np_petition`.`registration_datetime` desc
SELECT `np_petition`.`id`, count(np_sign.id) AS `total_sign`
FROM `np_petition`
INNER JOIN `np_sign` ON np_petition.id = np_sign.petition_id
WHERE np_petition.status IN ('approved' ,'confirmed' , 'stopped')
GROUP BY `np_petition`.`id`
ORDER BY `np_petition`.`registration_datetime` desc
The first took 8.3 secs
the second 11.5
but IN should be better of multiple where ?
Bye
Be patience