$query->count() : Which one is right?

Need Help
1

public function inventaire() {
$query = $this->find()
->all()
;
return $query->count();
}
returns 289104 items

but phpMyAdmin returns : 243149 in the same table.

Any idea ?

2

Turn on SQL query logging, and use that to look at the exact SQL generated by the ORM for this query. This will be user error, somewhere along the line.

3

OK
thank you
(what a hassle those 20 characters :slight_smile: )