mira quedo asi, estamos programando desde php, pero no arroja nada :(
Código PHP:
$sql = "SELECT m.id, m.numero_de_guia, m.fecha, m.orden_id, u.user_id, ";
$sql .= "u.name, u.address1, u.address2, ";
$sql .= " u.state_id, u.zip, u.country_id, u.daytime_phone ";
$sql .= "FROM multipack AS m, va_users AS u , va_orders as o ";
$sql .= "WHERE m.fecha BETWEEN DATE_ADD(NOW(), INTERVAL '-1 8' DAY_HOUR) AND";
$sql .= "DATE_FORMAT(NOW(), '%Y-%m-%d'), #03:59:59#) by m.fecha";
$sql .= " AND m.user = u.user_id And m.orden_id = o.order_id";