Database Queries

SHOW FULL COLUMNS FROM `db0_user`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_user' AND kcu.table_name = 'db0_user'

SELECT * FROM `db0_user` WHERE `id`=4

SHOW FULL COLUMNS FROM `db0_ente`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db0_ente' AND kcu.table_name = 'db0_ente'

SELECT * FROM `db0_ente` WHERE `id_ente`='1'

SHOW FULL COLUMNS FROM `db3_bollettario_acc`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db3_bollettario_acc' AND kcu.table_name = 'db3_bollettario_acc'

SELECT COUNT(*) FROM `db3_bollettario_acc` WHERE `db3_bollettario_acc`.`id_ente_bollettario_acc`='1'

SELECT * FROM `db3_bollettario_acc` WHERE `db3_bollettario_acc`.`id_ente_bollettario_acc`='1' LIMIT 20

SHOW FULL COLUMNS FROM `db3_infrazione_acc`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'db3_infrazione_acc' AND kcu.table_name = 'db3_infrazione_acc'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=12

SELECT * FROM `articoli_new` WHERE `id_articolo`='894'

SHOW FULL COLUMNS FROM `articoli_new`

SELECT kcu.constraint_name, kcu.column_name, kcu.referenced_table_name, kcu.referenced_column_name FROM information_schema.referential_constraints AS rc JOIN information_schema.key_column_usage AS kcu ON ( kcu.constraint_catalog = rc.constraint_catalog OR (kcu.constraint_catalog IS NULL AND rc.constraint_catalog IS NULL) ) AND kcu.constraint_schema = rc.constraint_schema AND kcu.constraint_name = rc.constraint_name WHERE rc.constraint_schema = database() AND kcu.table_schema = database() AND rc.table_name = 'articoli_new' AND kcu.table_name = 'articoli_new'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=14

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=15

SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=16

SELECT * FROM `articoli_new` WHERE `id_articolo`='398'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=17

SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=18

SELECT * FROM `articoli_new` WHERE `id_articolo`='155'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=20

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=21

SELECT * FROM `articoli_new` WHERE `id_articolo`='1409'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=22

SELECT * FROM `articoli_new` WHERE `id_articolo`='1431'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=23

SELECT * FROM `articoli_new` WHERE `id_articolo`='1409'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=24

SELECT * FROM `articoli_new` WHERE `id_articolo`='1409'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=25

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=26

SELECT * FROM `articoli_new` WHERE `id_articolo`='1410'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=28

SELECT * FROM `articoli_new` WHERE `id_articolo`='1409'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=29

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=30

SELECT * FROM `articoli_new` WHERE `id_articolo`='1429'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=31

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=32

SELECT * FROM `articoli_new` WHERE `id_articolo`='1429'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=33

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'

SELECT * FROM `db3_infrazione_acc` WHERE `id_bollettario_infrazione_acc`=34

SELECT * FROM `articoli_new` WHERE `id_articolo`='1423'