Question: I want to have a output count as 2 for the user\_mail logged as test1@gmail.com for a query like this,

```
SELECT Count(user_refemai) from Table_users where userref_mail = user_mail

```

but, I'm getting the output as 0! What am I doing wrong?

My table\_users looks like:

```
user_id         user_mail               user_refemail  
1               test1@gmail.com         NULL    
2               test2@gmail.com         test1@gmail.com  
3               test3@gmail.com         test1@gmail.com

```

Answer: 
The answer provided by LordNeckbeard is really the way to go.

[How to concatenate flv file into one?](https://stackoverflow.com/questions/14829819/how-to-concatenate-flv-file-into-one)

Working with your restrictions

* no `-f concat`
* no `-c`
* no `-bsf`

```sh
ffmpeg -i q.mp4 -vcodec copy -acodec copy -vbsf h264_mp4toannexb q.ts
ffmpeg -i r.mp4 -vcodec copy -acodec copy -vbsf h264_mp4toannexb r.ts
ffmpeg -i 'concat:q.ts|r.ts' -vcodec copy -acodec copy -absf aac_adtstoasc qr.mp4

```

[Joining H264 \*without\* re-encoding](https://superuser.com/q/133413/joining-h264-without-re-encoding)
ffmpeg concat demuxer has been added to FFMPEG Fire Flower (Version 1.1). Use FFmpeg fire flower or Magic to get this feature. Once you build ffmpeg, use the demuxer. Which is explained in this <http://ffmpeg.org/trac/ffmpeg/wiki/How%20to%20concatenate%20(join,%20merge)%20media%20files>
site as concat demuxer.