select count(*) from objects datemodelpublic, eav_int serialno, objects model, eav_objects note where datemodelpublic.object_id=serialno.object_id and datemodelpublic.object_class=127 and datemodelpublic.object_name=model.object_id and datemodelpublic.object_description < '20060501' and datemodelpublic.object_description > '20050431' and note.value_=93241 and note.attribute_id=426 and note.object_id=datemodelpublic.object_id order by datemodelpublic.object_description