JeF's Extra Queries (for interface and/or plugin)

How to make Movienizer support new sites. Customize Movienizer.
yobogi92
Passerby
Posts: 5
Joined: Wed Aug 15, 2012 7:28 pm

Re: JeF's Extra Queries (for interface and/or plugin)

Post by yobogi92 » Thu Aug 16, 2012 9:06 am

thanks a lot JeF.

would it be possible to put them as a list to a custom field, seperated by a comma maybe?

helm
Extra
Posts: 23
Joined: Sat Oct 30, 2010 10:49 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by helm » Sun Sep 23, 2012 11:09 am

Hi, I recently added Location to all my movies. But I like to know if I missed a movie or more. So I've been unsuccessfully trying to write a query that would list all movies without location. Can anybody help me with this?

Thanks in advance

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Sun Sep 23, 2012 1:06 pm

helm wrote:Hi, I recently added Location to all my movies. But I like to know if I missed a movie or more. So I've been unsuccessfully trying to write a query that would list all movies without location. Can anybody help me with this?
Following query should do it :

Code: Select all

M0139=select code, title, year from movies where code in (select distinct movie from editions where code not in (select edition from loans)) and in_collection = 1 order by title_sort
M0139D=Movies having one or more editions without a location
;)
JeF

helm
Extra
Posts: 23
Joined: Sat Oct 30, 2010 10:49 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by helm » Sun Sep 23, 2012 1:37 pm

Thanks JeF, that did the trick :)

User avatar
xbox80
Superstar
Posts: 501
Joined: Tue Sep 15, 2009 8:50 am
Location: Italy-Russian

Re: JeF's Extra Queries (for interface and/or plugin)

Post by xbox80 » Wed Sep 18, 2013 5:49 pm

I ask for help to the teacher Jef

Which and the sql command for these episodes? :?: :?:
I put this but it gives me error :roll: :roll:

http://www.imdb.com/title/tt0424587/
select episodes.title from episodes, movies where movies.code = episodes.movie and movies.title = '...e le stelle stanno a guardare '

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Wed Sep 18, 2013 7:22 pm

xbox80 wrote:I put this but it gives me error
Query seems Ok.
What is the text of the error message ?

User avatar
xbox80
Superstar
Posts: 501
Joined: Tue Sep 15, 2009 8:50 am
Location: Italy-Russian

Re: JeF's Extra Queries (for interface and/or plugin)

Post by xbox80 » Wed Sep 18, 2013 7:30 pm

JeF wrote:
xbox80 wrote:I put this but it gives me error
Query seems Ok.
What is the text of the error message ?
This :?



Image


Image

User avatar
JeF
Black Belt Squirrel
Posts: 1175
Joined: Fri Feb 20, 2009 3:34 pm
Location: France

Re: JeF's Extra Queries (for interface and/or plugin)

Post by JeF » Wed Sep 18, 2013 8:38 pm

This is not an error message.
This is an informative message just telling there's no episode for that series in database.
Please go to the edit window of that movie and check the 'seasons' tab : you should see no episode at all.
That's why the query didn't return any result.

User avatar
xbox80
Superstar
Posts: 501
Joined: Tue Sep 15, 2009 8:50 am
Location: Italy-Russian

Re: JeF's Extra Queries (for interface and/or plugin)

Post by xbox80 » Wed Sep 18, 2013 8:55 pm

JeF wrote:This is not an error message.
This is an informative message just telling there's no episode for that series in database.
Please go to the edit window of that movie and check the 'seasons' tab : you should see no episode at all.
That's why the query didn't return any result.

Instead there are the episodes, I've downloaded some time ago and now I want to upgrade them

look here :roll:

http://www.imdb.com/title/tt0424587/epi ... t_eps_sn_1

iosefra
Supporting actor
Posts: 88
Joined: Wed Jan 28, 2009 9:07 am

Re: JeF's Extra Queries (for interface and/or plugin)

Post by iosefra » Sun Jul 06, 2014 1:02 pm

Hi
I need queue to merge two duplicate movies/books if they have the same name. If there no data on the item which code is bigger then second one, than copy data from first to second.
something like that:

FROM movies t1, movies t2
WHERE (t1.title = t2.title AND t1.code<t2.code)
for every field where t2.* <> NULL or t2.*<>0 set t2.*=t1.*

Can anyone help?

Post Reply