Artwork_sort
string(86) " ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "




sql_swipe
string(1810) "SELECT tbl_artwork.id,tbl_artwork.id_artist FROM tbl_artwork
    LEFT JOIN tbl_contact as artist ON (tbl_artwork.id_artist = artist.id)
    LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id and tbl_artwork_multiple.premiere_dispo = 1
    WHERE
    ( tbl_artwork.published = 'on' or tbl_artwork.stock = 'on' )
    and tbl_artwork_multiple.premiere_dispo = 1
     and ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) and tbl_artwork.custom_field_8 !='0000-00-00' ) and  (tbl_artwork.custom_field_9 >= DATE(NOW()) or tbl_artwork.custom_field_9 ='0000-00-00' )) 
     AND (( artist.prenom LIKE '%Philippe%' OR
        artist.nom LIKE '%Philippe%' OR
        tbl_artwork.title LIKE '%Philippe%' OR
        tbl_artwork.year LIKE '%Philippe%' OR
        tbl_artwork.serie LIKE '%Philippe%' OR
        tbl_artwork.collection LIKE '%Philippe%' OR
        tbl_artwork.dimension LIKE '%Philippe%' OR
        tbl_artwork.dimension_en LIKE '%Philippe%' OR
        tbl_artwork.technic LIKE '%Philippe%' OR
        tbl_artwork.technic_en LIKE '%Philippe%' OR
        tbl_artwork.custom_field_2 LIKE '%Philippe%' ) AND ( artist.prenom LIKE '%Druillet%' OR
        artist.nom LIKE '%Druillet%' OR
        tbl_artwork.title LIKE '%Druillet%' OR
        tbl_artwork.year LIKE '%Druillet%' OR
        tbl_artwork.serie LIKE '%Druillet%' OR
        tbl_artwork.collection LIKE '%Druillet%' OR
        tbl_artwork.dimension LIKE '%Druillet%' OR
        tbl_artwork.dimension_en LIKE '%Druillet%' OR
        tbl_artwork.technic LIKE '%Druillet%' OR
        tbl_artwork.technic_en LIKE '%Druillet%' OR
        tbl_artwork.custom_field_2 LIKE '%Druillet%' ) )
    GROUP BY tbl_artwork.id
     ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC "




nb_total
int(5)




sql
string(1804) "SELECT tbl_artwork.id FROM tbl_artwork
    LEFT JOIN tbl_contact as artist ON (tbl_artwork.id_artist = artist.id)
    LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id and tbl_artwork_multiple.premiere_dispo = 1
    WHERE
    ( tbl_artwork.published = 'on' or tbl_artwork.stock = 'on' )
    and tbl_artwork_multiple.premiere_dispo = 1
     and ( ( tbl_artwork.custom_field_8 <= DATE(NOW()) and tbl_artwork.custom_field_8 !='0000-00-00' ) and  (tbl_artwork.custom_field_9 >= DATE(NOW()) or tbl_artwork.custom_field_9 ='0000-00-00' )) 
     AND (( artist.prenom LIKE '%Philippe%' OR
        artist.nom LIKE '%Philippe%' OR
        tbl_artwork.title LIKE '%Philippe%' OR
        tbl_artwork.year LIKE '%Philippe%' OR
        tbl_artwork.serie LIKE '%Philippe%' OR
        tbl_artwork.collection LIKE '%Philippe%' OR
        tbl_artwork.dimension LIKE '%Philippe%' OR
        tbl_artwork.dimension_en LIKE '%Philippe%' OR
        tbl_artwork.technic LIKE '%Philippe%' OR
        tbl_artwork.technic_en LIKE '%Philippe%' OR
        tbl_artwork.custom_field_2 LIKE '%Philippe%' ) AND ( artist.prenom LIKE '%Druillet%' OR
        artist.nom LIKE '%Druillet%' OR
        tbl_artwork.title LIKE '%Druillet%' OR
        tbl_artwork.year LIKE '%Druillet%' OR
        tbl_artwork.serie LIKE '%Druillet%' OR
        tbl_artwork.collection LIKE '%Druillet%' OR
        tbl_artwork.dimension LIKE '%Druillet%' OR
        tbl_artwork.dimension_en LIKE '%Druillet%' OR
        tbl_artwork.technic LIKE '%Druillet%' OR
        tbl_artwork.technic_en LIKE '%Druillet%' OR
        tbl_artwork.custom_field_2 LIKE '%Druillet%' ) )
    GROUP BY tbl_artwork.id
     ORDER BY artist.nom ASC,artist.prenom ASC,tbl_artwork.year ASC,tbl_artwork.title ASC 
    LIMIT 0, 8"




GET
array(7) {
  ["lang"]=>
  string(2) "fr"
  ["page"]=>
  string(9) "recherche"
  ["view"]=>
  string(8) "resultat"
  ["id"]=>
  string(1) "0"
  ["name"]=>
  string(9) "recherche"
  ["?paged"]=>
  string(0) ""
  ["sq"]=>
  string(17) "Philippe Druillet"
}




artwork_ids
array(5) {
  [0]=>
  string(5) "22162"
  [1]=>
  string(5) "24286"
  [2]=>
  string(5) "22379"
  [3]=>
  string(4) "1212"
  [4]=>
  string(5) "17705"
}