SELECT avuqrcodeFROM user uJOIN appointment_view av ON uid = avuser_idJOIN vaccinum v ON avvaccinum_id = vidJOIN vaccinum_type vt ON vtype = vtidWHERE uqrcode = 1 and vtstatus = 1 and user_name LIKE

SELECT av., u.qrcode, COUNT() as record_count FROM user u JOIN appointment_view av ON u.id = av.user_id JOIN vaccinum v ON av.vaccinum_id = v.id JOIN vaccinum_type vt ON v.type = vt.id WHERE u.qrcode = 1 AND vt.status = 1 AND user_name LIKE '%%' GROUP BY av.id ORDER BY av.status ASC LIMIT 0,10;