I need help with a sql query

So you are in the parent field and you what to count total of children?

SELECT COUNT(record_id) FROM `#__js_res_record_values` WHERE field_value = '11' AND field_id = '12'

Where 11 is an ID of the parent record and 12 is an ID of the child field.

Nope, I want, to count number of all chields that a user has for all his articles

SELECT COUNT(v.record_id) 
  FROM `#__js_res_record_values` AS v 
 WHERE v.field_value IN(SELECT id FROM `#__js_res_record` WHERE user_id = 845) 
   AND v.field_id = '12'

Thanks we are close :) what about counting only those who are new ?

Rgds

How do yu define new? Last 10 days?

New, means all those chield records that the user has not viewed/accessed detail page

SELECT 
    COUNT(v.record_id)
FROM
    `#__js_res_record_values` AS v
WHERE
    v.field_value IN (SELECT 
            id
        FROM
            `#__js_res_record`
        WHERE
            user_id = 845 AND section_id = 1
                AND id NOT IN (SELECT 
                    record_id
                FROM
                    `#__js_res_hits`
                WHERE
                    section_id = 1 AND user_id = 845))
        AND v.field_id = '12'

Don't work always returns 0, I give up dont want to wait 1 more week for another hint. (I did changeded the ids according to my case)

Rgds

You have to change all 1 of section_id to section id of children.

SELECT 
    COUNT(v.record_id)
FROM
    `#__js_res_record_values` AS v
WHERE
    v.field_value = 124
AND v.user_id = 845
AND v.record_id NOT IN (
    SELECT 
        h.record_id
    FROM
        `#__js_res_hits` AS h
    WHERE
        h.section_id = 1 AND h.user_id = 845
)

I changed the query. v.field_value = 124 it is an ID of the parent record. You can try to delete AND v.user_id = 845 if you have limitation and users may only add childrent to his own parents.