prova così:
Codice PHP:
SELECT t1. *, t2.valore_cercato
FROM categorie AS t1
LEFT JOIN page AS t2 ON t1.id = t2.cat_ref_id
WHERE t2.page_type=1
prova così:
Codice PHP:
SELECT t1. *, t2.valore_cercato
FROM categorie AS t1
LEFT JOIN page AS t2 ON t1.id = t2.cat_ref_id
WHERE t2.page_type=1