Access address from prestashop

[tijojoel]

Hi,

 

To retrieve the address from prestashop I am using this query

 

INNER JOIN ps_address shpadd ON
shpadd.id_address=ps_orders.id_address_delivery
INNER JOIN ps_address invadd ON
invadd.id_address=ps_orders.id_address_invoice

LEFT JOIN ps_country shpcountry ON
shpcountry.id_country = shpadd.id_country
LEFT JOIN ps_country invcountry ON
invcountry.id_country = invadd.id_country

LEFT JOIN ps_country_lang shpcountry_lang ON
shpcountry_lang.id_country = shpadd.id_country
LEFT JOIN ps_country_lang invcountry_lang ON
invcountry_lang.id_country = invadd.id_country

 

LEFT JOIN ps_state shpstate ON
shpstate.id_state=shpadd.id_state
LEFT JOIN ps_state invstate ON
invstate.id_state=invadd.id_state

 

 

It takes too much time to load(even will not execute). What is the alternate method to replace this query? 

N.B - This is a part of query