SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=129 OR sapcdb.iart_ID_stat=151 OR sapcdb.iart_ID_stat=164 OR sapcdb.iart_ID_stat=178 OR sapcdb.iart_ID_stat=180 OR sapcdb.iart_ID_stat=182 OR sapcdb.iart_ID_stat=229 OR sapcdb.iart_ID_stat=262 OR sapcdb.iart_ID_stat=272 OR sapcdb.iart_ID_stat=276 OR sapcdb.iart_ID_stat=280) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=126 OR sapcdb.iart_ID_stat=1088 OR sapcdb.iart_ID_stat=1089 OR sapcdb.iart_ID_stat=1091) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=1052 OR sapcdb.iart_ID_stat=1053 OR sapcdb.iart_ID_stat=1054 OR sapcdb.iart_ID_stat=1056 OR sapcdb.iart_ID_stat=1057 OR sapcdb.iart_ID_stat=1086 OR sapcdb.iart_ID_stat=1087 OR sapcdb.iart_ID_stat=1103 OR sapcdb.iart_ID_stat=1150 OR sapcdb.iart_ID_stat=1151 OR sapcdb.iart_ID_stat=1152 OR sapcdb.iart_ID_stat=1153) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=234 OR sapcdb.iart_ID_stat=1012 OR sapcdb.iart_ID_stat=1013 OR sapcdb.iart_ID_stat=1015 OR sapcdb.iart_ID_stat=1016 OR sapcdb.iart_ID_stat=1017 OR sapcdb.iart_ID_stat=1111 OR sapcdb.iart_ID_stat=1154 OR sapcdb.iart_ID_stat=1155 OR sapcdb.iart_ID_stat=1156 OR sapcdb.iart_ID_stat=1158) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=139 OR sapcdb.iart_ID_stat=253 OR sapcdb.iart_ID_stat=1006 OR sapcdb.iart_ID_stat=1007 OR sapcdb.iart_ID_stat=1008 OR sapcdb.iart_ID_stat=1009 OR sapcdb.iart_ID_stat=1010 OR sapcdb.iart_ID_stat=1067 OR sapcdb.iart_ID_stat=1068 OR sapcdb.iart_ID_stat=1099 OR sapcdb.iart_ID_stat=1100 OR sapcdb.iart_ID_stat=1122) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=128 OR sapcdb.iart_ID_stat=148 OR sapcdb.iart_ID_stat=160 OR sapcdb.iart_ID_stat=216 OR sapcdb.iart_ID_stat=1001 OR sapcdb.iart_ID_stat=1041 OR sapcdb.iart_ID_stat=1110 OR sapcdb.iart_ID_stat=1115 OR sapcdb.iart_ID_stat=1116 OR sapcdb.iart_ID_stat=1133 OR sapcdb.iart_ID_stat=1143) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=133 OR sapcdb.iart_ID_stat=156 OR sapcdb.iart_ID_stat=159 OR sapcdb.iart_ID_stat=166 OR sapcdb.iart_ID_stat=172 OR sapcdb.iart_ID_stat=186 OR sapcdb.iart_ID_stat=188 OR sapcdb.iart_ID_stat=190 OR sapcdb.iart_ID_stat=196 OR sapcdb.iart_ID_stat=198 OR sapcdb.iart_ID_stat=208 OR sapcdb.iart_ID_stat=228 OR sapcdb.iart_ID_stat=241 OR sapcdb.iart_ID_stat=249 OR sapcdb.iart_ID_stat=255 OR sapcdb.iart_ID_stat=345 OR sapcdb.iart_ID_stat=1004 OR sapcdb.iart_ID_stat=1018 OR sapcdb.iart_ID_stat=1022 OR sapcdb.iart_ID_stat=1023 OR sapcdb.iart_ID_stat=1024 OR sapcdb.iart_ID_stat=1025 OR sapcdb.iart_ID_stat=1026 OR sapcdb.iart_ID_stat=1027 OR sapcdb.iart_ID_stat=1028 OR sapcdb.iart_ID_stat=1030 OR sapcdb.iart_ID_stat=1034 OR sapcdb.iart_ID_stat=1035 OR sapcdb.iart_ID_stat=1045 OR sapcdb.iart_ID_stat=1058 OR sapcdb.iart_ID_stat=1059 OR sapcdb.iart_ID_stat=1060 OR sapcdb.iart_ID_stat=1062 OR sapcdb.iart_ID_stat=1063 OR sapcdb.iart_ID_stat=1064 OR sapcdb.iart_ID_stat=1065 OR sapcdb.iart_ID_stat=1069 OR sapcdb.iart_ID_stat=1072 OR sapcdb.iart_ID_stat=1073 OR sapcdb.iart_ID_stat=1074 OR sapcdb.iart_ID_stat=1075 OR sapcdb.iart_ID_stat=1076 OR sapcdb.iart_ID_stat=1077 OR sapcdb.iart_ID_stat=1078 OR sapcdb.iart_ID_stat=1092 OR sapcdb.iart_ID_stat=1093 OR sapcdb.iart_ID_stat=1095 OR sapcdb.iart_ID_stat=1096 OR sapcdb.iart_ID_stat=1097 OR sapcdb.iart_ID_stat=1101 OR sapcdb.iart_ID_stat=1102 OR sapcdb.iart_ID_stat=1104 OR sapcdb.iart_ID_stat=1105 OR sapcdb.iart_ID_stat=1118 OR sapcdb.iart_ID_stat=1119 OR sapcdb.iart_ID_stat=1120 OR sapcdb.iart_ID_stat=1125 OR sapcdb.iart_ID_stat=1126 OR sapcdb.iart_ID_stat=1134 OR sapcdb.iart_ID_stat=1135 OR sapcdb.iart_ID_stat=1136 OR sapcdb.iart_ID_stat=1137 OR sapcdb.iart_ID_stat=1138 OR sapcdb.iart_ID_stat=1139 OR sapcdb.iart_ID_stat=1140 OR sapcdb.iart_ID_stat=1141 OR sapcdb.iart_ID_stat=1142 OR sapcdb.iart_ID_stat=1144 OR sapcdb.iart_ID_stat=1145 OR sapcdb.iart_ID_stat=1148 OR sapcdb.iart_ID_stat=1149) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre
SELECT sapcdb_fam.* FROM sapcdb_fam,cat_fam_stats,sapcdb WHERE sapcdb.iart_stock>0 AND sapcdb.publi=1 AND sapcdb_fam.id=cat_fam_stats.id_stat AND sapcdb.iart_ID_stat=sapcdb_fam.id AND sapcdb.iart_ID_STAT=sapcdb_fam.id AND (sapcdb.iart_ID_stat=120 OR sapcdb.iart_ID_stat=121 OR sapcdb.iart_ID_stat=141 OR sapcdb.iart_ID_stat=155 OR sapcdb.iart_ID_stat=157 OR sapcdb.iart_ID_stat=167 OR sapcdb.iart_ID_stat=170 OR sapcdb.iart_ID_stat=1031 OR sapcdb.iart_ID_stat=1047 OR sapcdb.iart_ID_stat=1048 OR sapcdb.iart_ID_stat=1049 OR sapcdb.iart_ID_stat=1085) GROUP BY sapcdb_fam.id ORDER BY ordre_fam, ordre