Write a mySQL query

已完成 已发布的 5 年前 货到付款
已完成 货到付款

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

项目ID: #18601955

关于项目

8个方案 远程项目 活跃的5 年前

授予:

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 更多

$30 USD 在1天内
(1153条评论)
7.6

有8名威客正在参与此工作的竞标,均价$23/小时

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 更多

$25USD 在1天里
(330条评论)
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 更多

$25USD 在1天里
(39条评论)
5.5
Gkiprop

Understand the task Relevant Skills and Experience MSQl.

$25USD 在1天里
(1条评论)
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 更多

$25 USD 在2天内
(0条评论)
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.

$20USD 在1天里
(0条评论)
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.

$15USD 在1天里
(0条评论)
0.0