how to substitute limit in subquery of mysql?

Question

I have this query and I know that I can't have limit clause in subquery for mysql is there anyway to write this in a correct syntax?

UPDATE:(SCENARIO)I want to maintain deleted visitors and when we want to select deleted visitors I should select distinct ips

$deletedvisitors = $wpdb->get_var("
       SELECT count(DISTINCT ip)
       FROM $table_name
       WHERE feed=''
       AND spider=''$normallimit AND id IN ( SELECT * FROM ". $table_name . " order by id limit $delneeded)");

What exactly are you trying to accomplish with your query? A usage scenario would help to get you a query that does what you need. — Adrian, Mar 18 '13 at 20:53
why *can't* you have a limit? also, why is `$normallimit` in the middle of nowhere? — UnholyRanger, Mar 18 '13 at 20:55
this is the syntax of a wordpress query I didn't change it it is from statpresscn plugin — Nickool, Mar 18 '13 at 20:57

score 0 · Answer 1 · edited May 23 '17 at 12:21

0

You can create a subQuery and join on it according to this SO answer

SELECT count(DISTINCT ip)
FROM    (
    SELECT  *
    FROM ". $table_name . "
    LIMIT 10
    ) q
JOIN    $table_name
ON      q.id = $table_name.id

edited May 23 '17 at 12:21

Community

1
1

answered Mar 18 '13 at 20:53

Matt Busche

14,216
5
36
61

how to substitute limit in subquery of mysql?

1 Answers1