Suche: big white dog lost wassuch: atl wosuch: all -- AND (source='comein' OR source='technonews' OR source='technoclassix' OR source='housenews' OR source='houseclassix' OR source='blacknews' OR source='blackclassix' OR source='moregenresnews' OR source='moregenresclassix' OR source='phononetnews' OR source='cds' OR source='clubwear' OR source='zubehoer' OR source='rareandused' OR source='mags' OR source='technostock' OR source='housestock')
Searcharray: Array
(
[0] => big
[1] => white
[2] => dog
[3] => lost
)
formatedSearchWords: #+big* +white* +dog* +lost*# where query: (MATCH(titel, artist, label, mixnames, iancode, deckscode) AGAINST('+big* +white* +dog* +lost*' IN BOOLEAN MODE)) search anfrage query: SELECT *, (IF (source = 'cds', 0.5, 1) * IF ((MATCH(titel, artist, label, iancode, deckscode) AGAINST('+big* +white* +dog* +lost*' IN BOOLEAN MODE)), 1, 0.5) * IF (datum > DATE_SUB( NOW( ) , INTERVAL 2 month) AND source != 'cds' , 1.5, 1) * IF ((MATCH(titel, artist, label, iancode, deckscode) AGAINST('big white dog lost' IN BOOLEAN MODE)) , 2, 1) * IF ((STR_TO_DATE(SUBSTRING_INDEX(SUBSTRING_INDEX(decksrelease, '(', -1), ')', 1), '%Y.%m.%d') > CURDATE()) , 2, 1) * IF ((decksrelease NOT LIKE 'soon%' AND anzonline < 1) , 0.5, 1)) as rank, (SELECT GROUP_CONCAT(DISTINCT tag ORDER BY id ASC SEPARATOR '###') FROM listen.tags AS t2 WHERE t2.deckscode = t1.deckscode) as tags
FROM listen.alle2 AS t1
WHERE (
(MATCH(titel, artist, label, mixnames, iancode, deckscode) AGAINST('+big* +white* +dog* +lost*' IN BOOLEAN MODE))
AND (source='comein' OR source='technonews' OR source='technoclassix' OR source='housenews' OR source='houseclassix' OR source='blacknews' OR source='blackclassix' OR source='moregenresnews' OR source='moregenresclassix' OR source='phononetnews' OR source='cds' OR source='clubwear' OR source='zubehoer' OR source='rareandused' OR source='mags' OR source='technostock' OR source='housestock')
)
AND NOT (anzonline <= 0 AND label LIKE '%_white')
AND NOT (decksrelease LIKE 'soon%' AND label LIKE '%_white')
ORDER BY rank DESC, datum DESC
LIMIT 5900, 50 Suche / Search - decks.de: Vinyl Shop
you can enter: artist title label in this search field at the same time e.g.: Kalkbrenner Berlin Bpitch inverted commas for exact word order, e.g.: "in between"