Ofertas de Pintura

Filtrar por...

Array
(
    [select] =>  
                SELECT CON.category_id, 
                       CON.id_content, CON.object_id as id,
                       CON.title, CON.description, 
                       CON.code, 
                       CON.id_type as type,
                       CON.dpublished, 
                        IF( (MET.url_directo IS NOT NULL) AND (MET.url_directo <>''), 
                            CONCAT('https://www.moranomyh.com.ar/special/',MET.url_directo),    
                            CON.url_directo 
                        ) as url_directory   
                        
                
    [count] =>  SELECT IFNULL(COUNT(CON.id_content),0) AS count  
    [from] =>  FROM aux_tbl_con_searcher CON 
                        INNER JOIN tbl_con_content_category CAT ON CAT.id_category = CON.category_id  
                            LEFT JOIN tbl_con_content_meta AS MET ON MET.id_content = CON.id_content AND MET.estado = 'A'   LEFT JOIN tbl_con_content_article_property_option AS APO ON APO.id_content = CON.id_content AND 
                                        APO.id_property = 1 
    [where] =>  
                        WHERE CON.estado = 'A' AND CON.ipublishedx = 1 AND CON.dpublished <= NOW()  
                              AND ( CON.id_type <> 1 OR (CON.id_type = 1 AND CON.value  > 0) ) 
                                 AND CAT.root_direct LIKE '/pintura/%'  AND CON.has_discount = 1 AND CON.id_type = 1  AND CON.id_type = 1    
                       
    [order] =>  ORDER BY  APO.id_option='18' DESC, APO.id_option='20' DESC, APO.id_option='21' DESC, APO.id_option='22' DESC, APO.id_option='33' DESC, APO.id_option='41' DESC, APO.id_option='48' DESC
    [limit] =>  LIMIT 0 , 8 
)