BEST PRICE
GUARANTEED
Get the best value for money on over 7000 products.
CASH ON
DELIVERY
Avoid the hassle of card payments. Pay on Delivery (Island wide)
SAFE AND
SECURED
Secure packing for the safety of your items
NEED HELP?
CONTACT US
- Our Hotline: 077 712 9412
- Email us: Info@Onex.lk
Warning: mysqli_query(): (HY000/1021): Disk full (/tmp/#sql_629_20.MAI); waiting for someone to free some space... (errno: 28 "No space left on device") in /home/onex.lk/public_html/wp-includes/class-wpdb.php on line 2431
WordPress database error: [Disk full (/tmp/#sql_629_20.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")]
SELECT SQL_CALC_FOUND_ROWS wpxp_posts.ID
FROM wpxp_posts LEFT JOIN wpxp_term_relationships ON (wpxp_posts.ID = wpxp_term_relationships.object_id) INNER JOIN wpxp_postmeta ON ( wpxp_posts.ID = wpxp_postmeta.post_id )
WHERE 1=1 AND (
wpxp_posts.ID NOT IN (
SELECT object_id
FROM wpxp_term_relationships
WHERE term_taxonomy_id IN (7)
)
AND
(
wpxp_term_relationships.term_taxonomy_id IN (3238)
)
) AND (
( wpxp_postmeta.meta_key = '_stock_status' AND wpxp_postmeta.meta_value NOT IN ('outofstock') )
) AND wpxp_posts.post_type = 'product' AND ((wpxp_posts.post_status = 'publish'))
GROUP BY wpxp_posts.ID
ORDER BY wpxp_posts.post_title ASC
LIMIT 0, 12
OUR BRANDS
