Suche: new beggingins 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] => new
[1] => beggingins
)
formatedSearchWords: #+new* +beggingins*# where query: (MATCH(titel, artist, label, mixnames, iancode, deckscode) AGAINST('+new* +beggingins*' IN BOOLEAN MODE)) search anfrage query: SELECT *, (IF (source = 'cds', 0.5, 1) * IF ((MATCH(titel, artist, label, iancode, deckscode) AGAINST('+new* +beggingins*' 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('new beggingins' 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('+new* +beggingins*' 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 4250, 50 Suche / Search - decks.de: Vinyl Shop
0 search results
Suche: 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] =>
)
formatedSearchWords: #+# where query: (MATCH(titel, artist, label, mixnames, iancode, deckscode) AGAINST('+' IN BOOLEAN MODE)) search anfrage query: SELECT *, (IF (source = 'cds', 0.5, 1) * IF ((MATCH(titel, artist, label, iancode, deckscode) AGAINST('+' 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('' 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('+' 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 4250, 50
Die Suche nach new beggingins war leider erfolglos!
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"