SHARE
TWEET

Untitled

a guest Jun 25th, 2019 55 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. select histories.*, services.*, providers.name, califications.id as
  2.     calification_id, califications.rating from histories
  3.     left join califications on histories.id = califications.history_id
  4.     inner join services on histories.service_id = services.id
  5.     inner join providers on services.provider_id = providers.id
  6.     where histories.user_id = ?
  7.      
  8. select histories.*, services.*, providers.name, providers.image,
  9.   califications.id, califications.rating, promotions.discount from histories
  10.     left join califications on califications.history_id = histories.id
  11.     inner join services on histories.service_id = services.id
  12.     inner join providers on services.provider_id = providers.id
  13.     inner join promotions on promotions.provider_id = providers.id
  14.     where histories.user_id = ?;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top