$query =
    "SELECT c.first_name, c.last_name, ii.invoice_id, ii.quantity, it.description
     FROM `c2092`.`customer` c
     JOIN `c2092`.`invoice` i ON c.customer_id = i.customer_id
     JOIN `c2092`.`invoice_item` ii ON ii.invoice_id = i.invoice_id
     JOIN `c2092`.`item` it ON it.item_id = ii.item_id
     WHERE ii.quantity > ?
     ORDER BY ii.invoice_id";