adding WHERE to a query

[abitshort]

SELECT

*

FROM

tablename AS t1

INNER JOIN

(

    SELECT

    ROUND(RAND() * (SELECT MAX(id) FROM tablename)) AS id

) AS t2

ON

t1.id >= t2.id

ORDER BY

t1.id ASC

LIMIT 1;

 

 

-------------

Could anyone please help me to add WHERE live = '1' to the above query?

 

Thanks

[Mchl]

SELECT
*
FROM
tablename AS t1
INNER JOIN
(
    SELECT
    ROUND(RAND() * (SELECT MAX(id) FROM tablename)) AS id
) AS t2
ON
t1.id >= t2.id
WHERE live = '1'
ORDER BY
t1.id ASC
LIMIT 1;

 

or

 

SELECT
*
FROM
tablename AS t1
INNER JOIN
(
    SELECT
    ROUND(RAND() * (SELECT MAX(id) FROM tablename WHERE live = '1')) AS id
) AS t2
ON
t1.id >= t2.id
ORDER BY
t1.id ASC
LIMIT 1;