Дмитрий Гординский

Как избежать ошибки database is locked?

SELECT value, COUNT(*)
FROM table
GROUP BY 1
ORDER BY 2 DESC

SELECT product_id
FROM table_name
WHERE av_id IN (3, 11, 15)
GROUP BY product_id 
HAVING COUNT(DISTINCT av_id) = 3

SELECT 
    q.id, 
    q.testid, 
    q.question, 
    q.id, 
    GROUP_CONCAT(v.variant, '; ')
FROM questions AS q
LEFT JOIN variants AS v ON v.questionid = q.id
WHERE q.testid='1'
GROUP BY q.id