Retrieve data for current mode #2:
select sql (total: 0 | time: 0.0044 sec.) SELECT * FROM psbj_orders INNER JOIN psbj_order_detail ON psbj_orders.id_order=psbj_order_detail.id_order INNER JOIN psbj_customer ON psbj_orders.id_customer=psbj_customer.id_customer INNER JOIN psbj_order_state ON psbj_orders.current_state=psbj_order_state.id_order_state INNER JOIN psbj_address ON psbj_orders.id_address_delivery=psbj_address.id_address LEFT JOIN psbj_message ON psbj_orders.id_order=psbj_message.id_order INNER JOIN psbj_order_state_lang ON psbj_orders.current_state=psbj_order_state_lang.id_order_state LEFT JOIN psbj_oav_order_ip_log ON psbj_orders.id_cart=psbj_oav_order_ip_log.id_cart LEFT JOIN psbj_product ON psbj_order_detail.product_id=psbj_product.id_product LEFT JOIN psbj_supplier ON psbj_product.id_supplier=psbj_supplier.id_supplier INNER JOIN psbj_image ON psbj_order_detail.product_id=psbj_image.id_product INNER JOIN psbj_iconos ON psbj_orders.id_shop = psbj_iconos.shop_id INNER JOIN psbj_iconos_2 ON psbj_orders.id_shop = psbj_iconos_2.shop_id_2 INNER JOIN psbj_iconos_proveedores ON psbj_orders.id_shop = psbj_iconos_proveedores.shop_id_4 WHERE psbj_order_state.invoice=psbj_iconos.estado_invoice AND psbj_order_state.delivery=psbj_iconos.estado_delivery AND psbj_order_state.shipped=psbj_iconos.estado_shipped AND psbj_order_state.paid=psbj_iconos.estado_paid AND psbj_order_detail.terminado=psbj_iconos_2.estado_terminado AND psbj_order_detail.entregado=psbj_iconos_2.estado_entregado AND psbj_order_detail.bar=psbj_iconos_2.estado_bar AND psbj_order_detail.sushi=psbj_iconos_2.estado_sushi AND psbj_supplier.id_supplier=psbj_iconos_proveedores.proveedor AND psbj_order_detail.product_id=psbj_image.id_product AND psbj_image.position=1 AND psbj_order_detail.terminado = 1 AND psbj_order_detail.bar = 0 ORDER BY psbj_orders.id_order ASC LIMIT 0, 10