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

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

but phpMyAdmin returns : 243149 in the same table.

Any idea ?

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.

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