Sql
Wszyscy lubimy zapytania sql’owe, prawda?
SELECT id
FROM konkursy
WHERE START < NOW( )
AND NOW( ) <
END AND aktywny =1
AND id
IN (SELECT id_konkursu
FROM rks_in_konkursy
WHERE id_user_rks = (
SELECT rks
FROM salony
WHERE id =1 ))
LIMIT 0 , 30;
Wszyscy lubimy zapytania sql’owe, prawda?
SELECT id
FROM konkursy
WHERE START < NOW( )
AND NOW( ) <
END AND aktywny =1
AND id
IN (SELECT id_konkursu
FROM rks_in_konkursy
WHERE id_user_rks = (
SELECT rks
FROM salony
WHERE id =1 ))
LIMIT 0 , 30;