SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated/1000000, 0)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated/1000000, 0)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated/1000000, 8)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated, -6)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated, -6)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_created, -6)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed, -6)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated, -6)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id), ROUND(ptrp_reviewed_updated, -6)
FROM... |
3 years ago |
SELECT ptrp_page_id, ROUND(ptrp_reviewed_updated, -6)
FROM... |
3 years ago |
SELECT ptrp_page_id, ROUND(ptrp_reviewed_updated, -4)
FROM... |
3 years ago |
SELECT ptrp_page_id, ptrp_reviewed_updated
FROM pagetriage_page
JOIN page ON... |
3 years ago |
SELECT ptrp_page_id, FROM_UNIXTIME(ptrp_reviewed_updated)
FROM... |
3 years ago |
SELECT ptrp_page_id, FROM_UNIXTIME(ptrp_reviewed_updated,%Y%m%d)
FROM... |
3 years ago |
SELECT ptrp_page_id, CONVERT(DATE, ptrp_reviewed_updated, 112)
FROM... |
3 years ago |
SELECT COUNT(ptrp_page_id)
FROM pagetriage_page
JOIN page ON page_id =... |
3 years ago |
SELECT page_title, pagetriage_page.*
FROM pagetriage_page
JOIN page ON... |
3 years ago |
SELECT page_title, pagetriage_page.*
FROM pagetriage_page
JOIN page ON... |
3 years ago |
SELECT page_title, pagetriage_page.*
FROM pagetriage_page
JOIN page ON... |
3 years ago |
SELECT pagetriage_page.*, page_title
FROM pagetriage_page
JOIN page ON... |
3 years ago |
SELECT *
FROM pagetriage_page
WHERE ptrp_last_reviewed_by = 120801
LIMIT 10 |
3 years ago |
SELECT *
FROM pagetriage_page
LIMIT 10 |
3 years ago |
DESCRIBE pagetriage_page |
3 years ago |