search

TWiStErRob / net.twisterrob.cinema

Cineworld Unlimited planner web-app
https://cinema.twisterrob.net/planner
2 stars 0 forks source link

Duplicate Films created #16

Open TWiStErRob opened 10 years ago

TWiStErRob commented 10 years ago 
match (f:Film)
with f.title as title, collect(f) as films
where length(films) > 1
return title, length(films)
order by length(films) desc
title length(films)
2D - Cloudy With A Chance Of Meatballs 2 7
Cloudy With A Chance Of Meatballs 6
2D - Free Birds 5
Moshi Monsters 4
2D - Captain Phillips 4
2D - The Smurfs 2 4
The Best Man Holiday 4
2D - The Croods 4
2D - The Hobbit: An Unexpected Journey 4
To The Arctic 4
Anchorman 2 4
... more movies ... 3
... more movies ... 2
TWiStErRob commented 10 years ago 
x=({"table":{"_response":{"columns":["f"],"data":[{"row":[{"edi":62188,"_created":"2013-12-05T00:05:14.300Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-12T04:00:37.052Z","_deleted":"2014-01-13T04:01:14.853Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"poster":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":25,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"141","labels":["Film"],"properties":{"edi":62188,"_created":"2013-12-05T00:05:14.300Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-12T04:00:37.052Z","_deleted":"2014-01-13T04:01:14.853Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"poster":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":25,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-01-14T04:01:24.186Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-19T04:03:07.981Z","_deleted":"2014-01-20T04:04:49.884Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":20,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"268","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-14T04:01:24.186Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-19T04:03:07.981Z","_deleted":"2014-01-20T04:04:49.884Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":20,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-01-21T04:02:59.864Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-26T04:00:25.613Z","_deleted":"2014-01-27T04:01:55.707Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":27,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"303","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-21T04:02:59.864Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-26T04:00:25.613Z","_deleted":"2014-01-27T04:01:55.707Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":27,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-01-28T04:00:36.976Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-02T04:01:38.668Z","_deleted":"2014-02-03T04:02:07.732Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":43,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"334","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-28T04:00:36.976Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-02T04:01:38.668Z","_deleted":"2014-02-03T04:02:07.732Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":43,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-02-04T04:02:24.512Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-09T04:01:05.390Z","_deleted":"2014-02-10T04:04:25.763Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":40,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"361","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-04T04:02:24.512Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-09T04:01:05.390Z","_deleted":"2014-02-10T04:04:25.763Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":40,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-02-11T04:01:00.436Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-20T04:08:35.745Z","_deleted":"2014-02-21T04:00:54.137Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"386","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-11T04:01:00.436Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-20T04:08:35.745Z","_deleted":"2014-02-21T04:00:54.137Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}},{"row":[{"edi":62188,"_created":"2014-02-22T04:01:34.157Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-23T04:00:35.419Z","_deleted":"2014-02-24T04:01:10.415Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}],"graph":{"nodes":[{"id":"428","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-22T04:01:34.157Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-23T04:00:35.419Z","_deleted":"2014-02-24T04:01:10.415Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"relationships":[]}}],"stats":{"contains_updates":false,"nodes_created":0,"nodes_deleted":0,"properties_set":0,"relationships_created":0,"relationship_deleted":0,"labels_added":0,"labels_removed":0,"indexes_added":0,"indexes_removed":0,"constraints_added":0,"constraints_removed":0}},"nodes":[{"id":"141","labels":["Film"],"properties":{"edi":62188,"_created":"2013-12-05T00:05:14.300Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-12T04:00:37.052Z","_deleted":"2014-01-13T04:01:14.853Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"poster":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":25,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"268","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-14T04:01:24.186Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-19T04:03:07.981Z","_deleted":"2014-01-20T04:04:49.884Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":20,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"303","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-21T04:02:59.864Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-26T04:00:25.613Z","_deleted":"2014-01-27T04:01:55.707Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":27,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"334","labels":["Film"],"properties":{"edi":62188,"_created":"2014-01-28T04:00:36.976Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-02T04:01:38.668Z","_deleted":"2014-02-03T04:02:07.732Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":43,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"361","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-04T04:02:24.512Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-09T04:01:05.390Z","_deleted":"2014-02-10T04:04:25.763Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":40,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"386","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-11T04:01:00.436Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-20T04:08:35.745Z","_deleted":"2014-02-21T04:00:54.137Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},{"id":"428","labels":["Film"],"properties":{"edi":62188,"_created":"2014-02-22T04:01:34.157Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-23T04:00:35.419Z","_deleted":"2014-02-24T04:01:10.415Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}}],"other":[],"relationships":[],"size":7,"stats":{"contains_updates":false,"nodes_created":0,"nodes_deleted":0,"properties_set":0,"relationships_created":0,"relationship_deleted":0,"labels_added":0,"labels_removed":0,"indexes_added":0,"indexes_removed":0,"constraints_added":0,"constraints_removed":0}},"graph":{"nodeMap":{"141":{"edi":62188,"_created":"2013-12-05T00:05:14.300Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-12T04:00:37.052Z","_deleted":"2014-01-13T04:01:14.853Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"poster":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":25,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"268":{"edi":62188,"_created":"2014-01-14T04:01:24.186Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-19T04:03:07.981Z","_deleted":"2014-01-20T04:04:49.884Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/6633","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":20,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"303":{"edi":62188,"_created":"2014-01-21T04:02:59.864Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-01-26T04:00:25.613Z","_deleted":"2014-01-27T04:01:55.707Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":27,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"334":{"edi":62188,"_created":"2014-01-28T04:00:36.976Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-02T04:01:38.668Z","_deleted":"2014-02-03T04:02:07.732Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":43,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"361":{"edi":62188,"_created":"2014-02-04T04:02:24.512Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-09T04:01:05.390Z","_deleted":"2014-02-10T04:04:25.763Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":40,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"386":{"edi":62188,"_created":"2014-02-11T04:01:00.436Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-20T04:08:35.745Z","_deleted":"2014-02-21T04:00:54.137Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]},"428":{"edi":62188,"_created":"2014-02-22T04:01:34.157Z","still_url":"http://www.cineworld.co.uk/assets/media/films/6633_still.jpg","_updated":"2014-02-23T04:00:35.419Z","_deleted":"2014-02-24T04:01:10.415Z","cert":"U","film_url":"http://www.cineworld.co.uk/whatson/cloudy-with-a-chance-of-meatballs-2","imax":false,"cineworldInternalID":6786,"poster_url":"http://www.cineworld.co.uk/assets/media/films/6633_poster.jpg","trailer":"http://webcache1.bbccustomerpublishing.com/cineworld/trailers/CLOUDY WITH A CHANCE OF MEATBALLS 2 _qtp.mp4","actors":"Bill Hader, Anna Faris, James Caan, Will Forte, Kristen Schaal, Terry Crews, Andy Samberg, Neil Patrick Harris, Al Pacino","class":"Film","weighted":0,"3D":false,"classification":"U","release":"2013-10-25T00:00:00+00:00","title":"2D - Cloudy With A Chance Of Meatballs 2","advisory":"","runtime":95,"cineworldID":6633,"categories":["junior"]}},"relationshipMap":{}}})

keys = _(x.table.nodes).pluck('properties').map(_.keys).flatten().unique().value()
values = _(x.table.nodes).pluck('properties').value()
data = _.map(keys, function(key) { return _(values).map(function(obj) { return obj[key] || ""; }).join("\t"); }).join("\n")
header = keys.join("\n")

Diffing the above yields that the EDI is the same, but there are gaps in (_created, _deleted) around every Monday turning Tuesday, probably the day when they publish the new schedule.

TWiStErRob commented 10 years ago

The following finds the last movie and updates as required:

match (f:Film)
with f.edi as edi, collect(f) as group, min(f._created) as _created, max(f._updated) as _updated,
    case when length([x IN collect(f) WHERE x._deleted is null | x._created]) = 0 then max(f._deleted) end as _deleted
match (f:Film {edi: edi}) where (f._deleted = _deleted) or (f._deleted is null and _deleted is null)
set f.__keepme = true, f._created = _created, f._updated = _updated, f._deleted = _deleted
// return f, _created, _updated, _deleted
TWiStErRob commented 10 years ago

The above is too complicated a cleaner version is here. Find the last movie update and fix the _created and _updated dates on it, this way it'll keep all the updates and _deleted info, also delete all older ones:

match (f:Film)
with
    f.edi as edi,
    collect(f) as group,
    min(f._created) as old_created,
    max(f._created) as new_created,
    case // if there's a node without _updated it has been just created
        // use the last updated if all nodes have updated, use the last created if at least one is missing
        when length([x IN collect(f) WHERE x._updated is null | x.edi]) = 0 then max(f._updated)
        else max(f._created)
    end as _updated
where length(group) > 1 // only where it's a problem
match (f:Film {edi: edi, _created: new_created}) // find the last update
foreach(x in filter(x in group where x._created <> f._created) | delete x) // delete the rest
set f._created = old_created, f._updated = _updated // update the last one

There were 420 :Film nodes and 315 distinct EDIs out there: match (f:Film) return count(f), count(distinct f.edi)

After executing the top query yields 0 results and the execution result is:

Deleted 105 nodes, set 124 properties, returned 0 rows in 882 ms