Fix my Moodle sql query

$10-30 USD

Завершено

Опублікований

over 5 years ago

$10-30 USD

Оплачується при отриманні

I need the help from a SQL expert. When I execute the following query I get most of the information I want, that is full completed courses by user in Moodle. The problem is when I add one course column to be shown as a result, for example [login to view URL], records start being duplicated. I suppose it is due to one of my JOIN but I've tried moving them without find the problem. Thank you. SELECT username, FROM_UNIXTIME([login to view URL], '%d-%m-%Y') AS date_created, [login to view URL] FROM mdl_user u JOIN mdl_customcert_issues ON [login to view URL] = [login to view URL] JOIN mdl_user_enrolments ue ON [login to view URL] = [login to view URL] JOIN mdl_enrol e ON [login to view URL] = [login to view URL] JOIN mdl_role_assignments ra ON [login to view URL] = [login to view URL] JOIN mdl_context ct ON [login to view URL] = [login to view URL] AND [login to view URL] = 50 JOIN mdl_course c ON [login to view URL] = [login to view URL] AND [login to view URL] = [login to view URL]

ID проекту: 18036730

Про проект

9 пропозицій(-ї)

Дистанційний проект

Активність 6 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни

Отримайте гроші за свою роботу

Опишіть свою пропозицію

Реєстрація та подання заявок у проекти є безкоштовними

Доручений:

@khyatiraval

Hello, I have checked your query and i can fix this issue. Let's start work. Thank you waiting for your reply.

$25 USD за 0 день

5,0

(430 відгуки(-ів))

7,9

9 фрілансерів(-и) готові виконати цю роботу у середньому за $37 USD

@sumon355

Hello, As an expert in SQL, i am very much interested to fix this issue. Can you please show me the issue first? Looking forward to have a positive response from you. Thanks

$24 USD за 0 день

5,0

(356 відгуки(-ів))

8,2

@VirasatSolutions

Hello Greetings for the day !!! As per my understanding there is some issue within Moodle database,so we need to review & fix it. -> May i have your an SQL database ? I would like to tell you that I am working on Moodle platform from last 7 years.I have worked on its different versions such as 1.x, 2.x and now 3.x. Waiting for your reply Kind Regards HS Virasat Solutions

$111 USD за 1 день