Write a mySQL query

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

Hi - I need an optimized, fast query that lets me display collections of images - three per collection (See attached image that shows one collection. In reality I'd be displaying bunches of these sets of three, each its own collection.)

There are three tables: collections, which has a title and unique ID for each collection; collection_items, which holds the image IDs along with a collection ID (the "parent" collection); and finally a files table, which contains the image ID that matches the one in collection_items. I can send a DB dump if you're interested in the project. Hopefully this should be a piece of cake for a mySQL pro. Thank you!

MySQL

Project ID: #18601955

About the project

8 proposals Remote project Active 5 years ago

Awarded to:

TakeReal

Hello, My name is Sergey. I am Freelancer from Saint Petersburg, Russia. I can help you to select Collections of images. 3 images per collection. I need MySQL dump to start. This is list of MySQL projects, succ More

$30 USD in 1 day
(1153 Reviews)
7.6

8 freelancers are bidding on average $23 for this job

mahamadali

I am experienced php developer and web designer with the depth knowledge related to MySQL,Laravel,WordPress,MSSQL,JSON,JAVASCRIPT,AJAX,XML,jQuery,CSS,HTML5,Material Designing with the integration of web technologies. I More

$25 USD in 1 day
(330 Reviews)
7.4
anshulikabansal

Hello Sir, Please send me the dump of db. One more thing right now you are showing the images in a set of 3 as per collection id, so whats the difference you are looking in terms of output or you just want to imp More

$25 USD in 1 day
(39 Reviews)
5.5
Gkiprop

Understand the task Relevant Skills and Experience MSQl.

$25 USD in 1 day
(1 Review)
0.4
boldan94

I am interested in developing your sql. If you are interested, you can contact me. I am a PHP full stack developer with 6 years of experience in web development and extensive knowledge in PHP (Codeigniter and Laravel More

$25 USD in 2 days
(0 Reviews)
0.7
szeeshanhassan3

hi, I've read your project requirement about mysql query and I can do it successfully because it suits by skill set. Thanks Zee.

$20 USD in 1 day
(0 Reviews)
0.0
anstartech

We have proficient knowledge of SQL and we can complete this work in 1 hour. Please let us know if you are good to go with us.

$15 USD in 1 day
(0 Reviews)
0.0