Completed

sql query expert needed for search result page fixing

basically we are looking for 21 days generalize formula

we will do a formula which will pick dates from 1-21 days

with 3 offers

search result page

[login to view URL]

------------------------------------- 5-12 june-----------------------

1. hotel villa svizzera 609 € but the price for this week in this hotel is 529+529

[login to view URL] paradiso also is wrong because you show 898 but the correct is 998

3. missed many hotels like hotel san giovanni, hotel eden park, hotel stella maris, they not show in your search

[login to view URL] Maris from 5 to 12 june cost 345€ per person

[login to view URL] San Giovanni we have 2 offer:

1) from 21/05 to 11/06

2) from 11/06 to 9/07 and in this case we have to mix the 2 prices

==============================5-19 june===========

Annabelle is ok

Onda blu is wrong (correct is 1076)

Gran paradiso is wrong (correct is 1996€)

===========5-26 june===========

[login to view URL] is wrong (correct is 1890€

2. Gran paradiso is wrong, correct is 2994

3 hotel onda blu is wrong, correct is 1614€

Skills: SQL, MySQL, Microsoft SQL Server, Database Administration, PHP

About the Client:
( 18 reviews ) Hafizabad, Pakistan

Project ID: #33787465

Awarded to:

(14 Reviews)
4.0

14 freelancers are bidding on average $24 for this job

ankitbagre2000

Hello ! I’m Ankit ! I would like to let you know that I’m an expert in Website Design, HTML, CSS , JAVASCRIT, JQUERY, AJAX, VUE.js ,Node.js , React.js, shopify, PHP and MySQL expert. If you hire me , I will do my be More

$20 USD in 1 day
(105 Reviews)
6.9
devupfree

Hello, I understand the issue and I can solve it in just few hours, You can come to inbox for further discussion and you can also share credentials of your site so, i can have a look in it. Regards, Nayla b.

$20 USD in 1 day
(50 Reviews)
5.9
iamNahida

Hello respected client! I have read your job description carefully and am very interested in your project because I am very familiar with this project. Your job is very interesting and I can do it on time. Let me tell More

$30 USD in 2 days
(3 Reviews)
2.3
SultanMahmud3

I have professional experience to work with Web Applications, Mobile Apps and Desktop Software development. My professional skillfulness: • Spring Boot: I have been working Backend and Frontend with single or Multi More

$20 USD in 7 days
(1 Review)
1.9
zina73

Hello, I have read the details you shared. It's a bug either in query or filtration code. If I could look into the source code, I can solve this. Let's have a chat soon and finish it. Kind Regards, Zinaida

$25 USD in 1 day
(3 Reviews)
1.9
Squarelymn

Hello Greetings of the day, This is Squarely here, I have 4+ years of experience in Web designing and web development. i read your description and I am sure i can do this task easily Kindly reply me so we can discuss m More

$15 USD in 7 days
(2 Reviews)
0.9
pankajpandeyiw

Hello Sir, I am freelancer with skills -> Php, CodeIgniter, Laravel, Html, Css, Javascript, Bootstrap, Mysql And Expert in Digital Marketing, ON-Page, Off-Page SEO, Social Media Marketing and Ads Campaigning. We are More

$30 USD in 1 day
(0 Reviews)
0.0
tankdarshit437

I have the good knowledge of the PHP laravel, sql and I have done 3 projects in PHP laravel using the mysql database [login to view URL] I have good knowledge of the PHP.

$20 USD in 7 days
(0 Reviews)
0.0
abubakar12345678

I will do this task surely about sql query related to search. Give me chance to show you good result. Thanks

$30 USD in 1 day
(0 Reviews)
0.0
brintodibyendu

I have expertise in sql query and I am a cs graduate and have hands on experience in this. thank you

$30 USD in 7 days
(0 Reviews)
2.1
Shawnfrancis657

Hello there, I have read your requirements and can work on it as i am having expertise in Backend and Sql DB,I would really appreciate if i got my first Freelancer offer from you, Thanks.

$25 USD in 3 days
(0 Reviews)
0.0
Romeoofem

Hello, I have extensive knowledge and experience working with SQL, PHP and Python. I will be pleased to render this service to you. Kindle reply so we can take it up from there. Regards

$20 USD in 3 days
(0 Reviews)
0.0
ShabuddinG

I have very good SQL querying skill, please let me know if you are ready to give me work on this project.

$20 USD in 7 days
(0 Reviews)
0.0