Bonjour,
J'ai écrit la requete suivante qui fonctionne mais qui est beaucoup trop longue à exécuter !!!:
J'en ai fait une autre qui est rapide à exécuter mais qui ne me donne que les enregistrements customers pour lesquels un contact est enregistré...SELECT DISTINCT a.id AS id, a.name AS name, a.city AS city, a.customer_number AS customer_number, a.ranking AS ranking, a.status AS status , b.username AS user
FROM jos_users AS b
INNER JOIN jos_neo_customers AS a ON a.user = b.id
LEFT JOIN jos_neo_contacts AS c ON a.id = c.customer
WHERE (
LOWER( a.name ) LIKE '%$searchword%'
OR LOWER( a.city ) LIKE '%$searchword%'
OR LOWER( a.zipcode ) LIKE '%$searchword%'
OR LOWER( c.name ) LIKE '%$searchword%'
OR LOWER( c.lastname ) LIKE '%$searchword%'
OR LOWER( a.address1 ) LIKE '%$searchword%'
OR LOWER( a.address2 ) LIKE '%$searchword%'
OR LOWER( a.website ) LIKE '%$searchword%'
OR LOWER( a.mail ) LIKE '%$searchword%'
OR LOWER( c.mail ) LIKE '%$searchword%'
)
Après un paquet d'essais et quelques heures de galeres, je m'en remets donc à vous....SELECT DISTINCT a.id AS id, a.name AS name, a.city AS city, a.customer_number AS customer_number, a.ranking AS ranking, a.status AS status , b.username AS user
FROM jos_users AS b, jos_neo_customers AS a, jos_neo_contacts AS c
WHERE a.user = b.id
AND a.id = c.customer
AND (
LOWER( a.name ) LIKE '%$searchword%'
OR LOWER( a.city ) LIKE '%$searchword%'
OR LOWER( a.zipcode ) LIKE '%$searchword%'
OR LOWER( c.name ) LIKE '%$searchword%'
OR LOWER( c.lastname ) LIKE '%$searchword%'
OR LOWER( a.address1 ) LIKE '%$searchword%'
OR LOWER( a.address2 ) LIKE '%$searchword%'
OR LOWER( a.website ) LIKE '%$searchword%'
OR LOWER( a.mail ) LIKE '%$searchword%'
OR LOWER( c.mail ) LIKE '%$searchword%'
)
Merci d'avance pour votre aide !
Partager