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)
Since the halfninja version of FFmpeg isn't able to use the concatenate functionality, I advice you to update the FFmpeg library to at least version 1.1. 

In my opinion you have two options:

* Try to compile a newer version of FFmpeg using one of these two [Compiling FFmpeg on Android](http://ffmpeg.org/trac/ffmpeg/wiki/How%20to%20compile%20FFmpeg%20for%20Android) guides. Then you possibly also need a newer revision of the Android NDK. This is the most simple solution.
* Or try to implement a newer version of FFmpeg in the halfninja libraries, which is harder, but then you can keep almost the same interface.