Revision 396231643461 () - Diff

Link to this snippet: https://friendpaste.com/4G2uZexRfhd3sSVROqjZEc
Embed:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
SELECT c.course_id,
       c.course_reference_no,
       c.course_title,
       c.currency_id,
       c.cost,
       c.program_type_id,
       c.method_id,
       c.status_id,
       c.no_of_days,
       c.total_hours,
       c.no_of_participants,
       c.no_of_batches,
       c.deadline_for_enrollment,
       c.course_description,
       c.course_details,
       c.trainers_name,
       c.venue,
       c.room_no,
       c.address,
       c.city_id,
       c.province_id,
       c.state_id,
       c.country_id,
       c.zipcode,
       c.contact_details,
       c.partner_id,
       c.date_added,
       c.date_modified,
       c.date_deleted,
       c.batch_date_required,
       c.credits,
       c.active,
       c.cost_vat_included,
       c.cost_not_specified,
       c.expiration_date,
       c.special_offer,
       c.individual_id,
       con.country_name,
       pt.program_type_name,
       cs.status_name,
       cs.status_description,
       cm.method_name,
       cm.method_description,
       p.company_aka,
       cur.name,
       cat.category_name,
       ps.province_name,
       st.state_name,
       cy.city_name,
       p.partner_name,
       pi.lastname,
       pi.firstname,
       CONCAT(CONCAT(pi.lastname, ' , '), pi.firstname) AS fullname,
       esched.*
  FROM courses c
       LEFT JOIN course_methodologies cm
          ON cm.method_id = c.method_id
       LEFT JOIN course_status cs
          ON cs.status_id = c.status_id
       LEFT JOIN partners p
          ON p.user_id = c.user_id
       LEFT JOIN events_schedule esched
          ON c.course_id = esched.course_id
       LEFT JOIN currency cur
          ON cur.currency_id = c.currency_id
       LEFT JOIN course_categories cc
          ON cc.course_id = c.course_id
       LEFT JOIN categories cat
          ON cat.category_id = cc.category_id
       LEFT JOIN program_types pt
          ON pt.program_type_id = c.program_type_id
       LEFT JOIN countries con
          ON con.country_id = c.country_id
       LEFT JOIN provinces ps
          ON ps.province_id = c.province_id
       LEFT JOIN states st
          ON st.state_id = c.state_id
       LEFT JOIN city cy
          ON cy.city_id = c.city_id
       LEFT JOIN partners_individual pi
          ON pi.user_id = c.user_id
       LEFT JOIN users u
          ON u.user_id = c.user_id
 WHERE     1 = 1
       AND c.course_type = 1
       AND active = 1
       AND c.country_id = 52
       AND c.course_title LIKE '%cook%'
       AND cat.main_category_id = 40
       AND cat.category_id = 360
       AND ((('2010-09-01 00:00:00' <= esched.date_start
              AND esched.date_start <= '2010-09-25 00:00:00')
             OR ('2010-09-01 00:00:00' <= esched.date_end
                 AND esched.date_end <= '2010-09-25 00:00:00'))
            OR ((esched.date_start <= '2010-09-01 00:00:00'
                 AND '2010-09-01 00:00:00' <= esched.date_end)
                OR (esched.date_start <= '2010-09-25 00:00:00'
                    AND '2010-09-25 00:00:00' <= esched.date_end)))
GROUP BY c.course_id
ORDER BY c.course_id DESC