exhibitionPeriod
string(7) "Current"
searchCritea
array(2) {
[0]=>
array(3) {
["libele"]=>
string(10) "Artiste : "
["data"]=>
string(11) "Milo Manara"
["field"]=>
string(6) "artist"
}
[1]=>
array(3) {
["libele"]=>
string(10) "Nouveautés"
["data"]=>
string(10) "Nouveautés"
["field"]=>
string(11) "new_artwork"
}
}
Artwork_search
string(1658) " AND artist.id = 189 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 tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52665,52672,52673,52683,52684,52685,52686,52687,52688,52689,52690,52691,52692,52693,52694,52698,52699,52700,52701,52702,52703,52704,52705,52706,52707,52708,52709,52710,52711,52712,52713,52714,52715,52716,52717,52718,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52732,52733,52735,52736,52737,52738,52739,52740,52741,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52772,52773,52774,52775,52776,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52831,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) "
Artwork_sort
string(42) " ORDER BY tbl_artwork.custom_field_8 DESC "
sql_swipe
string(2085) "SELECT DISTINCT tbl_artwork.id,tbl_artwork.id_artist,tbl_artwork.medium 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.stock='on' AND artist.id = 189 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 tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52665,52672,52673,52683,52684,52685,52686,52687,52688,52689,52690,52691,52692,52693,52694,52698,52699,52700,52701,52702,52703,52704,52705,52706,52707,52708,52709,52710,52711,52712,52713,52714,52715,52716,52717,52718,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52732,52733,52735,52736,52737,52738,52739,52740,52741,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52772,52773,52774,52775,52776,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52831,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC "
TOTAL ITEM SQL
NULL
TOTAL ITEM
int(38)
TOTAL PAGES
float(3)
sql
string(2079) "
SELECT DISTINCT
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.stock='on' AND artist.id = 189 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 tbl_artwork.type !='artwork' AND tbl_artwork.id NOT IN (47290,47291,47295,47296,47299,51086,51087,51091,52401,52402,52403,52404,52405,52406,52407,52408,52409,52410,52665,52672,52673,52683,52684,52685,52686,52687,52688,52689,52690,52691,52692,52693,52694,52698,52699,52700,52701,52702,52703,52704,52705,52706,52707,52708,52709,52710,52711,52712,52713,52714,52715,52716,52717,52718,52719,52720,52721,52722,52723,52724,52725,52726,52727,52728,52729,52730,52731,52732,52733,52735,52736,52737,52738,52739,52740,52741,52742,52743,52744,52745,52746,52747,52748,52749,52751,52752,52753,52754,52755,52756,52757,52758,52759,52760,52762,52763,52764,52765,52766,52767,52768,52769,52770,52772,52773,52774,52775,52776,52777,52778,52779,52780,52781,52782,52783,52784,52785,52786,52787,52788,52789,52790,52791,52792,52793,52794,52795,52796,52797,52798,52799,52800,52801,52802,52803,52804,52805,52806,52807,52808,52809,52810,52811,52812,52813,52814,52815,52816,52817,52818,52819,52820,52821,52822,52823,52824,52825,52826,52827,52828,52831,52833,52834,52835,52836,52837,52838,52839,52840,52841,52842,52843,52844,52847,52848,52849,52850,52851,52852,52853,52854,52855,52856,52857,52858,52859,52860,52861,52862,52863,52864,52865,52866,52867,52868,52869,52870,52871,52872,52873,52875,52876,52884,52885,52886,52887,52888,52889,52890,52891,52892,52893,52894,52895,52896,52897,52898,52899,52900,52901,52902,52903,52904,52905,52906,52907,52908,52909,53108,53109) AND tbl_artwork_multiple.premiere_dispo = 1 ORDER BY tbl_artwork.custom_field_8 DESC
LIMIT 16, 16"
POST
NULL
GET
array(8) {
["lang"]=>
string(2) "fr"
["page"]=>
string(5) "store"
["view"]=>
string(8) "editions"
["id"]=>
int(0)
["name"]=>
string(28) "huberty-breyne-gallery-store"
["?paged"]=>
string(0) ""
["artist"]=>
string(15) "milo-manara-189"
["paged"]=>
string(1) "2"
}
exhib_search
string(0) ""
openFilter
bool(true)
artwork_ids
array(38) {
[0]=>
string(5) "13669"
[1]=>
string(5) "49766"
[2]=>
string(5) "49764"
[3]=>
string(5) "48546"
[4]=>
string(5) "44720"
[5]=>
string(5) "38707"
[6]=>
string(5) "38709"
[7]=>
string(5) "38711"
[8]=>
string(5) "37534"
[9]=>
string(5) "37536"
[10]=>
string(5) "28032"
[11]=>
string(5) "28033"
[12]=>
string(5) "28034"
[13]=>
string(5) "28035"
[14]=>
string(5) "28012"
[15]=>
string(5) "28029"
[16]=>
string(5) "28030"
[17]=>
string(5) "28031"
[18]=>
string(5) "13544"
[19]=>
string(5) "12034"
[20]=>
string(5) "12040"
[21]=>
string(5) "12256"
[22]=>
string(5) "12267"
[23]=>
string(5) "12271"
[24]=>
string(5) "30155"
[25]=>
string(5) "13543"
[26]=>
string(5) "13546"
[27]=>
string(5) "12016"
[28]=>
string(5) "13547"
[29]=>
string(5) "12022"
[30]=>
string(5) "13548"
[31]=>
string(5) "12025"
[32]=>
string(5) "13550"
[33]=>
string(5) "12026"
[34]=>
string(5) "12027"
[35]=>
string(5) "12028"
[36]=>
string(5) "12029"
[37]=>
string(5) "12031"
}
publicLeftJoin TEST FROM PC FIX
string(126) " LEFT JOIN tbl_artwork_multiple ON tbl_artwork_multiple.id_artwork=tbl_artwork.id AND tbl_artwork_multiple.premiere_dispo = 1 "