\s
\d
          select * from items;
        \q
\q
\d
\q
\q
\d
select * from assets_products;
\q
SELECT ad.id, a.id, p.id, p.isbn, s.title, p.title, ad.size, ad.mime_type, ad.width, ad.height, ad.bytes, ad.pages, ad.duration, ad.file_pointer, a.title, a.kind, a.is_visible
FROM asset_derivativesAS ad
LEFT JOIN assets AS aON a.id=ad.asset_id
LEFT JOIN assets_productsAS as ON a.id=ap.asset_id
LEFT JOIN products AS p ON ap.product_id=p.id
LEFT JOIN products_series AS ps ON p.id=ps.product_id
LEFT JOIN series AS s ON ps.series_id=s.id
WHERE p.isbn=0439971780;
SELECT ad.id, a.id, p.id, p.isbn, s.title, p.title, ad.size, ad.mime_type, ad.width, ad.height, ad.bytes, ad.pages, ad.duration, ad.file_pointer, a.title, a.kind, a.is_visible
FROM asset_derivativesAS ad
LEFT JOIN assets AS a ON a.id=ad.asset_id
LEFT JOIN assets_productsAS as ON a.id=ap.asset_id
LEFT JOIN products AS p ON ap.product_id=p.id
LEFT JOIN products_series AS ps ON p.id=ps.product_id
LEFT JOIN series AS s ON ps.series_id=s.id
WHERE p.isbn='0439971780';
SELECT ad.id, a.id, p.id, p.isbn, s.title, p.title, ad.size, ad.mime_type, ad.width, ad.height, ad.bytes, ad.pages, ad.duration, ad.file_pointer, a.title, a.kind, a.is_visible
FROM asset_derivatives AS ad
LEFT JOIN assets  AS a ON a.id=ad.asset_id
LEFT JOIN assets_products AS as ON a.id=ap.asset_id
LEFT JOIN products  AS p ON ap.product_id=p.id
LEFT JOIN products_series  AS ps ON p.id=ps.product_id
LEFT JOIN series  AS s ON ps.series_id=s.id
WHERE p.isbn='0439971780';
SELECT ad.id, a.id, p.id, p.isbn, s.title, p.title, ad.size, ad.mime_type, ad.width, ad.height, ad.bytes, ad.pages, ad.duration, ad.file_pointer, a.title, a.kind, a.is_visible
FROM asset_derivatives AS ad
LEFT JOIN assets  AS a ON a.id=ad.asset_id
LEFT JOIN assets_products AS ap ON a.id=ap.asset_id
LEFT JOIN products  AS p ON ap.product_id=p.id
LEFT JOIN products_series  AS ps ON p.id=ps.product_id
LEFT JOIN series  AS s ON ps.series_id=s.id
WHERE p.isbn='0439971780';
\q
grant select, update on * to nobody;
grant select, update, insert on assets to nobody;
grant select, update, insert on asset_derivatives to nobody;
grant select, update, insert on assets_products to nobody;
grant select  on products, products_series to nobody; grant select  on products, products_series to nob
grant select  on series to nobody;
\q
grant select, update, insert on assets to nobody;
grant select, update, insert on asset_derivatives to nobody;
grant select, update, insert on assets_products to nobody;
grant select  on products, products_series to nobody;
grant select  on series to nobody;
\q
grant select, update, insert on assets_series to nobody;
select * from products where isbn='9999249027';
select * from assets_products where product_id=19l
;
select * from assets_products where product_id=19;
select * from asset_derivatives where asset_id=317;
select * from asset_derivatives where asset_id=475;
\q
grant select, update, insert on assets to nobody;
grant select, update, insert on asset_derivatives to nobody;
grant select, update, insert on assets_products to nobody;
grant select, update, insert on assets_contributors to nobody;
grant select, update, insert on assets_series to nobody;
grant select on asset_kinds to nobody;
grant select on products, products_series, series, products_contributors, contributors, packs to nobody;
grant select on products, products_series, series, product_contributors, contributors, packs to nobody;
grant select, update, insert on assets_series to nobody;
grant select on asset_kinds;
grant select on asset_kinds to nobody;
\q
select * from asset_derivatives where asset_id=317;
\q
grant select on products, products_series, series, product_contributors, contributors, packs to nobody;
grant select on products, products_series, series, contributors, packs to nobody;
select * from asset_derivatives where asset_id=475;
\q
grant select, update, insert on assets to nobody;
grant select, update, insert on asset_derivatives to nobody;
grant select, update, insert on assets_products to nobody;
grant select, update, insert on assets_contributors to nobody;
grant select, update, insert on assets_series to nobody;
grant select on asset_kinds to nobody;
grant select on products, products_series, series, products_contributors, contributors, packs to nobody;
grant select on products, products_series, series, contributors, packs to nobody;
\s asset_kinds;