Lines Matching refs:where
835 + " FROM audio_genres_map WHERE genre_id = old._id;END");
838 + " BEGIN DELETE FROM audio_playlists_map WHERE playlist_id = old._id;"
843 + " FROM files WHERE media_type=4");
867 + "bookmark,album_artist FROM files WHERE media_type=2");
876 + " LEFT OUTER JOIN album_art ON audio.album_id=album_art.album_id WHERE is_music=1"
882 + " WHERE is_music=1 GROUP BY artist_key");
887 + "1 AS grouporder FROM artist_info WHERE (artist!='<unknown>')"
893 + " WHERE (album!='<unknown>')"
899 + "3 AS grouporder FROM searchhelpertitle WHERE (title != '')");
905 + "height FROM files WHERE media_type=1");
910 + " FROM files WHERE media_type=3");
913 + " WHERE album_id = old.album_id;END");
935 + " WHERE (is_alarm IS 1) OR (is_ringtone IS 1) OR (is_notification IS 1)");
984 db.execSQL("DELETE FROM log WHERE rowid IN" +
1018 * @param values the content values, where the bucked id name and bucket display name are updated.
1042 * @param values the content values, where the display name is updated.
1058 * @param values the content values, where taken time is updated.
1405 "audio_genres_map WHERE audio_id=?)");
1418 "audio_playlists_map WHERE audio_id=?)");
1589 "artists_albums_map WHERE artist_id=?)");
1722 String where = "";
1725 where = "match LIKE ? ESCAPE '\\'";
1727 where += " AND match LIKE ? ESCAPE '\\'";
1740 return qb.query(db, cols, where, wildcardWords, null, null, null, limit);
3081 public String where;
3086 String where = null;
3090 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_IMAGE;
3095 where = "_id = " + uri.getPathSegments().get(3);
3099 where = "_id=" + uri.getPathSegments().get(3);
3106 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_AUDIO;
3111 where = "_id=" + uri.getPathSegments().get(3);
3116 where = "audio_id=" + uri.getPathSegments().get(3);
3121 where = "audio_id=" + uri.getPathSegments().get(3) +
3127 where = "audio_id=" + uri.getPathSegments().get(3);
3132 where = "audio_id=" + uri.getPathSegments().get(3) +
3142 where = "_id=" + uri.getPathSegments().get(3);
3147 where = "genre_id=" + uri.getPathSegments().get(3);
3152 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_PLAYLIST;
3157 where = "_id=" + uri.getPathSegments().get(3);
3162 where = "playlist_id=" + uri.getPathSegments().get(3);
3167 where = "playlist_id=" + uri.getPathSegments().get(3) +
3173 where = "album_id=" + uri.getPathSegments().get(3);
3178 where = FileColumns.MEDIA_TYPE + "=" + FileColumns.MEDIA_TYPE_VIDEO;
3183 where = "_id=" + uri.getPathSegments().get(3);
3187 where = "_id=" + uri.getPathSegments().get(3);
3194 where = "_id=" + uri.getPathSegments().get(2);
3206 // Add in the user requested WHERE clause, if needed
3208 if (!TextUtils.isEmpty(where)) {
3209 out.where = where + " AND (" + userWhere + ")";
3211 out.where = userWhere;
3214 out.where = where;
3288 tableAndWhere.where, whereArgs,
3372 " WHERE playlist_id=? AND play_order>?",
3396 if (!TextUtils.isEmpty(tableAndWhere.where)) {
3397 tableAndWhere.where =
3398 "(" + tableAndWhere.where + ")" +
3400 " WHERE NOT (" + tableAndWhere.where + ")))";
3402 tableAndWhere.where = ID_NOT_PARENT_CLAUSE;
3411 count = db.delete("files", tableAndWhere.where, whereArgs);
3416 tableAndWhere.where, whereArgs);
3426 tableAndWhere.where, whereArgs, null, null, null);
3438 tableAndWhere.where, whereArgs);
3444 tableAndWhere.where, whereArgs);
3485 db.execSQL("delete from thumbnails where image_id not in (select _id from images)");
3486 db.execSQL("delete from videothumbnails where video_id not in (select _id from video)");
3510 null, null, null, null, null); // where clause/args, groupby, having, orderby
3533 Cursor c = db.rawQuery("select _data from thumbnails where image_id=" + id
3534 + " union all select _data from videothumbnails where video_id=" + id,
3542 db.execSQL("delete from thumbnails where image_id=" + id);
3543 db.execSQL("delete from videothumbnails where video_id=" + id);
3556 // ", where=" + userWhere + ", args=" + Arrays.toString(whereArgs) + " caller:" +
3582 tableAndWhere.where, whereArgs, null, null, null);
3634 tableAndWhere.where, whereArgs);
3651 " WHERE _data >= ?3 AND _data < ?4;",
3779 tableAndWhere.where, whereArgs);
3811 tableAndWhere.where, whereArgs);
3818 READY_FLAG_PROJECTION, tableAndWhere.where,
3855 tableAndWhere.where, whereArgs);
3890 " WHERE play_order=" + from_play_order +
3897 " WHERE play_order<=" + to_play_order +
3903 " WHERE play_order>=" + to_play_order +
3909 " WHERE play_order=-1 AND playlist_id=" + playlist);
5065 + " WHERE " + Audio.Playlists.Members.PLAYLIST_ID + "=?"
