PDO JOIN LEFT - fetch result - no result

Asked Jan 21 '16 at 13:32

Active Jan 21 '16 at 13:48

Viewed 52 times

I have 2 tables in 1 database. The result shall have all values, which are NOT in table 2. The request like this works fine, but is really slow. I would like to change to LEFT JOIN

$abfrage = "SELECT * FROM spotify WHERE 
pos1 > '0' AND pos1 <= '100' 
AND (land = 'GLOBAL' OR land = 'DE') 
AND link_id NOT IN (SELECT URL FROM spotify_blacklist) ORDER BY song ASC";

This is what i have so far - it would be great to get your help!

$abfrage = "SELECT * FROM spotify 
WHERE pos1 > '0' AND pos1 <= '100' 
AND (land = 'GLOBAL' OR land = 'DE') LEFT JOIN spotify_blacklist  
ON (spotify.link_id != spotify_blacklist.URL) 
WHERE spotify_blacklist.URL IS NULL";
$stmt = $pdo->prepare($abfrage);
$stmt->execute();

Can someone help me on this? PS. link_id & URL are URL´s.

edited Jan 21 '16 at 13:48

asked Jan 21 '16 at 13:32

LJSven

is pos1 integer column? – Rajen Raiyarela Jan 21 '16 at 13:42
It is a decimal (3,0) value – LJSven Jan 21 '16 at 13:42
1

You need to put the `JOIN ... ON ...` before the conditions. – jeroen Jan 21 '16 at 13:42
I tried it, but still no luck – LJSven Jan 21 '16 at 13:48
Even if i do it like this - i don´t get a result `$abfrage = "SELECT * FROM spotify LEFT JOIN spotify_blacklist ON (spotify.link_id = spotify_blacklist.URL) WHERE spotify_blacklist.URL IS NULL";` – LJSven Jan 21 '16 at 13:56
I found the mistake - in table 2 were duplicate entries. – LJSven Jan 21 '16 at 14:06

PDO JOIN LEFT - fetch result - no result

0 Answers0