Query Call: SELECT p.pid, p.model FROM tb_product p LEFT JOIN tb_product_status pst ON p.pid=pst.pid LEFT JOIN tb_product_filters pf ON p.pid=pf.pid WHERE p.ctid=1 AND p.cid=99 AND pst.status=1 AND pst.regid=1 AND pf.filter='compatibility' ORDER BY p.weight desc 4 Rows Affected. Total query time: 0.0007469654083252 mysqli_result Object ( [current_field] => 0 [field_count] => 2 [lengths] => [num_rows] => 4 [type] => 0 )