Revize 2242
Přidáno uživatelem Ondřej Fibich před téměř 11 roky(ů)
| freenetis/branches/1.1/application/models/search.php | ||
|---|---|---|
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
LEFT JOIN variable_symbols vs ON vs.account_id = a.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
| ... | ... | |
|
JOIN enum_types e ON m.type = e.id
|
||
|
LEFT JOIN translations t ON e.value LIKE t.original_term AND t.lang = 'cs'
|
||
|
JOIN address_points ap ON m.address_point_id = ap.id
|
||
|
JOIN streets s ON ap.street_id = s.id
|
||
|
LEFT JOIN streets s ON ap.street_id = s.id
|
||
|
JOIN towns tw ON ap.town_id = tw.id
|
||
|
LEFT JOIN membership_interrupts mi ON m.id = mi.member_id
|
||
|
LEFT JOIN members_fees mf ON mi.members_fee_id = mf.id AND (mf.activation_date < CURDATE() AND mf.deactivation_date > CURDATE())
|
||
Také k dispozici: Unified diff
Opravy:
- osetreni nemoznosti vyhledat clena ve fulltextu, pokud nemá jeho adresni bod nastavenou ulici